Preparing and Maintaining the CA Dataquery System Tables › Maintaining the CA Dataquery System Tables

Maintaining the CA Dataquery System Tables

The physical aspects of CA Dataquery are maintained by the CA Datacom/DB database management system. The CA Dataquery database consists of rows on a CA Datacom/DB Directory (CXX), an index, and twelve tables. Maintenance of the CA Dataquery database is no different from maintenance of any other CA Datacom/DB database, but there are specifications regarding recovery, which are documented in this guide. See the CA Datacom/DB Database and System Administration Guide and the CA Datacom/DB DBUTLTY Reference Guide for details about system tasks, including:

• Maintaining the CA Datacom/DB Directory (CXX)— backing up and restoring the Directory containing the definitions of the CA Dataquery tables. You can also print a report of those definitions.
• Unloading tables— unloading an individual CA Dataquery table (for example, as a backup or for subsequent reloading).
• Loading tables— loading a particular CA Dataquery area and restoring a backup copy of a table.
• Maintaining the index— initializing, rebuilding, and reporting on the index.
• Retrieving tables— restoring a table if the database index has been destroyed and reloading it.
• Backing up tables— CA Dataquery tables should be included in normal site backup procedures. Regular backup for the DQQ and DQU tables is especially important since these tables contain data that is not easily re-created in case of a system malfunction. For more information, see Scheduling System Table Backups.

CA Dataquery Utilities

CA Dataquery provides the following batch utilities to maintain its tables.

• The Language Maintenance Utility, DQLANGMT, is used to backup and restore the DQM, DQP, and DQV tables.
• The Query Library Table Maintenance Utility, DQLIBRMT, is used to maintain the DQQ table:
  • Delete all or selected members for selected users or groups
  • Backup queries, dialogs, terms, JCL and PROC members
  • Restore all or selected members to the DQQ from tape or disk
  • Print maintenance reports
  • Add members
• The Found Table Maintenance Utility, DQWFINIT, used to initialize the DQE, DQF, and DQW tables.