SUBSYSTEM_INFO view

The SUBSYSTEM_INFO view returns information about all subsystems.

The values returned for the columns in the view are closely related to the values returned by the WRKSBS (Work with Subsystems) CL command and by the Retrieve Subsystem Information (QWDRSBSD) API.

Authorization: The caller must have:

*EXECUTE authority to the library containing the subsystem description, and
*USE authority to the subsystem description.

The following table describes the columns in the view. The system name is SBS_INFO. The schema is QSYS2.

Table 1. SUBSYSTEM_INFO view
Column Name	System Column Name	Data Type	Description
SUBSYSTEM_DESCRIPTION_LIBRARY	SBSD_LIB	VARCHAR(10)	The name of the library in which the subsystem description resides.
SUBSYSTEM_DESCRIPTION	SBSD	VARCHAR(10)	The name of the subsystem about which information is being returned.
STATUS	STATUS	VARCHAR(10)	The status of the subsystem. ACTIVE The subsystem is running. ENDING An ENDSBS command has been issued for the subsystem or an ENDSYS command has been issued, but the subsystem is still running. INACTIVE The subsystem is not running. RESTRICTED An ENDSBS command for the controlling subsystem, an ENDSYS *ALL command, or an ENDSYS command has placed the controlling subsystem in a restricted condition. STARTING A STRSBS command has been issued for the subsystem, but it is still in the process of being started.
MAXIMUM_ACTIVE_JOBS	MAX_ACT	INTEGER Nullable	The maximum number of jobs that can run or use resources in the subsystem at one time. Contains the null value if the subsystem description specifies *NOMAX, indicating that there is no maximum.
CURRENT_ACTIVE_JOBS	CUR_ACT	INTEGER	The number of jobs currently active in the subsystem. This number includes held jobs but excludes jobs that are disconnected or suspended because of a transfer secondary job or a transfer group job. If STATUS is INACTIVE, returns 0.
SUBSYSTEM_MONITOR_JOB	SBSMONJOB	VARCHAR(28) Nullable	The qualified job name for the subsystem monitor job as identified to the system. Contains the null value if STATUS is INACTIVE.
TEXT_DESCRIPTION	TEXT	VARCHAR(50) Nullable	The text description of the subsystem description. Contains the null value if there is no text description.
CONTROLLING_SUBSYSTEM	CTL_SBS	VARCHAR(3)	Whether this subsystem is the controlling subsystem. NO This subsystem is not the controlling subsystem. YES This subsystem is the controlling subsystem.
WORKLOAD_GROUP	WRK_GROUP	VARCHAR(10) Nullable	The name of the workload group used for jobs started in this subsystem. Contains the null value if there is no workload group defined for the subsystem.
SIGNON_DEVICE_FILE_LIBRARY	DEVFILELIB	VARCHAR(10)	The name of the library in which the sign-on device file resides.
SIGNON_DEVICE_FILE	DEVFILE	VARCHAR(10)	The name of the sign-on device file.
SECONDARY_LANGUAGE_LIBRARY	LANG_LIB	VARCHAR(10) Nullable	The name of the subsystem's secondary language library. Contains the null value if there is no secondary language library defined for the subsystem.
IASP_NAME	IASP_NAME	VARCHAR(10) Nullable	The name of the auxiliary storage pool (ASP) group associated with the subsystem monitor job. This is the name of the primary ASP device in an ASP group or the name of an ASP device description. Contains the null value if the subsystem does not have an auxiliary storage pool (ASP) group associated with it. Only the libraries in the system ASP and any basic user ASPs will be in the library name space for the subsystem monitor job.

Example

Show information for all active subsystems.

SELECT *
  FROM QSYS2.SUBSYSTEM_INFO 
  WHERE STATUS = 'ACTIVE';