Previous Topic: DQM AreaNext Topic: DQR: SQL Recovery Table

Preparing and Maintaining the CA Dataquery System Tables › DQQ: Query Library Table

DQQ: Query Library Table

The DQQ (Query Library Table) is used to store query text members, JCL members, PROCs, terms, condition and restriction definitions, and dialogs. The DQQ is accessed when you SAVE, UPDATE, or EDIT a query.

During installation, for new users, the DQQ is created with one sample query loaded in it.

Description

The logical row length of the DQQ is 2200 bytes long. The default block size is 4096 bytes. When allocating space for the DQQ, allow one physical block for each page of each query to be saved, one for each term, and one for each restricted condition row. Allow some space for future growth.

Enlarging the DQQ

If you want to enlarge the table after installation:

  1. Use the DBUTLTY BACKUP function to backup the table. For more information, see the CA Datacom/DB DBUTLTY Reference Guide.
  2. Allocate the space.
  3. Initialize the space using the DBUTLTY INIT Data Area function. For more information, see the CA Datacom/DB DBUTLTY Reference Guide.
  4. Load the DQQ using the DBUTLTY LOAD Data Area function. For more information, see the CA Datacom/DB DBUTLTY Reference Guide.

Maintaining the DQQ

The content of the DQQ is maintained by the CA Dataquery Administrator using DQLIBRMT. This utility is used to add, delete, backup, and restore members to maintain the content of the table but it is not intended for complete backups. Use DBUTLTY for standard table maintenance.

Backing Up the DQQ

The DQQ should be backed up on a daily basis. To backup the DQQ, use the DBUTLTY BACKUP Data Area function.

Restoring the DQQ

To restore a backup, use the DBUTLTY LOAD Data Area function.

Recovering the DQQ

If the DQQ is lost due to system catastrophe, you must:

  1. Reallocate the space.
  2. Initialize the table using the DBUTLTY INIT Data Area function. See the CA Datacom/DB DBUTLTY Reference Guide for details.
  3. Load the backup using the DBUTLTY LOAD Data Area function. See the CA Datacom/DB DBUTLTY Reference Guide for details.