SYSTEM_STATUS table function

The SYSTEM_STATUS table function returns a single row containing details about the current partition.

The information returned is similar to the detail seen from the Work with System Status (WRKSYSSTS) and the Work with System Activity (WRKSYSACT) commands.

The schema is QSYS2.

reset_statistics: A character or graphic string expression that contains a value of YES or NO.
If this parameter has a value of YES, statistics are reset such that the time of this query execution is used as the new baseline. The columns that contain this statistical data have names that are prefixed with ELAPSED_. Future invocations of SYSTEM_STATUS within this connection will return statistical detail relative to the new baseline. If this parameter has a value of NO, statistics are not reset for the invocation. If this parameter is not specified, the default is NO.

The result of the function is a table containing multiple rows with the format shown in the following table. All the columns are nullable.

Table 1. SYSTEM_STATUS table function
Column Name	Data Type	Description
TOTAL_JOBS_IN_SYSTEM	INTEGER	The total number of user and system jobs that are currently in the system. The total includes: All jobs on job queues waiting to be processed. All jobs currently active (being processed). All jobs that have completed running but still have output on output queues to be produced.
MAXIMUM_JOBS_IN_SYSTEM	INTEGER	The maximum number of jobs that are allowed on the system. When the number of jobs reaches this maximum, you can no longer submit or start more jobs on the system. The total includes: All jobs on job queues waiting to be processed. All jobs currently active (being processed). All jobs that have completed running but still have output on output queues to be produced.
ACTIVE_JOBS_IN_SYSTEM	INTEGER	The number of jobs active in the system (jobs that have been started, but have not yet ended), including both user and system jobs.
INTERACTIVE_JOBS_IN_SYSTEM	DECIMAL(10,2)	The percentage of interactive performance assigned to this logical partition. This value is a percentage of the total interactive performance available to the entire physical system.
ELAPSED_TIME	INTEGER	The time that has elapsed, in seconds, between the measurement start time and the current system time.
ELAPSED_CPU_USED	DECIMAL(10,2)	The average of the elapsed time during which the processing units were in use.
ELAPSED_CPU_SHARED	DECIMAL(10,2)	The percentage of the total shared processor pool capacity used by all partitions using the pool during the elapsed time. Returns null if this partition does not share processors.
ELAPSED_CPU_UNCAPPED_CAPACITY	DECIMAL(10,2)	The percentage of the uncapped shared processing capacity for the partition used since the last time statistics were reset. Returns null if this partition cannot use more that its configured processing capacity.
CONFIGURED_CPUS	INTEGER	Total number of configured CPUs for the partition.
CPU_SHARING_ATTRIBUTE	VARCHAR(8)	This attribute indicates whether this partition is sharing processors. If the value indicates the partition does not share physical processors, then this partition uses only dedicated processors. If the value indicates the partition shares physical processors, then this partition uses physical processors from a shared pool of physical processors. CAPPED Partition shares processors. The partition is limited to using its configured capacity. UNCAPPED Partition shares processors. The partition can use more than its configured capacity. Contains the null value if the partition does not share processors.
CURRENT_CPU_CAPACITY	DECIMAL(10,2)	The current processing capacity specifies the processor units that are being used in the partition. For a partition sharing physical processors, the current processing capacity represents the share of the physical processors in the pool it is running. For a partition using dedicated processors, the current processing capacity represents the number of virtual processors that are currently active in the partition.
AVERAGE_CPU_RATE	DECIMAL(20,2)	The average CPU rate expressed as a percentage where 100% indicates the processor is running at its nominal frequency. A value above or below 100% indicates how much the processor has been slowed down (throttled) or speeded up (turbo) relative to the nominal frequency for the processor model. For instance, a value of 120% indicates the processor is running 20% faster against its nominal speed.
AVERAGE_CPU_UTILIZATION	DECIMAL(20,2)	The average CPU utilization for all the active processors.
MINIMUM_CPU_UTILIZATION	DECIMAL(20,2)	The CPU utilization of the processor that reported the minimum amount of CPU utilization.
MAXIMUM_CPU_UTILIZATION	DECIMAL(20,2)	The CPU utilization of the processor that reported the maximum amount of CPU utilization.
SQL_CPU_UTILIZATION	DECIMAL(20,2)	Always contains the null value.
MAIN_STORAGE_SIZE	BIGINT	The amount of main storage, in kilobytes, in the system.
SYSTEM_ASP_STORAGE	BIGINT	The storage capacity of the system auxiliary storage pool (ASP number 1) in millions of bytes. This value represents the amount of space available for storage of both permanent and temporary objects.
TOTAL_AUXILIARY_STORAGE	BIGINT	The total auxiliary storage, in millions of bytes, on the system.
SYSTEM_ASP_USED	DECIMAL(10,2)	The percentage of the system storage pool (ASP number 1) currently in use.
CURRENT_TEMPORARY_STORAGE	INTEGER	The current amount of storage, in millions of bytes, in use for temporary objects.
MAXIMUM_TEMPORARY_STORAGE_USED	INTEGER	The largest amount of storage, in millions of bytes, used for temporary objects at any one time since the last IPL.
PERMANENT_ADDRESS_RATE	DECIMAL(6,3)	The percentage of the maximum possible addresses for permanent objects that have been used.
TEMPORARY_ADDRESS_RATE	DECIMAL(6,3)	The percentage of the maximum possible addresses for temporary objects that have been used.
TEMPORARY_256MB_SEGMENTS	DECIMAL(10,2)	The percentage of the maximum possible temporary 256MB segments that have been used.
TEMPORARY_4GB_SEGMENTS	DECIMAL(10,2)	The percentage of the maximum possible temporary 4GB segments that have been used.
PERMANENT_256MB_SEGMENTS	DECIMAL(10,2)	The percentage of the maximum possible permanent 256MB segments that have been used.
PERMANENT_4GB_SEGMENTS	DECIMAL(10,2)	The percentage of the maximum possible permanent 4GB segments that have been used.
HOST_NAME	VARCHAR(255)	Name of the system where this information was generated.
PARTITION_ID	INTEGER	The identifier for the partition in which this view is being run.
NUMBER_OF_PARTITIONS	INTEGER	The number of partitions on the system. This includes partitions that are currently powered on (running) and partitions that are powered off.
ACTIVE_THREADS_IN_SYSTEM	INTEGER	The number of initial and secondary threads in the system (threads that have been started, but have not yet ended), including both user and system threads.
RESTRICTED_STATE	VARCHAR(3)	Whether the system is in restricted state. NO System is not in restricted state. YES System is in restricted state.

Example

Return storage and CPU status for the partition. Specify to reset all the elapsed values to 0.

SELECT * FROM TABLE(QSYS2.SYSTEM_STATUS(RESET_STATISTICS=>'YES')) X;