Managing Your Query Library Table › Performing Query Table Maintenance (DQLIBRMT)

Performing Query Table Maintenance (DQLIBRMT)

Use the DQLIBRMT utility to perform the following maintenance tasks on the Query Library Table:

• Delete all or selected members for selected users, or groups.
• Back up all queries, dialogs, terms, JCL, and PROC members or selected members from the Query Library Table to tape or disk.

  Note: You can select members for deletion and backups by group, date or user, but not a combination of the three.

• Restore all or selected members to the Query Library Table from a tape or disk file. This allows selected queries to be moved from one system to another, such as from a test system to a production system.
• Add a member from SYSIN in z/OS or SYSIPT in z/VSE.

  Note: Do not use DQLIBRMT as a system backup. You can back up only queries, dialogs, terms, JCL, and PROC members. Conditions and restrictions are not backed up. To back up every Query Library Table member, use the DBUTLTY BACKUP function. See the CA Datacom/DB DBUTLTY Reference Guide for details.

Print Reports

The DQLIBRMT utility can be used to print maintenance reports that provide the following types of information:

• Directory report lists selected user's query and type.
• Query Text report shows selected user's query text, or JCL.
• Query Utility report shows maintenance functions per query.
• Status report lists any errors that occur during query maintenance.

The CA Dataquery Query Library Table (DQQ), stores queries, dialogs, terms, PROCs, JCL members, conditions, and restrictions. CA Dataquery controls additions and modifications of these members and definitions in the Query Library Table in the online environment. The Query Utility and Status Listing reports are created while the maintenance functions are being performed. The Directory and Query Text report functions can be run at any time. They are not dependent upon the performance of the maintenance functions.

Use the DQLIBRMT utility to back up, restore, or delete Query Library Table members selectively. For example, whenever a CA Dataquery user leaves the company or is transferred, run a Query Text report to view the user's Query Library Table members. Decide to reassign or delete the Query Library Table members.