Preparing and Maintaining the CA Dataquery System Tables › DQU: User Table

DQU: User Table

The DQU (User Table) stores the definitions of valid CA Dataquery users. It contains user attributes such as name, password, language, system options, and function authorizations. This information validates a user at signon and verifies function authorizations. The DQU is accessed when users are maintained and when users sign on. The DQU can be queried.

Description

Each user requires a logical row of 350 bytes. The default block size is 4096 bytes. The maximum number of logical rows each physical block can contain is dependent upon whether or not compression is used and whether compression is effective. Give future growth due consideration when calculating space requirements.

During installation, for new users, the DQU is created with one user definition called DATACOM-INSTALL.

Enlarging the DQU

If you want to enlarge the table after installation:

1. Use the DBUTLTY BACKUP function to backup the table. See the CA Datacom/DB DBUTLTY Reference Guide for details.
2. Allocate the space.
3. Initialize the space using the DBUTLTY INIT Data Area function. See the CA Datacom/DB DBUTLTY Reference Guide for details.
4. Load the DQU using the DBUTLTY LOAD Data Area function. See the CA Datacom/DB DBUTLTY Reference Guide for details.

Maintaining the DQU

The DQU content is maintained through the USER option of the CA Dataquery Administrative Menu or the DQUSERMT utility. For details, see Performing User Table Maintenance (DQUSERMT).

Backing Up the DQU

The DQU should be backed up as changes occur. To backup the DQU, backup the table using the DBUTLTY BACKUP Data Area function. See the CA Datacom/DB DBUTLTY Reference Guide for details.

Restoring the DQU

To restore the DQU, load the DQU backup using the DBUTLTY LOAD Data Area function. See the CA Datacom/DB DBUTLTY Reference Guide.

SYNCHRONIZE. If you reload the DQU, you should then NULL load the DQF, DQS, DQR, and DQE tables and run DQWFINIT against the DQF and DQE tables. (Omit the DQE and DQR tables if the SQL option is not installed.)

Recovering the DQU

If the DQU is lost due to system catastrophe:

If you have a backup:

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

If you do not have a backup:

• Reallocate the table.
• Initialize the table using the DBUTLTY INIT Data Area function. See the CA Datacom/DB DBUTLTY Reference Guide for details.
• Run DQUSERMT with the input statement CREATE to add the user DATACOM-INSTALL, then add other users.

SYNCHRONIZE. If you reload the DQU, you should then NULL load the DQF, DQS, DQR, and DQE tables and run DQWFINIT against the DQF and DQE tables. (Omit the DQE and DQS tables if the SQL option is not installed.)