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	VARCHAR(3) Nullable	The update history objects value from the backup policy. The possible values are: 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. Contains the null value to indicate that the backup policy value was not used.
UPDATE_HISTORY_DIRECTORIES	UPDHSTDIR	VARCHAR(9)	Specifies whether to update the file system save history on the objects saved with this save operation. The possible value are: BKUPCY Use the value from the backup policy. NO The save operation will not be updated in the save history of the selected file system objects. YES* The save history is updated. For local file systems, the system save history is updated. For remote file systems, the PC save history is updated. SYSTEM The local file system save history is updated. PC The PC file system save history is updated. SYSTEM PC The local file system save history and PC file system save history are updated.
UPDATE_HISTORY_DIRECTORIES_BACKUP_POLICY	UPDHSTDIBP	VARCHAR(9) Nullable	The update history directories value from the backup policy. The possible value are: NO The save operation will not be updated in the save history of the selected file system objects. YES The save history is updated. For local file systems, the system save history is updated. For remote file systems, the PC save history is updated. SYSTEM The local file system save history is updated. PC The PC file system save history is updated. SYSTEM PC The local file system save history and PC file system save history are updated. Contains the null value to indicate that the backup policy value was not used.
CLEAR	CLEAR	VARCHAR(7)	Whether uncleared volumes or save files encountered during the save operation are automatically cleared. The possible values are: BKUPCY Use the value from the backup policy. AFTER* All the uncleared volumes after the initial volume are automatically cleared. ALL All the uncleared volumes or save files encountered during the save operation are automatically cleared. NONE None of the uncleared volumes or save files encountered during the save operation are automatically cleared.
CLEAR_BACKUP_POLICY	CLEARBP	VARCHAR(5) Nullable	The clear value from the backup policy. The possible values are: AFTER All the uncleared volumes after the initial volume are automatically cleared. ALL All the uncleared volumes or save files encountered during the save operation are automatically cleared. NONE None of the uncleared volumes or save files encountered during the save operation are automatically cleared. Contains the null value to indicate that the backup policy value was not used.
OBJECT_PRECHECK	OBJPRECHK	VARCHAR(7)	Whether the save operation ends if any of the selected objects cannot be saved. The possible values are: BKUPCY Use the value from the backup policy. NO The save operation for a library continues, saving only those objects that can be saved. YES* If after all specified objects are checked, one or more objects cannot be saved, the save operation for a library ends before any data is written. If multiple libraries are specified, the save operation continues with the next library.
OBJECT_PRECHECK_BACKUP_POLICY	OBJPRECHBP	VARCHAR(3) Nullable	The object precheck value from the backup policy. The possible values are: NO The save operation for a library continues, saving only those objects that can be saved. YES If after all specified objects are checked, one or more objects cannot be saved, the save operation for a library ends before any data is written. If multiple libraries are specified, the save operation continues with the next library. Contains the null value to indicate that the backup policy value was not used.
APPEND_TO_MEDIA	APPENDMED	VARCHAR(7)	Whether to add data files on existing media with active files or to begin a new volume. The possible values are: BKUPCY Use the value from the backup policy. NO The saved data files are started on a new volume. YES* The saved data files can be added to media already containing active data files. Files are written to the volume immediately following the last active file.
APPEND_TO_MEDIA_BACKUP_POLICY	APPENDMEBP	VARCHAR(3) Nullable	The append to media value from the backup policy. The possible values are: NO The saved data files are started on a new volume. YES The saved data files can be added to media already containing active data files. Files are written to the volume immediately following the last active file. Contains the null value to indicate that the backup policy value was not used.
END_OF_MEDIA_OPTION	ENDMEDOPT	VARCHAR(7)	The operation that is automatically done on the tape or optical volume after the save operation ends. The possible values are: BKUPCY Use the value from the backup policy. LEAVE* The volume does not rewind or unload after the operation ends. It remains at the current position on the device. REWIND The volume is rewound, but not unloaded. UNLOAD The volume is automatically rewound and unloaded after the save operation ends.
END_OF_MEDIA_OPTION_BACKUP_POLICY	ENDMEDOPBP	VARCHAR(6) Nullable	The end of media option value from the backup policy. The possible values are: BKUPCY Use the value from the backup policy. LEAVE* The volume does not rewind or unload after the operation ends. It remains at the current position on the device. REWIND The volume is rewound, but not unloaded. UNLOAD The volume is automatically rewound and unloaded after the save operation ends. Contains the null value to indicate that the backup policy value was not used.
JOURNALED_OBJECTS	JRNOBJS	VARCHAR(7)	Whether to save changed objects that are currently being journaled and that have been journaled since the date and time specified on the REFDATE and REFTIME parameters. The possible values are: BKUPCY Use the value from the backup policy. NO Objects being journaled are not saved. YES* Objects whose changes are entered in a journal are saved.
JOURNALED_OBJECTS_BACKUP_POLICY	JRNOBJSBP	VARCHAR(3) Nullable	The journaled objects value from the backup policy. The possible values are: NO Objects being journaled are not saved. YES Objects whose changes are entered in a journal are saved. Contains the null value to indicate that the backup policy value was not used.
USE_OPTIMUM_BLOCK	USEOPTBLK	VARCHAR(7)	Specifies whether or not the optimum block size is use for the save operation. The possible values are: BKUPCY Use the value from the backup policy. DEVICE* Use the value specified on the WRKDEVBRM display for the Use optimum block size value. NO The optimum block size supported by the device is not used. Save commands use the default block size supported by all device types. YES The optimum block size supported by the device is used for Save commands.
USE_OPTIMUM_BLOCK_BACKUP_POLICY	USEOPTBLBP	VARCHAR(6) Nullable	The use optimum block value from the backup policy. The possible values are: DEVICE Use the value specified on the WRKDEVBRM display for the Use optimum block size value. NO The optimum block size supported by the device is not used. Save commands use the default block size supported by all device types. YES The optimum block size supported by the device is used for Save commands. Contains the null value to indicate that the backup policy value was not used.
IPL_AFTER_BACKUP	IPLAFTER	VARCHAR(7)	Whether you want to start the system after a backup control group completes its processing. The possible values are: BKUPCY Use the value from the backup policy. SYSPCY Use the value from the system policy. NO Do not start the system after the backup control group completes processing. YES Start the system after the backup control group completes processing.
IPL_AFTER_BACKUP_BACKUP_POLICY	IPLAFTERBP	VARCHAR(7) Nullable	The IPL after backup value from the backup policy. The possible values are: SYSPCY Use the value from the system policy. NO Do not start the system after the backup control group completes processing. YES* Start the system after the backup control group completes processing. Contains the null value to indicate that the backup policy value was not used.
IPL_AFTER_BACKUP_SYSTEM_POLICY	IPLAFTERSP	VARCHAR(3) Nullable	The IPL after backup value from the system policy. The possible values are: NO Do not start the system after the backup control group completes processing. YES Start the system after the backup control group completes processing. Contains the null value to indicate that the backup policy value was not used.
IPL_END_JOBS	IPLENDJOB	VARCHAR(10)	Whether the system allows the IPL to end processing of active jobs in a controlled manner or whether the system ends the jobs immediately. The possible values are: BKUPCY Use the value from the backup policy. SYSPCY Use the value from the system policy. CONTROLLED The subsystems active jobs are ended in a controlled manner. IMMEDIATE The subsystems ends all active jobs immediately.
IPL_END_JOBS_BACKUP_POLICY	IPLENDJOBP	VARCHAR(10) Nullable	The IPL end jobs value from the backup policy. The possible values are: SYSPCY Use the value from the system policy. CONTROLLED* The subsystems active jobs are ended in a controlled manner. IMMEDIATE The subsystems ends all active jobs immediately. Contains the null value to indicate that the backup policy value was not used.
IPL_END_JOBS_SYSTEM_POLICY	IPLENDJOSP	VARCHAR(10) Nullable	The IPL end jobs value from the system policy. The possible values are: CONTROLLED The subsystems active jobs are ended in a controlled manner. IMMEDIATE The subsystems ends all active jobs immediately. Contains the null value to indicate that the system policy value was not used.
DELAY_TIME	DELAYTIME	VARCHAR(7)	The amount of time, in seconds, that the system allows a controlled end to be performed by the active subsystems. The possible values are: BKUPCY Use the value from the backup policy. SYSPCY Use the value from the system policy. NOLIMIT The system does not power-down until the last job is complete. delay-time The maximum amount of delay time, in seconds, in which a controlled end can be performed. The valid range is 1 to 99999.
DELAY_TIME_BACKUP_POLICY	DELAYTIMBP	VARCHAR(7) Nullable	The delay time value from the backup policy. The possible values are: SYSPCY Use the value from the system policy. NOLIMIT* The system does not power-down until the last job is complete. delay-time The maximum amount of delay time, in seconds, in which a controlled end can be performed. The valid range is 1 to 99999. Contains the null value to indicate that the backup policy value was not used.
DELAY_TIME_SYSTEM_POLICY	DELAYTIMSP	VARCHAR(7) Nullable	The delay time value from the system policy. The possible values are: NOLIMIT The system does not power-down until the last job is complete. delay-time The maximum amount of delay time, in seconds, in which a controlled end can be performed. The valid range is 1 to 99999. Contains the null value to indicate that the system policy value was not used.
RESTART_AFTER_POWER_DOWN	RESTART	VARCHAR(7)	Whether the system ends and powers down, or whether the system ends and then starts again in unattended mode of operation. The possible values are: BKUPCY Use the value from the backup policy. SYSPCY Use the value from the system policy. NO The system ends and powers down. YES The system ends and then starts again in unattended mode of operation.
RESTART_AFTER_POWER_DOWN_BACKUP_POLICY	RESTARTBP	VARCHAR(7) Nullable	The restart after power down value from the backup policy. The possible values are: SYSPCY Use the value from the system policy. NO The system ends and powers down. YES* The system ends and then starts again in unattended mode of operation. Contains the null value to indicate that the backup policy value was not used.
RESTART_AFTER_POWER_DOWN_SYSTEM_POLICY	RESTARTSP	VARCHAR(3) Nullable	The restart after power down value from the system policy. The possible values are: NO The system ends and powers down. YES The system ends and then starts again in unattended mode of operation. Contains the null value to indicate that the system policy value was not used.
IPL_SOURCE	IPLSOURCE	VARCHAR(7)	Whether an initial program load (IPL) is started from the A-source or B-source of the system. The possible values are: BKUPCY Use the value from the backup policy. SYSPCY Use the value from the system policy. A The system is started from the A-source. B The system is started from the B-source. PANEL The system is started from the source that is currently shown on the operator's display, either the A-source or the B-source.
IPL_SOURCE_BACKUP_POLICY	IPLSOURCBP	VARCHAR(7) Nullable	The IPL source value from the backup policy. The possible values are: SYSPCY Use the value from the system policy. A The system is started from the A-source. B The system is started from the B-source. PANEL* The system is started from the source that is currently shown on the operator's display, either the A-source or the B-source. Contains the null value to indicate that the backup policy value was not used.
IPL_SOURCE_SYSTEM_POLICY	IPLSOURCSP	VARCHAR(5) Nullable	The IPL source value from the system policy. The possible values are: A The system is started from the A-source. B The system is started from the B-source. PANEL The system is started from the source that is currently shown on the operator's display, either the A-source or the B-source. Contains the null value to indicate that the system policy value was not used.
IPL_RESTART_TYPE	IPLRSTTYP	VARCHAR(7)	The point from which the initial program load (IPL) restarts. The possible values are: BKUPCY Use the value from the backup policy. SYSPCY Use the value from the system policy. FULL All portions of the system, including the hardware, are restarted. IPLA The value specified on the Change IPL Attributes (CHGIPLA) command is used. SYSTEM The operating system is restarted. The hardware will only be restarted when required by the system.
IPL_RESTART_TYPE_BACKUP_POLICY	IPLRSTTYBP	VARCHAR(7) Nullable	The IPL restart type value from the backup policy. The possible values are: SYSPCY Use the value from the system policy. FULL* All portions of the system, including the hardware, are restarted. IPLA The value specified on the Change IPL Attributes (CHGIPLA) command is used. SYSTEM The operating system is restarted. The hardware will only be restarted when required by the system. Contains the null value to indicate that the backup policy value was not used.
IPL_RESTART_TYPE_SYSTEM_POLICY	IPLRSTTYSP	VARCHAR(6) Nullable	The IPL restart type value from the system policy. The possible values are: FULL All portions of the system, including the hardware, are restarted. IPLA The value specified on the Change IPL Attributes (CHGIPLA) command is used. SYSTEM The operating system is restarted. The hardware will only be restarted when required by the system. Contains the null value to indicate that the system policy value was not used.
SAVE_ACTIVE_WAIT_OBJECT_LOCKS	SWAOBJLCK	VARCHAR(5)	The amount of time to wait for the object to become available for each object that is in use. The possible values are: NOMAX No maximum wait time exists. wait-time Specifies the time (in seconds) to wait for each individual object lock before continuing the save operation. Valid values range from 0 to 99,999.
SAVE_ACTIVE_WAIT_PENDING_RECORDS	SWAPNDREC	VARCHAR(8)	For each group of objects that are checkpointed together, specifies the amount of time to wait for transactions with pending record changes to reach a commit boundary. The possible values are: NOCOMMIT The system will save objects without requiring transactions with pending record changes to reach a commit boundary. NOMAX No maximum wait time exists. wait-time Specifies the time (in seconds) to wait for transactions with pending record changes to reach a commit boundary. Valid values range from 0 to 99,999
SAVE_ACTIVE_WAIT_OTHER_PENDING_RECORDS	SWAOTRREC	VARCHAR(5)	For each library, specifies the amount of time to wait for transactions with other pending changes to reach a commit boundary. The possible values are: NOMAX No maximum wait time exists. wait-time Specifies the time (in seconds) to wait for transactions with pending record changes to reach a commit boundary. Valid values range from 0 to 99,999
EXIT_PROGRAM	EXITPGM	VARCHAR(10)	The name of the exit program called following processing of one or more backup items in backup control groups. The possible values are: BKUPCY Use the value from the backup policy. NONE No exit program is used. program-name The exit program name.
EXIT_PROGRAM_BACKUP_POLICY	EXITPGMBP	VARCHAR(10) Nullable	The exit program value from the backup policy. The possible values are: NONE No exit program is used. program-name* The exit program name Contains the null value to indicate that the backup policy value was not used.
EXIT_PROGRAM_LIBRARY	EXITLIB	VARCHAR(10)	The name of the library containing the exit program. The possible values are: BKUPCY Use the value from the backup policy. NONE No exit program is being used. library-name The name of the library containing the exit program
EXIT_PROGRAM_LIBRARY_BACKUP_POLICY	EXITLIBBP	VARCHAR(10) Nullable	The exit program library value from the backup policy. The possible values are: BKUPCY Use the value from the backup policy. NONE No exit program is being used. library-name The name of the library containing the exit program Contains the null value to indicate that the backup policy value was not used.
EXIT_PROGRAM_FORMAT	EXITFMT	VARCHAR(8)	The name of the format defining the information passed to the exit program about processed backup items. The possible values are: BKUPCY Use the value from the backup policy. NONE No exit program is being used. BKUI0100 The exit program will run after each backup item in the control group. BKUI0200 The exit program will only run at the end of the control group. BOTH Formats BKUI0100 and BKUI0200 are to be used when passing backup item information to the exit program. The exit program will run after each backup item and again at the end of the control group. Contains the null value if no exit program is set.
EXIT_PROGRAM_FORMAT_BACKUP_POLICY	EXITFMTBP	VARCHAR(8) Nullable	The exit program format value from the backup policy. The possible values are: NONE No exit program is being used. BKUI0100* The exit program will run after each backup item in the control group. BKUI0200 The exit program will only run at the end of the control group. BOTH Formats BKUI0100 and BKUI0200 are to be used when passing backup item information to the exit program. The exit program will run after each backup item and again at the end of the control group. Contains the null value to indicate that the backup policy value was not used.
MISSED_OBJECT_POLICY	MISOBJPCY	VARCHAR(10)	Specifies the name of backup control group used to track missed objects during backup control group processing. The possible values are: BKUPCY Use the value from the backup policy. NONE No tracking of missed objects occurs during the backup control group processing. policy-name The name of backup control group used to track missed objects during backup control group processing.
MISSED_OBJECT_POLICY_BACKUP_POLICY	MISOBJPCBP	VARCHAR(10) Nullable	The missed objects policy value from the backup policy. The possible values are: NONE No tracking of missed objects occurs during the backup control group processing. policy-name* The name of backup control group used to track missed objects during backup control group processing. Contains the null value to indicate that the backup policy value was not used.
CLEAR_MISSED_OBJECTS	CLRMISOBJ	VARCHAR(7)	Whether the missed object policy is cleared of previous missed objects when backup control group processing begins. The possible values are: BKUPCY Use the value from the backup policy. NO The missed object policy is not cleared of previous missed objects before backup control group processing begins. YES* The missed object policy is cleared of previous missed objects before backup control group processing begins.
CLEAR_MISSED_OBJECTS_BACKUP_POLICY	CLRMISOBBP	VARCHAR(3) Nullable	The clear missed objects value from the backup policy. The possible values are: NO The missed object policy is not cleared of previous missed objects before backup control group processing begins. YES The missed object policy is cleared of previous missed objects before backup control group processing begins. Contains the null value to indicate that the backup policy value was not used.
JOURNALING_REPORT	JRNREPORT	VARCHAR(10) Nullable	The name of the object list for which you want to check journaling status. Contains the null value if the journaling status check will not be performed.
ASYNCHRONOUS_BRING	ASYNCBRNG	VARCHAR(7)	Whether objects should be asynchronously brought into memory during the save processing. The possible values are: BKUPCY Use the value from the backup policy. NO Objects are not asynchronously brought into memory. YES* Objects are asynchronously brought into memory.
ASYNCHRONOUS_BRING_BACKUP_POLICY	ASYNCBRNBP	VARCHAR(3) Nullable	The asynchronous bring value from the backup policy. The possible values are: NO Objects are not asynchronously brought into memory. YES Objects are asynchronously brought into memory. Contains the null value to indicate that the backup policy value was not used.
LIBRARY_ORDER	LIBORDER	VARCHAR(7)	The order libraries will be written to media when more than one library is included in a save operation. The possible values are: BKUPCY Use the value from the backup policy. NAME* Libraries are saved in the order the names are specified. SIZE Libraries are saved in the order of the total library size, from largest to smallest.
LIBRARY_ORDER_BACKUP_POLICY	LIBORDERBP	VARCHAR(4) Nullable	The library order value from the backup policy. The possible values are: NAME Libraries are saved in the order the names are specified. SIZE Libraries are saved in the order of the total library size, from largest to smallest. Contains the null value to indicate that the backup policy value was not used.
ALLOW_ACTIVITY_OVERRIDE	ALWACTOVR	VARCHAR(3)	Whether activity overrides are allowed when running the Start Backup using BRM (STRBKUBRM) command. The possible values are: NO No activity overrides are allowed. YES Activity overrides are allowed.
ALLOW_RETENTION_OVERRIDE	ALWRETOVR	VARCHAR(3)	Whether retention overrides are allowed when running the Start Backup using BRM (STRBKUBRM) command. The possible values are: NO No retention overrides are allowed. YES Retention overrides are allowed.
TCPIP_SERVERS_ACTION	TCPIPSRV	VARCHAR(7)	Whether the TCP/IP servers are ended or restarted. The possible values are: BOTH The TCP/IP servers are to be ended before the backup and restarted after the backup. END The TCP/IP servers are to be ended before the backup. NO No action is performed on the TCP/IP servers. RESTART The TCP/IP servers are to be restarted after the backup.
LOTUS_SERVERS_ACTION	LOTUSSRV	VARCHAR(7)	Whether the Lotus servers are ended or restarted. The possible values are: BOTH The Lotus servers are to be ended before the backup and restarted after the backup. END The Lotus servers are to be ended before the backup. NO No action is performed on the Lotus servers. RESTART The Lotus servers are to be restarted after the backup.
INTEGRATED_WINDOWS_SERVERS_ACTION	INTWINSRV	VARCHAR(7)	Whether the Integrated Windows servers are varied off or varied on. The possible values are: BOTH The Integrated Windows servers are to be varied off before the backup and varied on after the backup. NO No action is performed on the Integrated Windows servers. VARYOFF The Integrated Windows servers are to be varied off before the backup. VARYON The Integrated Windows servers are to be varied on after the backup.
GUEST_PARTITIONS_ACTION	GUESTPART	VARCHAR(7)	Whether guest partitions are varied off or varied on. The possible values are: BOTH The guest partitions servers are to be varied off before the backup and varied on after the backup. NO No action is performed on the guest partitions. VARYOFF The guest partitions are to be varied off before the backup. VARYON The guest partitions are to be varied on after the backup.
UNMOUNT_UDFS	UNMTUDFS	VARCHAR(3)	Whether user-defined file systems are unmounted prior to performing saves of the Integrate File System (IFS). The possible values are: NO No action is performed on user-defined file systems. YES User-defined file systems are unmounted before the backup.
RUN_MAINTENANCE	RUNMAINT	VARCHAR(3)	Whether maintenance is run after the backup is complete. The possible values are: NO No maintenance is run after the backup. YES Maintenance is run after the backup.
LAST_CHANGE_TIMESTAMP	CHANGETIME	TIMESTAMP	The timestamp for when the control group was last changed.
LAST_CHANGE_USER	CHANGEUSER	VARCHAR(10)	The user profile that last changed the control group.
TEXT	TEXT	VARCHAR(50) Nullable	The text that describes the control group that you are viewing is displayed. Contains the null value when no text describing the control group is defined.

Note:
To get the resolved value for parameters that allow BKUPCY and SYSPCY, use the COALESCE function with the system policy column, backup policy column, and the control group column.

Example: To retrieve the Full media policy, use: COALESCE(FULMEDPCSP, FULMEDPCBP, FULMEDPCY) as FULL_MEDIA_POLICY

QUSRBRM.CONTROL_GROUP View

Note:To get the resolved value for parameters that allow *BKUPCY and *SYSPCY, use the COALESCE function with the system policy column, backup policy column, and the control group column.

Note:
To get the resolved value for parameters that allow BKUPCY and SYSPCY, use the COALESCE function with the system policy column, backup policy column, and the control group column.