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.