QUSRBRM.BACKUP_IFS_LIST View

The QUSRBRM.BACKUP_IFS_LIST view shows BRMS backup IFS 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 *LNK type list.

Authorization:

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

*OBJOPR and *READ authority to the QUSRBRM/BKU_IFSLST *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 IFS 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.
PATH_NAME	PATH_NAME	VARGRAPHIC(16000) CCSID(1200)	The IFS path 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 IFS list entries that include the folder ‘ProdData’:

SELECT LIST_NAME, LIST_SEQ, PATH_NAME, LIST_OMIT FROM QUSRBRM.BACKUP_IFS_LIST WHERE PATH_NAME like '%ProdData%'

Example output:

LIST_NAME	LIST_SEQUENCE	PATH_NAME	LIST_OMIT
QIBMLINK	10	'/QIBM/ProdData'	INCLUDE
QIBMLINK	20	'/QOpenSys/QIBM/ProdData'	INCLUDE
QALLUSRLNK	50	'/QIBM/ProdData'	OMIT
QALLUSRLNK	60	'/QOpenSys/QIBM/ProdData'	OMIT