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

Query Utility Information

The Query Utility report is generated automatically for BACKUP, RESTORE, and REMOVE. This report shows the type of maintenance function that was performed by DQLIBRMT for the Query Library Table member named.

Sample Report

Following is an example of the CA Dataquery Query Maintenance Report showing query utility information:

Date: mm/dd/ccyy     ***********************************************************************         Page:     1
                     *             CA Dataquery for CA Datacom                             *
Time: hh.mm.ss       *               Query Maintenance Report                              *      Version: 14.0
                     *        Copyright © 1990-2011 CA. All rights reserved.               *
DQ Base    3         ***********************************************************************   DD Base    2


                                                  QUERY UTILITY REPORT

* MEMBER-NAME *    *TYPE*    *STA*   *----------- AUTHOR -----------* *-- GROUP 1 --* *-- GROUP 2 --* *-- GROUP 3 --*
                                     FUNCTION   *---------------------- DESCRIPTION -----------------------*

testupshift        QUERY      PVT    DQUSER
                                     BACKUP     testing upshift for language
                          CONTROL STATEMENT: BACKUP    NAME=DQUSER                                                   00000588
------------------------------------------------------------------------------------------------------------------------
A                  QUERY      PVT    DQUSER                           DALLAS          DATACOM         DATAQUERY
                                     BACKUP
                          CONTROL STATEMENT: BACKUP    NAME=DQUSER                                                   00000588
------------------------------------------------------------------------------------------------------------------------
ABC1               QUERY      PVT    DQUSER                           DALLAS          DATACOM         DATAQUERY
                                     BACKUP
                          CONTROL STATEMENT: BACKUP    NAME=DQUSER                                                   00000588
------------------------------------------------------------------------------------------------------------------------
ADR-CUST-RECS      QUERY      PUB    DQUSER                           DALLAS          DATACOM         DATAQUERY
                                     BACKUP     ADR-CUST-RECS FOR TEXAS
                          CONTROL STATEMENT: BACKUP    NAME=DQUSER                                                   00000588
------------------------------------------------------------------------------------------------------------------------
ASSOC-ERROR        QUERY      PUB    DQUSER                           DALLAS          DATACOM         DATAQUERY
                                     BACKUP     QUERY HAS VALIDATION ERROR
                          CONTROL STATEMENT: BACKUP    NAME=DQUSER                                                   00000588
------------------------------------------------------------------------------------------------------------------------
FNAME1             QUERY      PVT    DQUSER                           DALLAS          DATACOM         DATAQUERY
                                     BACKUP
                          CONTROL STATEMENT: BACKUP    NAME=DQUSER                                                   00000588

Following is an explanation of the log information found on the report:

Report Description

FUNCTION

Shows the type of maintenance function performed by DQLIBMT for the query named.

BACKUP

The query has been copied to a sequential tape or disk file.

REMOVE

The query has been removed from the Query Library Table for the named user.

RESTORE

The query has been added to the Query Library Table from a backup tape or disk file.

MEMBER-NAME

Identifies the member on which maintenance was performed.

TYPE

Shows whether the member is a query, dialog, JCL member, PROC, term.

STA

Shows whether the member named is public (PUB) or private (PVT). Under PUB or PVT is the item CONTROL STATEMENT, which shows the job control statement used to perform the maintenance function.

AUTHOR

Identifies the query's author.

DESCRIPTION

Provides the member description, if any, attached by the author.

GROUPS

Lists the groups associated with each Query Library Table member that is printed.