QUSRBRM.BACKUP_OBJECT_LIST View

The QUSRBRM.BACKUP_OBJECT_LIST view shows BRMS backup object 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 an *OBJ type list.

Authorization:

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

*OBJOPR and *READ authority to the QUSRBRM/BKU_OBJLST *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 object 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.
LIBRARY	LIBRARY	VARCHAR(10)	The object library. The possible values are: ALLUSR Saves all user libraries. ALL Specifies to exclude objects from all included libraries. Note: LIST_OMIT value must be OMIT *generic-library-name** The generic library backups that are indicated by an * following a partial character string. library-name The name of a library that you want to backup.
OBJECT_NAME	OBJ_NAME	VARCHAR(10)	The object name. The possible values are: ALL All objects in the library. generic-object-name Generic object name. object-name** The object name.
OBJECT_TYPE	OBJ_TYPE	VARCHAR(8)	The object type. The possible values are: ALL All object types are included for the chosen object. object-type* The name of any permitted system object type.
OBJECT_ATTRIBUTE	OBJ_ATTR	VARCHAR(10)	The object attribute value that is set for the control group backup item.
OBJECT_MEMBER	OBJ_MBR	VARCHAR(10)	The member name that is set for the control group backup item.
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 object list entries with object type = *OUTQ:

SELECT LIST_NAME, LIST_SEQ, LIBRARY, OBJECT_NAME, OBJECT_TYPE, LIST_OMIT FROM QUSRBRM.BACKUP_OBJECT_LIST WHERE OBJECT_TYPE = '*OUTQ'

Example output:

LIST_NAME	LIST_SEQUENCE	LIBRARY	OBJECT_NAME	OBJECT_TYPE	LIST_OMIT
QABCSPLF	10	A*	*ALL	*OUTQ	INCLUDE
QABCSPLF	20	B*	*ALL	*OUTQ	INCLUDE
QABCSPLF	30	C*	*ALL	*OUTQ	INCLUDE