SYSTEM_STATUS_INFO_BASIC view

The SYSTEM_STATUS_INFO_BASIC view returns a single row containing details about the current partition. This view uses the QSYS2.SYSTEM_STATUS table function with DETAILED_INFO => 'BASIC'.

This view contains the same information as SYSTEM_STATUS_INFO except it excludes the job table columns.

The information returned is similar to the detail seen from the Work with System Status (WRKSYSSTS) and the Work with System Activity (WRKSYSACT) commands, information available in the HMC and with the Retrieve Partition Information (dlpar_get_info) API, and journal attribute values. It does not reset the statistical columns; to do this, use the associated table function, SYSTEM_STATUS table function.

Authorization: Non-null values are returned for the columns from PARTITION_NAME through UNUSED_CPU_TIME_SHARED_POOL for callers with *USE authority on the QSYS/QPMLPMGT service program.

To return values for TEMPORARY_JOB_STRUCTURES_AVAILABLE and PERMANENT_JOB_STRUCTURES_AVAILABLE, callers must have *JOBCTL special authority and *USE authority on the QSYS/QWTCTJBS program.

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

Table 1. SYSTEM_STATUS_INFO _BASIC view
Column Name	System Column Name	Data Type	Description
TOTAL_JOBS_IN_SYSTEM	TOTAL_JOBS	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	MAX_JOBS	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	ACT_JOBS	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	INTER_JOBS	DECIMAL(5,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	ELAP_TIME	INTEGER	The time that has elapsed, in seconds, between the measurement start time and the current system time.
ELAPSED_CPU_USED	ELAP_USED	DECIMAL(5,2)	The average of the elapsed time during which the processing units were in use.
ELAPSED_CPU_SHARED	ELAP_SHARE	DECIMAL(5,2) Nullable	The percentage of the total shared processor pool capacity used by all partitions using the pool during the elapsed time. Returns null if this is a dedicated partition.
ELAPSED_CPU_UNCAPPED_ CAPACITY	ELAP_UNCAP	DECIMAL(5,2) Nullable	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	CONFIGCPUS	INTEGER	Total number of configured CPUs for the partition.
CPU_SHARING_ATTRIBUTE	CPU_SHARE	VARCHAR(8) Nullable	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 this is a dedicated partition.
CURRENT_CPU_CAPACITY	CPU_CAP	DECIMAL(5,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	CPU_RATE	DECIMAL(5,2)	Always returns 0. This information has moved to the QSYS2.SYSTEM_ACTIVITY_INFO table function: SYSTEM_ACTIVITY_INFO table function.
AVERAGE_CPU_UTILIZATION	CPU_AVG	DECIMAL(5,2)	Always returns 0. This information has moved to the QSYS2.SYSTEM_ACTIVITY_INFO table function: SYSTEM_ACTIVITY_INFO table function.
MINIMUM_CPU_UTILIZATION	CPU_MIN	DECIMAL(5,2)	Always returns 0. This information has moved to the QSYS2.SYSTEM_ACTIVITY_INFO table function: SYSTEM_ACTIVITY_INFO table function.
MAXIMUM_CPU_UTILIZATION	CPU_MAX	DECIMAL(5,2)	Always returns 0. This information has moved to the QSYS2.SYSTEM_ACTIVITY_INFO table function: SYSTEM_ACTIVITY_INFO table function.
SQL_CPU_UTILIZATION	CPU_SQL	DECIMAL(5,2) Nullable	Always contains the null value.
MAIN_STORAGE_SIZE	MAIN_STG	BIGINT	The amount of main storage, in kilobytes, in the system.
SYSTEM_ASP_STORAGE	SYS_STG	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	AUX_STG	BIGINT	The total auxiliary storage, in millions of bytes, on the system.
SYSTEM_ASP_USED	SYS_RATE	DECIMAL(5,2)	The percentage of the system storage pool (ASP number 1) currently in use.
CURRENT_TEMPORARY_STORAGE	TEMP_CUR	INTEGER	The current amount of storage, in millions of bytes, in use for temporary objects.
MAXIMUM_TEMPORARY_STORAGE_ USED	TEMP_MAX	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	PERM_RATE	DECIMAL(6,3)	The percentage of the maximum possible addresses for permanent objects that have been used.
TEMPORARY_ADDRESS_RATE	TEMP_RATE	DECIMAL(6,3)	The percentage of the maximum possible addresses for temporary objects that have been used.
TEMPORARY_256MB_SEGMENTS	TEMP_256MB	DECIMAL(5,2)	The percentage of the maximum possible temporary 256MB segments that have been used.
TEMPORARY_4GB_SEGMENTS	TEMP_4GB	DECIMAL(5,2)	The percentage of the maximum possible temporary 4GB segments that have been used.
PERMANENT_256MB_SEGMENTS	PERM_256MB	DECIMAL(5,2)	The percentage of the maximum possible permanent 256MB segments that have been used.
PERMANENT_4GB_SEGMENTS	PERM_4GB	DECIMAL(5,2)	The percentage of the maximum possible permanent 4GB segments that have been used.
TEMPORARY_JOB_STRUCTURES_ AVAILABLE	TEMP_JS	INTEGER Nullable	The number of temporary job structures that currently exist on the system that are not in use. Returns the null value if the user does not have *USE authority on the QSYS/QWTCTJBS program.
PERMANENT_JOB_STRUCTURES_ AVAILABLE	PERM_JS	INTEGER Nullable	The number of permanent job structures that currently exist on the system that are not in use. Returns the null value if the user does not have *USE authority on the QSYS/QWTCTJBS program.
HOST_NAME	HOST_NAME	VARCHAR(255)	Name of the system where this information was generated. This is the name set by CHGNETA.
PARTITION_ID	PART_ID	INTEGER	The identifier for the partition in which this view is being run.
NUMBER_OF_PARTITIONS	NUM_PART	INTEGER	The number of partitions on the physical machine. This includes partitions that are currently powered on (running) and partitions that are powered off.
ACTIVE_THREADS_IN_SYSTEM	ACT_THREAD	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	REST_STATE	VARCHAR(3)	Whether the system is in restricted state. NO System is not in restricted state. YES System is in restricted state.
*The columns from PARTITION_NAME through UNUSED_CPU_TIME_SHARED_POOL require the user to have USE authority on the QSYS/QPMLPMGT service program. Otherwise, they will contain the null value.**
PARTITION_NAME	PART_NAME	VARGRAPHIC(255) CCSID 1200 Nullable	The name of the partition as it is known to the HMC.
PARTITION_GROUP_ID	PART_GROUP	INTEGER Nullable	The LPAR group for this partition.
SHARED_PROCESSOR_POOL_ID	POOL_ID	INTEGER Nullable	The shared processor pool this partition is a member of. A shared processor pool is a set of physical processors on the physical machine that is used to run a set of shared processor partitions. A value of 0 indicates the default pool. Contains the null value if DEDICATED_PROCESSORS is YES.
DEFINED_MEMORY	DEF_MEM	BIGINT Nullable	The amount of memory (in megabytes) that was configured for this partition through the HMC.
MINIMUM_MEMORY	MIN_MEM	BIGINT Nullable	The minimum amount of main storage (in megabytes) that can be assigned to this partition.
MAXIMUM_MEMORY	MAX_MEM	BIGINT Nullable	The maximum amount of main storage (in megabytes) that can be assigned to this partition.
MEMORY_INCREMENT	MEM_INCR	BIGINT Nullable	The smallest amount of main storage (in megabytes) that can be added to or removed from this partition's memory.
DEDICATED_PROCESSORS	DED_PROC	VARCHAR(3) Nullable	Whether the partition uses dedicated processors. NO The partition does not use dedicated processors. YES The partition uses dedicated processors.
PHYSICAL_PROCESSORS	PHY_PROC	INTEGER Nullable	The number of physical processors in this physical machine that are available for use. This does not include processors on demand that have not been turned on.
PHYSICAL_PROCESSORS_SHARED_ POOL	PHY_SHARE	INTEGER Nullable	The number of physical processors that are allocated to the shared processor pool used by this partition. Contains the null value if DEDICATED_PROCESSORS is YES.
MAXIMUM_PHYSICAL_PROCESSORS	MAX_PHY	INTEGER Nullable	The maximum number of physical processors that can be active in this physical machine without installing additional processors. This value includes currently active processors and any standby (on demand) processors that are present in this physical machine.
DEFINED_VIRTUAL_PROCESSORS	DEF_VIRT	INTEGER Nullable	The number of virtual processors configured for this partition through the HMC.
VIRTUAL_PROCESSORS	VIRT_PROC	INTEGER Nullable	The number of virtual processors currently used by this partition.
MINIMUM_VIRTUAL_PROCESSORS	MIN_VIRT	INTEGER Nullable	The minimum number of virtual processors that can be configured for this partition.
MAXIMUM_VIRTUAL_PROCESSORS	MAX_VIRT	INTEGER Nullable	The maximum number of virtual processors that can be configured for this partition.
DEFINED_PROCESSING_CAPACITY	DEF_CAP	DECIMAL(5,2) Nullable	The amount of processing capacity that was configured for this partition through the HMC.
PROCESSING_CAPACITY	CAPACITY	DECIMAL(5,2) Nullable	The current (usable) amount of processing capacity available to the partition (also known as partition's entitled capacity).
UNALLOCATED_PROCESSING_CAPACITY	AVAIL_CAP	DECIMAL(5,2) Nullable	The amount of processing capacity in the partition group this partition belongs to, which is not allocated to any partition and is available for allocation.
MINIMUM_REQUIRED_PROCESSING_ CAPACITY	MIN_REQCAP	DECIMAL(5,2) Nullable	The minimum amount of processing capacity that the operating system in this partition requires for its operation.
MAXIMUM_LICENSED_PROCESSING_ CAPACITY	MAX_LICCAP	DECIMAL(5,2) Nullable	The current limit on processing capacity of this partition imposed by the operating system software license for this partition.
MINIMUM_PROCESSING_CAPACITY	MIN_CAP	DECIMAL(5,2) Nullable	The minimum amount of processing capacity that can be assigned to this partition.
MAXIMUM_PROCESSING_CAPACITY	MAX_CAP	DECIMAL(5,2) Nullable	The maximum amount of processing capacity that can be assigned to this partition.
PROCESSING_CAPACITY_INCREMENT	CAP_INCR	DECIMAL(5,2) Nullable	The smallest capacity that can be added to or removed from this partition's processing capacity.
DEFINED_INTERACTIVE_CAPACITY	DEF_INTCAP	DECIMAL(5,2) Nullable	The amount of interactive capacity that was configured for this partition through the HMC. A partition's interactive capacity is defined as this partition's portion of total interactive capacity of the physical machine.
INTERACTIVE_CAPACITY	INT_CAP	DECIMAL(5,2) Nullable	This partition's current (usable) portion of the physical machine interactive capacity.
INTERACTIVE_THRESHOLD	INT_THRESH	DECIMAL(5,2) Nullable	The maximum interactive CPU utilization which can be sustained in this partition, without causing a disproportionate increase in system overhead.
UNALLOCATED_INTERACTIVE_ CAPACITY	AVL_INTCAP	DECIMAL(5,2) Nullable	The amount of interactive capacity in the partition group this partition belongs to, which is not allocated to any partition and is available for allocation. Interactive capacity is defined as the portion of total interactive capacity of the physical machine.
MINIMUM_INTERACTIVE_CAPACITY	MIN_INTCAP	DECIMAL(5,2) Nullable	The minimum portion of the physical machine's interactive capacity that can be assigned to this partition.
MAXIMUM_INTERACTIVE_CAPACITY	MAX_INTCAP	DECIMAL(5,2) Nullable	The maximum portion of the physical machine's interactive capacity that can be assigned to this partition.
DEFINED_VARIABLE_CAPACITY_ WEIGHT	DEF_CAPW	INTEGER Nullable	The weighting factor that was configured for this partition through the HMC. Variable capacity weight is used for uncapped partitions when they compete for unused CPU cycles in the shared pool. Variable capacity weight can be in the range of 0 - 255. The larger the weight, the more the chance this partition will get additional CPU cycles from the shared pool. Contains the null value if DEDICATED_PROCESSORS is YES or if CPU_SHARING_ATTRIBUTE is CAPPED.
VARIABLE_CAPACITY_WEIGHT	VAR_CAPW	INTEGER Nullable	The weighting factor that is used to assign additional unused CPU cycles (from the shared processor pool) to the partition. Variable capacity weight is used for uncapped partitions when they compete for unused CPU cycles in the shared pool. This factor is in the range of 0 - 255. The larger the weight, the greater the chance this partition will get additional CPU cycles from the pool. A value of 0 effectively caps this partition at its current (usable) processing capacity. Contains the null value if DEDICATED_PROCESSORS is YES or if CPU_SHARING_ATTRIBUTE is CAPPED.
UNALLOCATED_VARIABLE_CAPACITY_ WEIGHT	AVAIL_CAPW	INTEGER Nullable	The amount of capacity weight that is available for allocation to the partition's variable capacity weight. Contains the null value if DEDICATED_PROCESSORS is YES or if CPU_SHARING_ATTRIBUTE is CAPPED.
HARDWARE_MULTITHREADING	HW_MLT_THR	VARCHAR(3) Nullable	Indicates whether hardware multi-threading is enabled. NO Hardware multi-threading is not enabled. YES Hardware multi-threading is enabled.
BOUND_HARDWARE_THREADS	HW_BND_THR	VARCHAR(3) Nullable	Whether hardware threads are bound. NO Hardware threads are not bound. YES Hardware threads are bound.
THREADS_PER_PROCESSOR	THREADS_PP	INTEGER Nullable	The number of hardware threads per processor when hardware multi-threading is enabled. Contains the null value if HARDWARE_MULTITHREADING is NO.
DISPATCH_LATENCY	LATENCY	DECIMAL(20,0) Nullable	The maximum time in nanoseconds between dispatches of this partition on a physical processor.
DISPATCH_WHEEL_ROTATION_TIME	DISPATCH_T	DECIMAL(20,0) Nullable	The number of nanoseconds in the hypervisor's scheduling window. Each virtual processor will be given the opportunity to execute on a physical processor some time during this period. The amount of time each virtual processor is able to use a physical processor is determined by partition processing capacity.
TOTAL_CPU_TIME	CPU_TOTAL	DECIMAL(20,0) Nullable	The number of nanoseconds of CPU time used by this partition since IPL.
INTERACTIVE_CPU_TIME	CPU_INTER	DECIMAL(20,0) Nullable	The amount of CPU time, in nanoseconds, used by interactive processes in this partition since partition IPL. An interactive process is any process doing 5250 display device I/O.
INTERACTIVE_CPU_TIME_ABOVE_ THRESHOLD	CPU_THRESH	DECIMAL(20,0) Nullable	The amount of CPU time, in nanoseconds, used by interactive processes while exceeding the interactive threshold. This is a total since IPL.
UNUSED_CPU_TIME_SHARED_POOL	CPU_UNUSED	DECIMAL(20,0) Nullable	The number of nanoseconds of CPU time that the physical processors in a shared processor pool have been idle since system IPL. Contains the null value if DEDICATED_PROCESSORS is YES or if the partition is not authorized to retrieve shared pool data.
MACHINE_TYPE	MACH_TYPE	CHAR(4)	The machine type.
MACHINE_MODEL	MACH_MOD	CHAR(4)	The machine model.
SERIAL_NUMBER	SERIAL	CHAR(8)	The machine serial number.
ATTENTION_LIGHT	ATTN_LIGHT	VARCHAR(3)	The status of the system attention light. OFF The light is off. ON The light is on.
IPL_MODE	IPL_MODE	VARCHAR(9)	The current IPL mode setting. AUTOMATIC Used for automatic remote IPL, automatic IPL by date and time, and automatic IPL after a power failure. MANUAL An operator uses the control panel to direct the system for special needs. NORMAL Requires no operator intervention during the IPL. SECURE Prevents use of the control panel to perform an IPL.
IPL_TYPE	IPL_TYPE	CHAR(1)	Type of IPL performed. A Used for special work, such as applying fixes (PTFs) and diagnostic work. B Used for routine work and when directed by a PTF procedure. C Reserved for system support. D Used for special work, such as installing and reloading programs.
JOURNAL_RECOVERY_COUNT	JRNRCYCNT	INTEGER	Specifies the system wide default journal recovery count. The journal recovery count allows you to choose between faster runtime processing of changes to journaled objects and faster IPL or vary on recovery after an abnormal shutdown. The value specified influences the frequency with which journaled objects are forced to auxiliary storage as those objects are changed. The specified journal recovery count indicates the approximate number of journaled changes that would need to be recovered during journal synchronization for this journal in the event of an IPL or vary on after an abnormal shutdown. A smaller value decreases the number of changes that would need to be recovered from this journal by increasing the frequency with which changed objects are forced to disk. A larger value increases the runtime processing of changes to journaled objects by decreasing the frequency with which changed objects are forced to disk. Changing this value may affect overall system performance as it affects the utilization of auxiliary storage devices. This value can be changed with the Change Journal Attributes (CHGJRNA) CL command. The system default for this value is 250,000.
JOURNAL_CACHE_WAIT_TIME	CACHEWAIT	INTEGER	The cache wait time, in seconds, for journal environments with caching enabled. The cache wait time is the maximum number of seconds that the system will wait before writing any lingering journal entries from main memory to disk. This value can be changed with the Change Journal Attributes (CHGJRNA) CL command. The system default for this value is 30 seconds.

Examples

Review the storage and CPU status for the partition.
```
SELECT * FROM QSYS2.SYSTEM_STATUS_INFO_BASIC;
```

Return job structure information.

SELECT 
  (SELECT CURRENT_NUMERIC_VALUE FROM QSYS2.SYSTEM_VALUE_INFO 
          WHERE SYSTEM_VALUE_NAME = 'QTOTJOB') AS INITIAL_PERM_JOB_STRUCTURES,
  (SELECT CURRENT_NUMERIC_VALUE FROM QSYS2.SYSTEM_VALUE_INFO 
          WHERE SYSTEM_VALUE_NAME = 'QADLTOTJ') AS ADDITIONAL_PERM_JOB_STRUCTURES,
  PERMANENT_JOB_STRUCTURES_AVAILABLE AS AVAILABLE_PERM_JOB_STRUCTURES,
  PERMANENT_JOB_STRUCTURES_AVAILABLE + TOTAL_JOBS_IN_SYSTEM AS TOTAL_PERM_JOB_STRUCTURES,
  (SELECT CURRENT_NUMERIC_VALUE FROM QSYS2.SYSTEM_VALUE_INFO 
          WHERE SYSTEM_VALUE_NAME = 'QACTJOB') AS INITIAL_TEMP_JOB_STRUCTURES,
  (SELECT CURRENT_NUMERIC_VALUE FROM QSYS2.SYSTEM_VALUE_INFO 
          WHERE SYSTEM_VALUE_NAME = 'QADLACTJ') AS ADDITIONAL_TEMP_JOB_STRUCTURES,
  TEMPORARY_JOB_STRUCTURES_AVAILABLE AS AVAILABLE_TEMP_JOB_STRUCTURES,
  (SELECT BUCKET_CURRENT_SIZE FROM QSYS2.SYSTMPSTG 
          WHERE GLOBAL_BUCKET_NAME = '*ACTJOB') AS TOTAL_TEMP_STORAGE_USED
FROM QSYS2.SYSTEM_STATUS_INFO_BASIC;