Preparing and Maintaining the CA Dataquery System Tables › Calculating Sizes for System Tables › Tables with Set Allocations

Tables with Set Allocations

Use the following guidelines:

DQM - Literals Table

(DQM area) Allocate 60 tracks to allow space for some translation.

DQP - Panel Table

(DQM area) Allocate 60 tracks to allow space for some translation.

DQQ - Query Library Table

Allocate a minimum of 20 tracks.

DQR - SQL Recovery Table

Allocate 10 tracks.

DQS - Spool Table

An allocation of 10 tracks is usually sufficient for the Spool Table (DQS).

DQU - User Table

Allocate a minimum of 20 tracks.

DQV - Vocabulary Table

(DQM area) Allocate 60 tracks to allow space for some translation.

The allocations for the DQE, DQF, and DQW are site-specific. Instructions for estimating the appropriate allocation for your site follow the description of each of these tables later in this chapter.