SYSTEM_STATUS_INFO view
The SYSTEM_STATUS_INFO view returns a single row containing details about the current partition. This view uses the QSYS2.SYSTEM_STATUS table function with DETAILED_INFO => 'ALL'.
For better performance, use SYSTEM_STATUS_INFO_BASIC except when the additional job table columns returned by SYSTEM_STATUS_INFO are needed by the query.
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: To see non-null values for the columns from PARTITION_NAME through UNUSED_CPU_TIME_SHARED_POOL, the caller must have *USE authority to the QSYS/QPMLPMGT service program.
- *JOBCTL special authority, and
- *USE authority to the QSYS/QWTCTJBS program.
The following table describes the columns in the view. The system name is SYS_STATUS. The schema is QSYS2.
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:
|
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:
|
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. |
JOBS_SIGNED_ON | JOBS_ON | INTEGER | The number of jobs currently signed on the system. System request jobs and group jobs are not included in this number. |
JOBS_DISCONNECTED | JOBS_DSC | INTEGER | The number of jobs that have been disconnected due to either the selection of option 80 (Temporary sign-off) or the entry of the Disconnect Job (DSCJOB) command. |
JOBS_SUSPENDED_BY_SYSREQ | JOBS_SYSRQ | INTEGER | The number of user jobs that have been temporarily suspended by system request jobs so that another job may be run. |
JOBS_SUSPENDED_BY_GROUP_JOB | JOBS_GRP | INTEGER | The number of user jobs that have been temporarily suspended by group jobs so that another job may be run. |
JOBS_PRINT_WAITING | JOBS_PRT | INTEGER | The number of sessions that have ended with printer output files waiting to print. |
BATCH_RUNNING | BATCH_RUN | INTEGER | The number of batch jobs currently running on the system. |
BATCH_WAITING_TO_RUN | BATCH_WAIT | INTEGER | The number of batch jobs on the system that are currently waiting to run, including those that were submitted to run at a future date and time. Jobs on the job schedule that have not been submitted are not included. |
BATCH_ENDING | BATCH_END | INTEGER | The number of batch jobs that are in the process of ending due to
one of the following conditions:
|
BATCH_MESSAGE_WAIT | BATCH_MSGW | INTEGER | The number of batch jobs waiting for a reply to a message before they can continue to run. |
BATCH_HELD_WHILE_RUNNING | BATCH_RHLD | INTEGER | The number of batch jobs that had started running, but are now held. |
BATCH_HELD_ON_JOBQ | BATCH_SHLD | INTEGER | The number of batch jobs that were submitted, but were held before they could begin running. |
BATCH_ON_HELD_JOBQ | BATCH_JHLD | INTEGER | The number of batch jobs on job queues that have been assigned to a subsystem, but are being held. |
BATCH_ON_UNASSIGNED_JOBQ | BATCH_NOS | INTEGER | The number of batch jobs on job queues that have not been assigned to a subsystem. |
BATCH_PRINT_WAITING | BATCH_PRT | INTEGER | The number of completed batch jobs that produced printer output that is waiting to print. |
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.
|
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. |
TOTAL_JOB_TABLE_ENTRIES | TOTAL_JOBT | INTEGER | The total number of job table entries. This includes AVAILABLE_JOB_TABLE_ENTRIES and IN_USE_JOB_TABLE_ENTRIES. |
AVAILABLE_JOB_TABLE_ENTRIES | AVAIL_JOBT | INTEGER | The total number of job table entries that are available. |
IN_USE_JOB_TABLE_ENTRIES | INUSE_JOBT | INTEGER | The total number of job table entries that are in use. This includes ACTIVE_JOB_TABLE_ENTRIES, JOBQ_JOB_TABLE_ENTRIES, OUTQ_JOB_TABLE_ENTRIES, and JOBLOG_PENDING_JOB_TABLE_ENTRIES. |
ACTIVE_JOB_TABLE_ENTRIES | ACT_JOBT | INTEGER | The total number of entries that are in use by active jobs. |
JOBQ_JOB_TABLE_ENTRIES | JOBQ_JOBT | INTEGER | The total number of entries that are in use by jobs on a JOBQ. |
OUTQ_JOB_TABLE_ENTRIES | OUTQ_JOBT | INTEGER | The total number of entries that are in use by jobs that have ended but have spooled output still attached to the job. |
JOBLOG_PENDING_JOB_TABLE_ENTRIES | PEND_JOBT | INTEGER | The total number of entries that are in use by jobs that have ended but have a pending job log. |
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.
|
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.
|
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.
|
BOUND_HARDWARE_THREADS | HW_BND_THR | VARCHAR(3) Nullable
|
Whether 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. |
MACHINE_SERIAL_NUMBER | MACH_SER | CHAR(8) | The machine serial number. |
ATTENTION_LIGHT | ATTN_LIGHT | VARCHAR(3) | The status of the system attention light.
|
IPL_MODE | IPL_MODE | VARCHAR(9) | The current IPL mode setting.
|
IPL_TYPE | IPL_TYPE | CHAR(1) | Type of IPL performed.
|
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. |
ACCESS_PATH_TARGET_
RECOVERY_TIME |
SMAPP | VARCHAR(7) Nullable
|
The time, in minutes, targeted for access path
protection for the system.
Contains the null value if the user does not have *JOBCTL special authority. |
SMAPP_INCLUDE_ACCESS_PATHS
|
SMAPP_AP | VARCHAR(9) Nullable
|
Indicates whether the access path recovery time
should include only those access paths which are considered eligible for protection or include all
access paths.
Contains the null value when ACCESS_PATH_RECOVERY_TIME is *OFF or if the user does not have *JOBCTL special authority. |
ACCESS_PATH_ ESTIMATED_
RECOVERY_TIME |
AP_RECOV | INTEGER Nullable
|
The amount of time, in minutes, that the system will
take to recover the access paths on the system during initial program load (IPL) and during the vary
on of all currently available independent storage pools (IASPs). This value assumes that all access
paths that are protected are recovered at IPL or during vary on of IASPs. The estimated system
access path recovery time is influenced by SMAPP_INCLUDE_ACCESS_PATHS.
Contains the null value when ACCESS_PATH_RECOVERY_TIME is *OFF or if the user does not have *JOBCTL special authority. |
ACCESS_PATH_ESTIMATED_INELIGIBLE_
RECOVERY_TIME |
AP_INELIG | INTEGER Nullable
|
The total time, in minutes, that it will take to
recover all access paths which are not eligible for system-managed access path protection.
Contains the null value when ACCESS_PATH_RECOVERY_TIME is *OFF or if the user does not have *JOBCTL special authority. |
SMAPP_DISK_STORAGE_USED | SMAPP_STG | BIGINT Nullable
|
The total amount of auxiliary disk storage, in
megabytes, used by internal objects that are used exclusively for system-managed access path
protection (SMAPP). This value is the sum of the auxiliary storage used for access path protection
for each auxiliary storage pool (ASP). Contains the null value when ACCESS_PATH_RECOVERY_TIME is *OFF or if the user does not have *JOBCTL special authority. |
POWER_ENTERPRISE_
POOL_PROCESSORS |
PEP_PROC | INTEGER Nullable
|
The number of cores assigned to this system as a
member of a Power Enterprise Pool. Contains the value -1 if the system is at a level higher than
Power Enterprise Pool level 1.0. Contains the null value if this system is not a member of a Power Enterprise Pool. |
Examples
- Review the state of the job table entries for the
partition.
SELECT TOTAL_JOB_TABLE_ENTRIES, AVAILABLE_JOB_TABLE_ENTRIES, IN_USE_JOB_TABLE_ENTRIES, ACTIVE_JOB_TABLE_ENTRIES, JOBQ_JOB_TABLE_ENTRIES, OUTQ_JOB_TABLE_ENTRIES, JOBLOG_PENDING_JOB_TABLE_ENTRIES FROM QSYS2.SYSTEM_STATUS_INFO;