SUBSYSTEM_POOL_INFO view

The SUBSYSTEM_POOL_INFO view returns information about storage pools defined for 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_POOL. The schema is QSYS2.

Table 1. SUBSYSTEM_POOL_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 pool information is being returned.
POOL_ID	POOL_ID	INTEGER	The pool ID for the subsystem pool.
POOL_NAME	POOL_NAME	VARCHAR(10)	The name of the subsystem pool. BASE The system base pool, which can be shared with other subsystems. The QBASPOOL system value defines the base pool's minimum size. The base pool contains all main storage not allocated to other pools. The QBASACTLVL system value defines its activity level. INTERACT The shared pool used for interactive work. NOSTG No storage size or activity level is assigned to this storage pool. SHRPOOL1-SHRPOOL60 Shared pools. SPOOL The shared pool for spooling writers. *USERPOOL The pool is user-defined.
MAXIMUM_ACTIVE_JOBS	MAX_JOBS	INTEGER Nullable	If the pool name is USERPOOL, the maximum number of jobs that can be active in the pool at one time. Contains the null value if the pool name is not USERPOOL.
POOL_SIZE	POOL_SIZE	DECIMAL(20,2) Nullable	If the pool name is USERPOOL, the amount of storage, in megabytes, that the pool attempts to allocate. Contains the null value if the pool name is not USERPOOL.

Example

List all the system storage pools in the QBATCH subsystem.

SELECT *
  FROM QSYS2.SUBSYSTEM_POOL_INFO 
  WHERE SUBSYSTEM_DESCRIPTION_LIBRARY = 'QSYS' AND 
        SUBSYSTEM_DESCRIPTION = 'QBATCH' AND
        POOL_NAME <> '*USERPOOL';