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

JCL Examples

You can use the following examples to execute DQLIBRMT.

The DQLIBRMT Utility control statements process the maintenance functions BACKUP, RESTORE, and REMOVE before processing any REPORT control statements. If you put a REPORT control statement before a BACKUP control statement in your job stream, DQLIBRMT processes the BACKUP control statement first. The data from the BACKUP control statement is not reflected on the report that was created by the preceding REPORT control statement.

Sample z/OS JCL

 //jobname    See Preparing JCL for Batch CA Dataquery Utilities.

 //       EXEC PGM=DQLIBRMT

 //STEPLIB    See Preparing JCL for Batch CA Dataquery Utilities.

 //SYSUDUMP DD SYSOUT=*

 //SYSPRINT DD SYSOUT=*                            Print Output

A//DQBKPFIL DD DSN=... See Preparing JCL for Batch CA Dataquery Utilities.

 //DQRSTFIL DD DSN=... See Preparing JCL for Batch CA Dataquery Utilities.

 //SYSIN    DD *                                   Command input

    (DQLIBRMT Utility Control Statements)

 /*

 //

A

DQBKPFIL is an output data set for a DQLIBRMT backup of Query Library members. DQBKPFIL is a sequential file that can reside on tape or disk. This statement is needed only in JCL specifying a DQLIBRMT backup.

DQRSTFIL is an input data set of Query Library members to be added to the Query Library Table as requested by a DQLIBRMT RESTORE control statement. This data set must have been created by a previous execution of DQLIBRMT and is needed only if a restore is requested.

Sample z/VSE JCL

 * $$ JOB ...           See Preparing JCL for Batch CA Dataquery Utilities.

 * $$ LST ...

 // JOB name

 // EXEC PROC=procname  Whether you use PROCs or LIBDEFs, see Preparing JCL for Batch CA Dataquery Utilities.

 // ASSGN  SYS010,X'...'  See Preparing JCL for Batch CA Dataquery Utilities.

A

 // TLBL DQQBKPT

 // EXEC DQLIBRMT

     (DQLIBRMT Utility Control Statements)

 /*

 /&

 * $$ EOJ

A

DQQBKPT is an output tape data set for a DQLIBRMT backup of Query Library members as requested by BACKUP control statements. This data set must be on SYS010 and is needed only if tape backup is requested. If disk backup is requested, use the DQQBKPD control statement.

DQQBKPD is an output disk data set for a DQLIBRMT backup of Query Library members as requested by backup control statements. This data set must be on SYS011 and is needed only if disk backup is requested.

DQQRSTT is an input tape data set of Query Library members created by a previous execution of DQLIBRMT. The members are to be added to the Query Library Table as requested by the DQLIBRMT RESTORE control statement. This data set must be on SYS011 and is needed only if a restore from tape is requested. If restore from disk is requested, use DQQRSTD.

DQQRSTD is an input disk data set of Query Library members created by a previous execution of DQLIBRMT. The members are to be added to the Query Library Table as requested by the DQLIBRMT RESTORE control statement. This data set must be on SYS011 and is needed only if restore from disk is requested.