MEMORY_POOL_INFO view

The MEMORY_POOL_INFO view returns one row for every active pool.

The information returned is similar to the detail seen from the Work System Status (WRKSYSSTS) command. It does not reset the statistical columns; to do this, use the associated table function, MEMORY_POOL.

Authorization: None required.

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

Table 1. MEMORY_POOL_INFO view
Column Name System Column Name Data Type Description
SYSTEM_POOL_ID POOL_ID INTEGER The system-related pool identifier for each of the system storage pools that currently has main storage allocated to it.
POOL_NAME POOL_NAME VARCHAR(10) The name of this storage pool. The name may be a number, in which case it is a private pool associated with a subsystem, or one of the following special values.
*MACHINE
The machine pool.
*BASE
The base system pool, which can be shared with other subsystems.
*INTERACT
The shared pool used for the QINTER subsystem.
*SPOOL
The shared pool used for spooled writers.
*SHRPOOLx
A shared pool.
CURRENT_SIZE CURR_SIZE DECIMAL(20,2) The amount of main storage, in megabytes, in the pool.
RESERVED_SIZE RSVD_SIZE DECIMAL(10,2) The amount of storage, in megabytes, in the pool reserved for system use (for example, for save/restore operations).
DEFINED_SIZE DFND_SIZE DECIMAL(20,2) The size of the pool, in megabytes, as defined in the shared pool, subsystem description, or system value QMCHPOOL. Contains the null value for a pool without a defined size.
MAXIMUM_ACTIVE_THREADS MAX_THREAD INTEGER The maximum number of threads that can be active in the pool at any one time.
CURRENT_THREADS CURR_THRD INTEGER The number of threads currently using the pool.
CURRENT_INELIGIBLE_THREADS INEL_THRD INTEGER The number of ineligible threads in the pool.
SUBSYSTEM_LIBRARY_NAME SUBLIB_NAM VARCHAR(10)
Nullable
 The library containing the subsystem name. Contains the null value for shared pools.
SUBSYSTEM_NAME SUB_NAME VARCHAR(10)
Nullable
 The subsystem with which this storage pool is associated. Contains the null value for shared pools.
DESCRIPTION DESC VARCHAR(50)
Nullable
 The description of the shared pool. Contains the null value for private pools or if a description does not exist for a shared pool.
PAGING_OPTION PAGE_OPT VARCHAR(10) Whether the system will dynamically adjust the paging characteristics of the storage pool for optimum performance.
*FIXED
The system does not dynamically adjust the paging characteristics.
*CALC
The system dynamically adjusts the paging characteristics.
USRDFN
The system does not dynamically adjust the paging characteristics for the storage pool but uses values that have been defined through the QWCCHGTN API.
ELAPSED_TIME ELAP_TIME INTEGER The time, in seconds, since the measurement start time.
ELAPSED_DATABASE_FAULTS ELAP_DBF DECIMAL(10,1) The rate, in page faults per second, of database page faults against pages containing either database access paths or data.
ELAPSED_NON_DATABASE_FAULTS ELAP_NDBF DECIMAL(10,1) The rate, in page faults per second, of nondatabase page faults against pages other than those designated as database pages.
ELAPSED_TOTAL_FAULTS ELAP_TOTF DECIMAL(10,1) The rate, in page faults per second, of database faults and non-database faults.
ELAPSED_DATABASE_PAGES ELAP_DBP DECIMAL(10,1) The rate, in pages per second, at which database pages are brought into the storage pool.
ELAPSED_NON_DATABASE_PAGES ELAP_NDBP DECIMAL(10,1) The rate in pages per second at which nondatabase pages are brought into the storage pool.
ELAPSED_ACTIVE_TO_WAIT ELAP_ATW DECIMAL(10,1) The rate, in transitions per minute, of transitions of threads from an active condition to a waiting condition.
ELAPSED_WAIT_TO_INELIGIBLE ELAP_WTI DECIMAL(10,1) The rate, in transitions per minute, of transitions of threads from a waiting condition to an ineligible condition.
ELAPSED_ACTIVE_TO_INELIGIBLE ELAP_ATI DECIMAL(10,1) The rate, in transitions per minute, of transitions of threads from an active condition to an ineligible condition.
TUNING_PRIORITY TUN_PRIOR INTEGER
Nullable
 The priority of the shared storage pool used by the system when making automatic performance adjustments. Contains the null value for private pools defined in subsystem descriptions.
TUNING_MINIMUM_SIZE TUN_MIN_SZ DECIMAL(10,2)
Nullable
 The minimum amount of storage to allocate to the shared storage pool (as a percentage of total main storage). Contains the null value for private pools defined in subsystem descriptions.
TUNING_MAXIMUM_SIZE TUN_MAX_SZ DECIMAL(10,2)
Nullable
 The maximum amount of storage to allocate to the shared storage pool (as a percentage of total main storage). Contains the null value for private pools defined in subsystem descriptions.
TUNING_MINIMUM_FAULTS TUN_MIN_FT DECIMAL(10,2)
Nullable
 The maximum page faults per second to use as a guideline for the shared storage pool. Contains the null value for private pools defined in subsystem descriptions.
TUNING_MAXIMUM_FAULTS TUN_MAX_FT DECIMAL(10,2)
Nullable
 The minimum page faults per second to use as a guideline for the shared storage pool. Contains the null value for private pools defined in subsystem descriptions.
TUNING_THREAD_FAULTS TUN_THR_FT DECIMAL(10,2)
Nullable
 The page faults per second for each active thread to use as a guideline for the shared storage pool. Contains the null value for private pools defined in subsystem descriptions.
TUNING_MINIMUM_ACTIVITY TUN_MIN_AC DECIMAL(10,2)
Nullable
 The minimum value that the shared pool's activity level can be set to by the performance adjuster when the QPFRADJ system value is set to 2 or 3. Contains the null value for private pools defined in subsystem descriptions.
TUNING_MAXIMUM_ACTIVITY TUN_MAX_AC DECIMAL(10,2)
Nullable
 The maximum value that the shared pool's activity level can be set to by the performance adjuster when the QPFRADJ system value is set to 2 or 3. Contains the null value for private pools defined in subsystem descriptions.

Example

Return all active pool information.
SELECT * FROM QSYS2.MEMORY_POOL_INFO;