Preparing and Maintaining the CA Dataquery System Tables › DQR: SQL Recovery Table

DQR: SQL Recovery Table

This table is used to recover the SQL found sets in the DQE table. It also contains some record-keeping data such as, who created the SQL Found Set, when it was created, and so forth.

For recovery purposes, DQE sets are of three types:

• Batch sets created for queries run in DQBATCH
• Single use online sets
• Multi-use online sets subsequently used for network or offline print

Normally, all are freed as soon as no longer needed, but in case of abends or system failures, they must be recovered.

At the start of DQBATCH, any sets older than the time specified by RTIMDQE= are freed. At signon time online, when the operator owning the single and multi-user sets signs on, these are recovered when RTIMDQE= has expired.

Preparing the DQR

To prepare the DQR:

• Allocate ten tracks.
• Initialize the area.
• Null load the table.

SYNCHRONIZE. If the DQR is initialized, the DQE, DQF, and DQS must also be initialized. If the SQL option is not installed, synchronize only the DQR and the DQF.