QUSRBRM.CONTROL_GROUP_JOB_QUEUE View

The QUSRBRM.CONTROL_GROUP_JOB_QUEUE view shows the job queues to process during a BRMS control group backup.

The values returned for the columns in this view are similar to the values returned by the Work with Backup Control Groups (WRKCTLGBRM *BKU) command option 10 to display the job queues to process.

Authorization:

The authorization ID of the statement must include the following privileges:

*OBJOPR and *READ authority to the QUSRBRM/CG_JOBQ *FILE object.

Result Table

The following table describes the columns in the view. The schema is QUSRBRM.

Column Name	System Column Name	Data Type	Description
CONTROL_GROUP	CGNAME	VARCHAR(10)	The name of the BRMS control group.
LIST_SEQUENCE	LIST_SEQ	INTEGER	The sequence of the entry within the CONTROL_GROUP. Sequence numbers range from 1 through 9999. The lowest number indicates the entry to be processed first and the highest number indicates the entry to be processed last.
JOB_QUEUE_LIBRARY	JOBQ_LIB	VARCHAR(10)	The library of the job queue to be processed. The possible values are: LIBL Include the libraries in your library list. library-name* The library for the job queue that you want to process.
JOB_QUEUE_NAME	JOBQ_NAME	VARCHAR(10)	The name of the job queue to be processed. The possible values are: job-queue-name The name of the job queue you want to process.
HOLD_JOB_QUEUE	HOLD_JOBQ	VARCHAR(3) Nullable	Specifies whether to hold the specified job queue when control group processing begins. The possible values are: YES The specified job queue will be held at the start of control group processing. NO The specified job queue will not be held at the start of control group processing.
RELEASE_JOB_QUEUE	RLS_JOBQ	VARCHAR(3) Nullable	Specifies whether to release the specified job queue when control group processing ends. The possible values are: YES The specified job queue will be released at the end of control group processing. NO The specified job queue will not be released at the end of control group processing.

Example 1 - Display the job queues to process for control group *BKUGRP:

SELECT LIST_SEQUENCE, JOB_QUEUE_NAME, JOB_QUEUE_LIBRARY, HOLD_JOB_QUEUE, RELEASE_JOB_QUEUE FROM QUSRBRM.CONTROL_GROUP_JOB_QUEUE WHERE CONTROL_GROUP = ‘*BKUGRP’

Example output:

LIST_SEQUENCE	JOB_QUEUE_NAME	JOB_QUEUE_LIBRARY	HOLD_JOB_QUEUE	RELEASE_JOB_QUEUE
10	QBATCH	*LIBL	YES	YES