The QUSRBRM.BRMS_CONTROL_GROUP_OMITS view shows global library omits, object omits, or object list omits that have been set up for items in a control group.

Authorization:

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

*OBJOPR and *READ authority to the QUSRBRM/CG_OMITS object.

Result Table

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

Column Name	System Column Name	Data Type	Description
CONTROL_GROUP	CGNAME	VARCHAR(10)	The name of the BRMS control group.
SEQUENCE_NUMBER	SEQUENCE	SMALLINT	The sequence number of the control group entry.
BACKUP_ITEM	BACKUPITEM	VARCHAR(10)	The name of the backup item in the control group.
GLOBAL_OMIT_LIBRARY	GLOBALOMIT	VARCHAR(10) Nullable	The library name of the global library omit that was set for the control group backup item. Contains the null value if no global library omit has been set.
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. Contains the null value if no object list is being used. Note: When the LIST_OMIT is null and the global omit library or other library/object/type items are not null, they represent omits on the backup command.
LIBRARY	LIBRARY	VARCHAR(10) Nullable	The library name that is set for the control group backup item. Contains the null value if no value has been set.
OBJECT	OBJECT	VARCHAR(10) Nullable	The object name that is set for the control group backup item. Contains the null value if no value has been set.
OBJECT_TYPE	OBJTYPE	VARCHAR(10) Nullable	The object type that is set for the control group backup item. Contains the null value if no value has been set.
OBJECT_ATTRIBUTE	OBJATTR	VARCHAR(10) Nullable	The object attribute value that is set for the control group backup item. Contains the null value if no value has been set.
OBJECT_MEMBER	OBJMBR	VARCHAR(10) Nullable	The member name that is set for the control group backup item. Contains the null value if no value has been set.

Examples

Example 1- Report global library omits that are set for control group name WEEKLY:

SELECT CGNAME, SEQUENCE, BACKUPITEM, GLOBALOMIT FROM QUSRBRM.BRMS_CONTROL_GROUP_OMITS WHERE CGNAME = 'WEEKLY' AND GLOBALOMIT IS NOT NULL AND LIST_OMIT IS NULL

Example output:

CONTROL_GROUP	SEQUENCE_NUMBER	BACKUP_ITEM	GLOBAL_OMIT_LIBRARY
WEEKLY	40	*ALLUSR	A*
WEEKLY	40	*ALLUSR	B*
WEEKLY	40	*ALLUSR	C*

Example 2 - Report object omits that are set for control group name TEST1:

SELECT CGNAME, SEQUENCE, BACKUPITEM, LIBRARY, OBJECT, OBJTYPE, OBJATTR, OBJMBR FROM QUSRBRM.BRMS_CONTROL_GROUP_OMITS WHERE CGNAME = 'TEST1' AND LIST_OMIT IS NULL AND LIBRARY IS NOT NULL

Example output:

CONTROL_GROUP	SEQUENCE_NUMBER	BACKUP_ITEM	LIBRARY	OBJECT	OBJECT_TYPE	OBJECT_ATTRIBUTE	OBJECT_MEMBER
TEST1	20	*SAVSYS	*SAVCFG	*ALL	*ALL	*ALL	*ALL
TEST1	20	*SAVSYS	*SAVSECDTA	*ALL	*ALL	*ALL	*ALL
TEST1	30	*IBM	*ALL	*ALL	*FILE	SAVF	*ALL
TEST1	60	F*	FRED	Q*	*ALL	*ALL	*ALL

Example 3 - Report object lists that are set for control group name TEST2:

SELECT CGNAME, SEQUENCE, BACKUPITEM, LIST_OMIT, LIBRARY, OBJECT, OBJTYPE, OBJATTR, OBJMBR FROM QUSRBRM.BRMS_CONTROL_GROUP_OMITS WHERE CGNAME = 'TEST2' AND LIST_OMIT IS NOT NULL AND LIBRARY IS NOT NULL

Example output:

CONTROL_GROUP	SEQUENCE_NUMBER	BACKUP_ITEM	LIST_OMIT	LIBRARY	OBJECT	OBJECT_TYPE	OBJECT_ATTRIBUTE	OBJECT_MEMBER
TEST2	40	LIST1	INCLUDE	F*	*ALL	*ALL	*ALL	*ALL
TEST2	40	LIST1	OMIT	*ALL	*ALL	*FILE	SAVF	*ALL
TEST2	40	LIST1	OMIT	*ALL	Q*	*FILE	*ALL	*ALL

IBM Partnership

QUSRBRM.BRMS_CONTROL_GROUP_OMITS View

Examples

Example 1- Report global library omits that are set for control group name WEEKLY:

Example 2 - Report object omits that are set for control group name TEST1:

Example 3 - Report object lists that are set for control group name TEST2: