QUSRBRM.CONTROL_GROUP View

The QUSRBRM.CONTROL_GROUP view shows BRMS control groups and their defined attributes for the system.

The values returned for the columns in this view are similar to the values returned by the Work with Backup Control Groups (WRKCTLGBRM) command option 8 showing the control group attributes.

Authorization:

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

*OBJOPR and *READ authority to the QUSRBRM/CG_VIEW *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
CONTROL_GROUP	CGNAME	VARCHAR(10)	The name of the BRMS control group.
FULL_MEDIA_POLICY	FULMEDPCY	VARCHAR(10)	The full media policy associated with this control group. The possible values are: BKUPCY Use the value from the backup policy. SYSPCY Use the value from the system policy. media-policy-name The media policy to use
FULL_MEDIA_POLICY_BACKUP_POLICY	FULMEDPCBP	VARCHAR(10) Nullable	The full media policy from the backup policy. Contains the null value to indicate that the backup policy value was not used.
FULL_MEDIA_POLICY_SYSTEM_POLICY	FULMEDPCSP	VARCHAR(10) Nullable	The full media policy from the system policy. Contains the null value to indicate that the system policy value was not used.
INCREMENTAL_MEDIA_POLICY	INCMEDPCY	VARCHAR(10)	The incremental media policy associated with this control group. The possible values are: BKUPCY Use the value from the backup policy. SYSPCY Use the value from the system policy. media-policy-name The media policy to use
INCREMENTAL_MEDIA_POLICY_BACKUP_POLICY	INCMEDPCBP	VARCHAR(10) Nullable	The incremental media policy from the backup policy. The possible values are: SYSPCY Use the value from the system policy. media-policy-name* The media policy to use Contains the null value to indicate that the backup policy value was not used.
INCREMENTAL_MEDIA_POLICY_SYSTEM_POLICY	INCMEDPCSP	VARCHAR(10) Nullable	The incremental media policy from the system policy. The possible values are: media-policy-name The media policy to use Contains the null value to indicate that the system policy value was not used.
SUNDAY_BACKUP	SUNDAY	VARCHAR(11)	The control group backup to run on Sunday. The possible values are: BKUPCY Use the value from the backup policy. FULL* Indicates a full backup activity. INCREMENTAL Indicates an incremental backup activity. NO Indicates no backup activity.
SUNDAY_BACKUP_BACKUP_POLICY	SUNDAYBP	VARCHAR(11) Nullable	The Sunday backup policy from the backup policy. The possible values are: FULL Indicates a full backup activity. INCREMENTAL Indicates an incremental backup activity. NO Indicates no backup activity. Contains the null value to indicate that the backup policy value was not used.
MONDAY_BACKUP	MONDAY	VARCHAR(11)	The control group backup to run on Monday. The possible values are: BKUPCY Use the value from the backup policy. FULL* Indicates a full backup activity. INCREMENTAL Indicates an incremental backup activity. NO Indicates no backup activity.
MONDAY_BACKUP_BACKUP_POLICY	MONDAYBP	VARCHAR(11) Nullable	The Sunday backup policy from the backup policy. The possible values are: FULL Indicates a full backup activity. INCREMENTAL Indicates an incremental backup activity. NO Indicates no backup activity. Contains the null value to indicate that the backup policy value was not used.
TUESDAY_BACKUP	TUESDAY	VARCHAR(11)	The control group backup to run on Tuesday. The possible values are: BKUPCY Use the value from the backup policy. FULL* Indicates a full backup activity. INCREMENTAL Indicates an incremental backup activity. NO Indicates no backup activity.
TUESDAY_BACKUP_BACKUP_POLICY	TUESDAYBP	VARCHAR(11) Nullable	The Tuesday backup policy from the backup policy. The possible values are: FULL Indicates a full backup activity. INCREMENTAL Indicates an incremental backup activity. NO Indicates no backup activity. Contains the null value to indicate that the backup policy value was not used.
WEDNESDAY_BACKUP	WEDNESDAY	VARCHAR(11)	The control group backup to run on Wednesday. The possible values are: BKUPCY Use the value from the backup policy. FULL* Indicates a full backup activity. INCREMENTAL Indicates an incremental backup activity. NO Indicates no backup activity.
WEDNESDAY_BACKUP_BACKUP_POLICY	WEDNESDABP	VARCHAR(11) Nullable	The Wednesday backup policy from the backup policy. The possible values are: FULL Indicates a full backup activity. INCREMENTAL Indicates an incremental backup activity. NO Indicates no backup activity. Contains the null value to indicate that the backup policy value was not used.
THURSDAY_BACKUP	THURSDAY	VARCHAR(11)	The control group backup to run on Thursday. The possible values are: BKUPCY Use the value from the backup policy. FULL* Indicates a full backup activity. INCREMENTAL Indicates an incremental backup activity. NO Indicates no backup activity.
THURSDAY_BACKUP_BACKUP_POLICY	THURSDAYBP	VARCHAR(11) Nullable	The Thursday backup policy from the backup policy. The possible values are: FULL Indicates a full backup activity. INCREMENTAL Indicates an incremental backup activity. NO Indicates no backup activity. Contains the null value to indicate that the backup policy value was not used.
FRIDAY_BACKUP	FRIDAY	VARCHAR(11)	The control group backup to run on Friday. The possible values are: BKUPCY Use the value from the backup policy. FULL* Indicates a full backup activity. INCREMENTAL Indicates an incremental backup activity. NO Indicates no backup activity.
FRIDAY_BACKUP_BACKUP_POLICY	FRIDAYBP	VARCHAR(11) Nullable	The Friday backup policy from the backup policy. The possible values are: FULL Indicates a full backup activity. INCREMENTAL Indicates an incremental backup activity. NO Indicates no backup activity. Contains the null value to indicate that the backup policy value was not used.
SATURDAY_BACKUP	SATURDAY	VARCHAR(11)	The control group backup to run on Saturday. The possible values are: BKUPCY Use the value from the backup policy. FULL* Indicates a full backup activity. INCREMENTAL Indicates an incremental backup activity. NO Indicates no backup activity.
SATURDAY_BACKUP_BACKUP_POLICY	SATURDAYBP	VARCHAR(11) Nullable	The Saturday backup policy from the backup policy. The possible values are: FULL Indicates a full backup activity. INCREMENTAL Indicates an incremental backup activity. NO Indicates no backup activity. Contains the null value to indicate that the backup policy value was not used.
SIGNOFF_INTERACTIVE_USERS	SGNOFFUSR	VARCHAR(7)	Whether BRMS should automatically notify active users that a backup is about to occur and then sign them off for this backup control group. This possible values are: BKUPCY Use the value from the backup policy. SYSPCY Use the value from the system policy. NO BRMS should not sign off interactive users. YES BRMS should sign off interactive users.
SIGNOFF_INTERACTIVE_USERS_BACKUP_POLICY	SGNOFFUSBP	VARCHAR(7) Nullable	The sign-off interactive users value from the backup policy. This possible values are: SYSPCY Use the value from the system policy. NO BRMS should not sign off interactive users. YES* BRMS should sign off interactive users. Contains the null value to indicate that the backup policy value was not used.
SIGNOFF_INTERACTIVE_USERS_SYSTEM_POLICY	SGNOFFUSSP	VARCHAR(7) Nullable	The sign-off interactive users value from the system policy. This possible values are: NO BRMS should not sign off interactive users. YES BRMS should sign off interactive users. Contains the null value to indicate that the system policy value was not used.
SIGNOFF_MESSAGE_INTERVAL	SGNOFFMSG	VARCHAR(7)	The maximum time limit in minutes that BRMS automatically notifies users prior to automatically signing off active users for this control group. The possible values are: BKUPCY Use the value from the backup policy. SYSPCY Use the value from the system policy. number-of-minutes Can range from 0 to 999.
SIGNOFF_MESSAGE_INTERVAL_BACKUP_POLICY	SGNOFFMSBP	VARCHAR(7) Nullable	The sign-off message interval value from the backup policy. This possible values are: SYSPCY Use the value from the system policy. number-of-minutes* Can range from 0 to 999. Contains the null value to indicate that the backup policy value was not used.
SIGNOFF_MESSAGE_INTERVAL_SYSTEM_POLICY	SGNOFFMSSP	VARCHAR(7) Nullable	The sign-off message interval value from the system policy. This possible values are: number-of-minutes Can range from 0 to 999. Contains the null value to indicate that the system policy value was not used.
DEVICE_NAMES	DEVICES	VARCHAR(43)	The device names used by the backup for this control group. The possible values are: BKUPCY Use the value from the backup policy. SYSPCY Use the value from the system policy. MEDCLS Devices are selected base on the device types that support the density for the media class specified in the media policy. SAVF Save files are being used. device-names The names of the devices. Note: The string contains 10 character blank separated device names, up to a maximum of 4.
DEVICE_NAMES_BACKUP_POLICY	DEVICESBP	VARCHAR(43) Nullable	The device names value from the backup policy. The possible values are: SYSPCY Use the value from the system policy. MEDCLS Devices are selected base on the device types that support the density for the media class specified in the media policy. SAVF Save files are being used. device-names* The names of the devices. Note: The string contains 10 character blank separated device names, up to a maximum of 4. Contains the null value to indicate that the backup policy value was not used.
DEVICE_NAMES_SYSTEM_POLICY	DEVICESSP	VARCHAR(43) Nullable	The device names value from the system policy. The possible values are: MEDCLS Devices are selected base on the device types that support the density for the media class specified in the media policy. SAVF Save files are being used. device-names The names of the devices. Note: The string contains 10 character blank separated device names, up to a maximum of 4. Contains the null value to indicate that the system policy value was not used.
MINIMUM_PARALLEL_RESOURCES	MINPRLRSC	VARCHAR(9)	The minimum number of device resources to be used for parallel save operations during backup control group processing. The possible values are: AVAILABLE Use any available devices up to the maximum number of device resources for the save. SERIAL The save will be performed as a serial save. number-resources The minimum number of resources to be used for the save. The number can range from 1-32.
MAXIMUM_PARALLEL_RESOURCES	MAXPRLRSC	VARCHAR(9)	The maximum number of device resources to be used for parallel save operations during backup control group processing. The possible values are: AVAILABLE Use any available devices up to the maximum number of device resources for the save. MINIMUM Uses the value specified for the minimum number of device resources. SERIAL The save will be performed as a serial save. number-resources The maximum number of resources to be used for the save. The number can range from 1-32.
INCREMENTAL_TYPE	INCRTYPE	VARCHAR(11)	Specifies the type of incremental (saved changed objects) backup to be used during backup control group processing. The possible values are: BKUPCY Use the value from the backup policy. CUMULATIVE* All changed objects since the last full backup are included in the saved objects. INCREMENTAL All changed objects since the last incremental backup are included in the saved objects.
INCREMENTAL_TYPE_BACKUP_POLICY	INCRTYPEBP	VARCHAR(11) Nullable	The incremental type value from the backup policy. The possible values are: CUMULATIVE All changed objects since the last full backup are included in the saved objects. INCREMENTAL All changed objects since the last incremental backup are included in the saved objects. Contains the null value to indicate that the backup policy value was not used.
FORCE_FULL_BACKUP_DAYS	FORCEFULL	VARCHAR(7)	The number of days prior to the current incremental backup which forces a full save of libraries rather than a save of changed objects for this control group. The possible values are: BKUPCY Use the value from the backup policy. NOMAX* No limit exists for the number of days. number-days The valid range for number of days is 0 to 365.
FORCE_FULL_BACKUP_DAYS_BACKUP_POLICY	FORCEFULBP	VARCHAR(5) Nullable	The force full backup days value from the backup policy. The possible values are: NOMAX No limit exists for the number of days. number-days The valid range for number of days is 0 to 365. Contains the null value to indicate that the backup policy value was not used.
BACKUP_MEDIA_INFORMATION	BKUMEDINF	VARCHAR(7)	Whether you want to automatically save the media information needed for recovery each time you process this backup control group. The possible values are: BKUPCY Use the value from the backup policy. LIBRARY* Save library level media information. OBJECT Save object level media information. NONE No media information is saved.
BACKUP_MEDIA_INFORMATION_BACKUP_POLICY	BKUMEDINBP	VARCHAR(7) Nullable	The backup media information value from the backup policy. The possible values are: LIBRARY Save library level media information. OBJECT Save object level media information. NONE No media information is saved. Contains the null value to indicate that the backup policy value was not used.
SAVE_ACCESS_PATHS	SAVACCPTH	VARCHAR(7)	Whether the logical file access paths that are dependent on the physical files being saved are also saved. The possible values are: BKUPCY Use the value from the backup policy. NO Only those objects specified on the command are saved. No logical file access paths are saved. YES* The selected physical files and all logical file access paths over them are saved.
SAVE_ACCESS_PATHS_BACKUP_POLICY	SAVACCPTBP	VARCHAR(3) Nullable	The save access paths value from the backup policy. The possible values are: NO Only those objects specified on the command are saved. No logical file access paths are saved. YES The selected physical files and all logical file access paths over them are saved. Contains the null value to indicate that the backup policy value was not used.
SAVE_SAVEFILE_CONTENTS	SAVSAVF	VARCHAR(7)	Whether the description of a save file, or both the description and the contents of a save file, are saved. The possible values are: BKUPCY Use the value from the backup policy. NO Only the description of a save file is saved. YES* The description and contents of a save file are saved.
SAVE_SAVEFILE_CONTENTS_BACKUP_POLICY	SAVSAVFBP	VARCHAR(3) Nullable	The save savefile contents value from the backup policy. The possible values are: NO Only the description of a save file is saved. YES The description and contents of a save file are saved. Contains the null value to indicate that the backup policy value was not used.
SAVE_SPOOLED_FILE_DATA	SAVSPLDTA	VARCHAR(7)	Whether to save the spooled file data and attributes for saved output queues. The possible values are: BKUPCY Use the value from the backup policy. NO No spooled file data or attributes are saved with saved output queues. YES* All available spooled file data and attributes are saved with saved output queues.
SAVE_SPOOLED_FILE_DATA_BACKUP_POLICY	SAVSPLDTBP	VARCHAR(3) Nullable	The save spooled file data value from the backup policy. The possible values are: NO No spooled file data or attributes are saved with saved output queues. YES All available spooled file data and attributes are saved with saved output queues. Contains the null value to indicate that the backup policy value was not used.
SAVE_DATA_QUEUE_DATA	SAVDQDTA	VARCHAR(7)	Whether the description of a data queue, or both the description and the contents of a data queue are saved. The possible values are: BKUPCY Use the value from the backup policy. NO Only the description of a data queue is saved. YES* The description and contents of a standard data queue are saved. Only the description of a Distributed Data Management (DDM) data queue is saved.
SAVE_DATA_QUEUE_DATA_BACKUP_POLICY	SAVDQDTABP	VARCHAR(3) Nullable	The save data queue data value from the backup policy. The possible values are: NO Only the description of a data queue is saved. YES The description and contents of a standard data queue are saved. Only the description of a Distributed Data Management (DDM) data queue is saved. Contains the null value to indicate that the backup policy value was not used.
DATA_COMPRESSION	DTACOMPRS	VARCHAR(7)	Whether data compression is used. The possible values are: BKUPCY Use the value from the backup policy. DEVICE* If the save is to tape and the target device supports compression, hardware compression is performed. HIGH Software data compression is performed with the LZ1 algorithm. LOW Software data compression is performed with the SNA algorithm. MEDIUM Software data compression is performed with the TERSE algorithm. NO No data compression is performed. YES If the target device supports compression, hardware compression is performed. If compression is not supported, software compression is performed. ZLIB Software data compression is performed with the ZLIB deflate algorithm.
DATA_COMPRESSION_BACKUP_POLICY	DTACOMPRBP	VARCHAR(7) Nullable	The data compression value from the backup policy. The possible values are: DEVICE If the save is to tape and the target device supports compression, hardware compression is performed. HIGH Software data compression is performed with the LZ1 algorithm. LOW Software data compression is performed with the SNA algorithm. MEDIUM Software data compression is performed with the TERSE algorithm. NO No data compression is performed. YES If the target device supports compression, hardware compression is performed. If compression is not supported, software compression is performed. ZLIB Software data compression is performed with the ZLIB deflate algorithm. Contains the null value to indicate that the backup policy value was not used.
DATA_COMPACTION	DTACOMPCT	VARCHAR(7)	Whether data compaction is used. The possible values are: BKUPCY Use the value from the backup policy. NO No data compaction is performed. YES* Data compaction is performed if the data is saved to tape and all devices used for the backup support the compaction feature.
DATA_COMPACTION_BACKUP_POLICY	DTACOMPCBP	VARCHAR(3) Nullable	The data compaction value from the backup policy. The possible values are: NO No data compaction is performed. YES Data compaction is performed if the data is saved to tape and all devices used for the backup support the compaction feature. Contains the null value to indicate that the backup policy value was not used.
TARGET_RELEASE	TGTREL	VARCHAR(8)	The release of the operating system on which you intend to restore the objects being saved. The possible values are: BKUPCY Use the value from the backup policy. CURRENT* The objects are to be restored on a system that is running the same release of the operating system currently running on your system. PREVIOUS The objects are to be restored on a system that is running on the previous release of the operating system. target-release The release in the format VxRxMx, where Vx is the version, Rx is the release, and Mx is the modification level.
TARGET_RELEASE_BACKUP_POLICY	TGTRELBP	VARCHAR(8) Nullable	The target release value from the backup policy. The possible values are: CURRENT The objects are to be restored on a system that is running the same release of the operating system currently running on your system. PREVIOUS The objects are to be restored on a system that is running on the previous release of the operating system. target-release The release in the format VxRxMx, where Vx is the version, Rx is the release, and Mx is the modification level. Contains the null value to indicate that the backup policy value was not used.
UPDATE_HISTORY_OBJECTS	UPDHSTOBJ	VARCHAR(7)	Whether the save history information of each saved object is changed with the date, time, and location of this save operation. The possible values are: BKUPCY Use the value from the backup policy. NO The save history information contained in the description of each object saved is not updated. YES* The last save date, time, and location is updated in each object saved.
UPDATE_HISTORY_OBJECTS_BACKUP_POLICY	UPDHSTOBBP