QUSRBRM.BRMS_CONTROL_GROUP_OMITS View

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

Copyright © Fortra, LLC and its group of companies. All trademarks and registered trademarks are the property of their respective owners.