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.
- *USE authority to the subsystem description, and
- *EXECUTE authority to the library containing the subsystem description.
The following table describes the columns in the view. The system name is SBS_INFO. The schema is QSYS2.
|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.
|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.|
|The qualified job name for the subsystem monitor job as identified
to the system.
Contains the null value if STATUS is INACTIVE.
|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.
|The name of the workload group used for jobs started in this
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.|
|The name of the subsystem's secondary language library.
Contains the null value if there is no secondary language library defined for the subsystem.
|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.
- Show information for all active
SELECT * FROM QSYS2.SUBSYSTEM_INFO WHERE STATUS = 'ACTIVE';