QUSRBRM.BACKUP_SPLF_LIST View

The QUSRBRM.BACKUP_SPLF_LIST view shows BRMS backup spooled file lists defined for the system.

The values returned for the columns in this view are similar to the values returned by the Work with Backup Lists (WRKLBRM *BKU) command option 5 to display the entries in a *SPL type list.

Authorization:

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

*OBJOPR and *READ authority to the QUSRBRM/BKU_SPLLST *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
LIST_NAME	LIST_NAME	VARCHAR(10)	The name of the BRMS backup spooled file list.
LIST_SEQUENCE	LIST_SEQ	INTEGER	The sequence of the entry within the LIST_NAME. 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.
OUTPUT_QUEUE_LIBRARY	OUTQ_LIB	VARCHAR(10)	The output queue library.
OUTPUT_QUEUE	OUTQ	VARCHAR(10)	The output queue name.
SPOOLED_FILE	SPLF	VARCHAR(8)	The spooled file name.
JOB_NAME	JOB_NAME	VARCHAR(10)	The job name.
JOB_USER	JOB_USER	VARCHAR(10)	The job user.
USER_DATA	USER_DATA	VARCHAR(10)	The user data.
LIST_OMIT	LIST_OMIT	VARCHAR(7) Nullable	Indicates whether the list item from the spooled file list being used on the backup command is an include or omit. The possible values are: INCLUDE The object list item is an include. OMIT The object list item is an omit.

Example 1 - Display all backup spooled file list entries for output queues in library 'ACCTOUTQ':

SELECT LIST_NAME, LIST_SEQ, OUTPUT_QUEUE_LIBRARY, OUTPUT_QUEUE, SPOOLED_FILE, LIST_OMIT FROM QUSRBRM.BACKUP_SPLF_LIST WHERE OUTPUT_QUEUE_LIBRARY = ‘ACCTOUTQ’

Example output:

LIST_NAME	LIST_SEQUENCE	OUTPUT_QUEUE_LIBRARY	OUTPUT_QUEUE	SPOOLED_FILE	LIST_OMIT
ACCTING	10	ACCTOUTQ	FLOOR1	*ALL	INCLUDE
ACCTING	20	ACCTOUTQ	FLOOR2	*ALL	INCLUDE
ACCTING	30	ACCTOUTQ	PAYROLL	*ALL	INCLUDE