Preparing and Maintaining the CA Dataquery System Tables › DQM Area

DQM Area

The DQM area consists of the following CA Dataquery system tables:

DQM (Literals Table)

Is used to store literal values that are output by the CA Dataquery system. These literal values are keywords and phrases that are commonly used by the CA Dataquery system. Storing them on this table facilitates their translation to other languages by the CA Dataquery Language Maintenance Facility.

DQP (Panel Table)

Is used to store the panel images that collectively comprise the CA Dataquery External Online Interface. Storing panel images on this table facilitates their translation into other languages by the CA Dataquery Language Maintenance Facility. Any translated versions are also stored on this table. CA Dataquery provides a utility for printing all CA Dataquery panels, called DQPANPRT. Instructions for using this utility appear in the CA Dataquery Administrator Guide.

DQV (Vocabulary Table)

Is used to store Language and Command keywords that a CA Dataquery user would enter into the system. Storing these keywords on this table facilitates their translation into other languages by the CA Dataquery Language Maintenance Facility.

The DQM tables are accessed when CA Dataquery is to display data on the terminal and when data is supplied to CA Dataquery by the user.

Description

The DQM area consists of a group of physical blocks that vary in size depending on the device type. The logical row length of the DQM table is 92 bytes, the DQP table is 2008 bytes, the DQV table is 92 bytes. The default block size for the DQM area is 4096 bytes. You can modify these as needed.

Translation Concerns

During installation, the DQM area is loaded with American English text. If your site plans to translate or customize the entire CA Dataquery system, you need to allocate additional disk space to store the newly created language. For a complete translation you need 20 tracks on a 3380 disk or in CA Datacom/DB terms, you need 220 blocks of 3584 bytes.

Enlarging the DQM Area

To enlarge the area:

1. Backup the area using the Language Maintenance Utility (DQLANGMT). See Loading and Unloading Languages (DQLANGMT) for details.
2. Allocate the disk space.
3. Initialize the space using the DBUTLTY INIT Data Area function. See the CA Datacom/DB DBUTLTY Reference Guide for details.
4. Null load the DQM using the DBUTLTY LOAD Data Area function. See the CA Datacom/DB DBUTLTY Reference Guide for details.
5. Restore the language from the backup using DQLANGMT.

Recovering the DQM

If the DQM area is lost due to system catastrophe:

• If you have done no translation:
  • Load the area from the CA tape following the instructions in the CA Datacom installation documentation.
  • OR, if backed up using DBUTLTY, load the area from your backup using the DBUTLTY LOAD Data Area function. See the CA Datacom/DB DBUTLTY Reference Guide for details.
• If you have done translation, load the area from your backup using the DBUTLTY LOAD Data Area function (if backed up by DBUTLTY). See the CA Datacom/DB DBUTLTY Reference Guide for details. Or, execute the Language Maintenance Utility JCL with RUNTYPE=LOAD, if backed up with Language Maintenance.

  If you have made no backup of the area:

  • Load the area from the CA tape following the instructions in the CA Datacom installation documentation.
  • Retranslate using the Language Maintenance Utility. See the CA Dataquery Administrator.

Backing Up the DQM

The DQM area needs backing up at System Generation time and subsequently if it is changed. To backup the DQM: execute the Language Maintenance Utility JCL with RUNTYPE=UNLOAD. The Language Maintenance Utility also allows you to do a selective backup (unload). To backup (unload) either a language you have created or a CA provided language, replace the RUNTYPE=UNLOAD line of the JCL with RUNTYPE= UNLOAD,LANGUAGE=lc where lc is the language you want to unload. Or, use the DBUTLTY backup data area function.

Restoring the DQM

To restore backup tables, execute the Language Maintenance Utility JCL with RUNTYPE=LOAD. You cannot do a selective restore. Or, use the DBUTLTY load data area function, if backed up using DBUTLTY.