Start of change

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:
  • *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_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';
End of change