QUSRBRM.CONTROL_GROUP_SUBSYSTEM View

The QUSRBRM.CONTROL_GROUP_SUBSYSTEM view shows the subsystems to process during a BRMS control group backup.

The values returned for the columns in this view are similar to the values returned by the Work with Backup Control Groups (WRKCTLGBRM *BKU) command option 9 to display the subsystems to process.

Authorization:

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

*OBJOPR and *READ authority to the QUSRBRM/CG_SBS *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.
LIST_SEQUENCE	LIST_SEQ	INTEGER	The sequence of the entry within the CONTROL_GROUP. Sequence numbers range from 1 through 9999. The lowest number indicates the entry to be processed first and the highest number indicates the entry to be processed last.
SUBSYSTEM_LIBRARY	SBS_LIB	VARCHAR(10)	The library of the subsystems to be processed. The possible values are: LIBL Include the libraries in your library list. ALL All subsystems will be ended. No other value is allowed in the list if ALL is specified. library-name* The library for the subsystem that you want to process.
SUBSYSTEM_NAME	SBS_NAME	VARCHAR(10)	The name of the subsystem to be processed. The possible values are: ALL All subsystems will be ended. No other value is allowed in the list if ALL is specified. subsystem-name The name of the subsystem you want to process.
END_OPTION	END_OPTION	VARCHAR(10) Nullable	Indicates how the subsystem will be ended. The possible values are: CONTROLLED Jobs in the subsystem are ended in a controlled manner. IMMEDIATE Jobs in the subsystem are ended immediately. NONE The subsystem will not be ended when processing begins.
CONTROLLLED_END_WAIT_TIME	WAIT_TIME	VARCHAR(8) Nullable	Specifies the amount of time, in seconds, that the system allows a controlled end to be performed by the active subsystems. If the end of job routines are not finished in the specified wait time, any remaining jobs are ended immediately. The possible values are: NULL Subsystem is not ending controlled. 1-3600 The number of seconds that the system allows a controlled end of the subsystem to be performed. NO_LIMIT The processing does not continue until the last job for the subsystem has ended. Processing could be suspended indefinitely if jobs in the subsystem do not end.
RESTART_OPTION	RESTARTOPT	VARCHAR(3) Nullable	Indicates if the specified subsystem should be restarted at the end of control group processing. The possible values are: YES The specified subsystem will be restarted at the end of the control group. NO The specified subsystem will not be restarted at the end of the control group.

Example 1 - Display the subsystems to process for control group *SYSTEM:

SELECT LIST_SEQUENCE, SUBSYSTEM_NAME, SUBSYSTEM_LIBRARY, END_OPTION, CONTROLLLED_END_WAIT_TIME, RESTART_OPTION FROM QUSRBRM.CONTROL_GROUP_SUBSYSTEM WHERE CONTROL_GROUP = ‘*SYSTEM’

Example output:

LIST_SEQUENCE	SUBSYSTEM_NAME	SUBSYSTEM_LIBRARY	END_OPTION	CONTROLLLED_END_WAIT_TIME	RESTART_OPTION
10	*ALL	*ALL	CONTROLLED	1200	YES