QUSRBRM.BACKUP_FOLDER_LIST View

The QUSRBRM.BACKUP_FOLDER_LIST view shows BRMS backup folder 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 *FLR type list.

Authorization:

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

*OBJOPR and *READ authority to the QUSRBRM/BKU_FLRLST *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 folder 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.
FOLDER	FOLDER	VARCHAR(63)	The folder name.
LIST_OMIT	LIST_OMIT	VARCHAR(7) Nullable	Indicates whether the list item from the object 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 folder list entries that are excluded:

SELECT LIST_NAME, LIST_SEQ, FOLDER, LIST_OMIT FROM QUSRBRM.BACKUP_FOLDER_LIST WHERE LIST_OMIT = ‘OMIT’

Example output:

LIST_NAME	LIST_SEQUENCE	FOLDER	LIST_OMIT
PFRDATA	10	QPFRDATA	OMIT
TEMP	10	TEMP	OMIT