Preparing and Maintaining the CA Dataquery System Tables › DQS: Spool Table

DQS: Spool Table

The DQS (Spool Table) is used to store and control the hardcopy report output of a query that has been routed to an online network printer. When a print is requested, the control information for the print is written to the DQS table. The DQF is read to obtain the data or the pointers to the data to be printed.

Enlarging the DQS

The installation process creates the DQS. The DQS row length is 230 bytes. The default block size is 4096 bytes. If you want to enlarge the table:

1. Allocate the space. Allocate one row for each pending network print request.
2. Initialize the space using the DBUTLTY INIT Data Area function. See the CA Datacom/DB DBUTLTY Reference Guide for details.
3. Null load the DQS using the DBUTLTY LOAD Data Area function. See the CA Datacom/DB DBUTLTY Reference Guide for details.

SYNCHRONIZE. The DQS must be synchronized with the DQF. If the DQS is initialized, the DQE, DQF, and DQR must also be initialized. (Omit the DQE and DQR tables if the SQL option is not installed.)

Maintaining the DQS

The content of the table is maintained through the Printer Control Administrative function.

Backing Up and Restoring the DQS

It is not necessary to back and restore the DQS. Reinitializing the tables restores the DQS.

Recovering the DQS

If the DQS is lost due to system catastrophe:

• Reallocate the table.
• Initialize the table using the DBUTLTY INIT Data Area function. See the CA Datacom/DB DBUTLTY Reference Guide for details.
• Null load the table using the DBUTLTY LOAD Data Area function. See the CA Datacom/DB DBUTLTY Reference Guide for details.

If you must re-create the DQS after a catastrophe, you must also re-create the DQF, DQE, and DQR so that the tables remain synchronous.