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'.

Start of changeFor better performance, use SYSTEM_STATUS_INFO_BASIC except when the additional job table columns returned by SYSTEM_STATUS_INFO are needed by the query. End of change

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

Start of changeAuthorization: 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.End of change

Start of changeTo return values for TEMPORARY_JOB_STRUCTURES_AVAILABLE and PERMANENT_JOB_STRUCTURES_AVAILABLE, the caller must have:
  • *JOBCTL special authority, and
  • *USE authority to the QSYS/QWTCTJBS program.
End of change

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

Table 1. SYSTEM_STATUS_INFO 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.
Start of changeJOBS_SIGNED_ONEnd of change Start of changeJOBS_ONEnd of change Start of changeINTEGEREnd of change Start of changeThe number of jobs currently signed on the system. System request jobs and group jobs are not included in this number.End of change
Start of changeJOBS_DISCONNECTEDEnd of change Start of changeJOBS_DSCEnd of change Start of changeINTEGEREnd of change Start of changeThe 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.End of change
Start of changeJOBS_SUSPENDED_BY_SYSREQEnd of change Start of changeJOBS_SYSRQEnd of change Start of changeINTEGEREnd of change Start of changeThe number of user jobs that have been temporarily suspended by system request jobs so that another job may be run.End of change
Start of changeJOBS_SUSPENDED_BY_GROUP_JOBEnd of change Start of changeJOBS_GRPEnd of change Start of changeINTEGEREnd of change Start of changeThe number of user jobs that have been temporarily suspended by group jobs so that another job may be run.End of change
Start of changeJOBS_PRINT_WAITINGEnd of change Start of changeJOBS_PRTEnd of change Start of changeINTEGEREnd of change Start of changeThe number of sessions that have ended with printer output files waiting to print.End of change
Start of changeBATCH_RUNNINGEnd of change Start of changeBATCH_RUNEnd of change Start of changeINTEGEREnd of change Start of changeThe number of batch jobs currently running on the system.End of change
Start of changeBATCH_WAITING_TO_RUNEnd of change Start of changeBATCH_WAITEnd of change Start of changeINTEGEREnd of change Start of changeThe 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.End of change
Start of changeBATCH_ENDINGEnd of change Start of changeBATCH_ENDEnd of change Start of changeINTEGEREnd of change Start of changeThe number of batch jobs that are in the process of ending due to one of the following conditions:
  • The job finished processing normally.
  • The job ended before its normal completion point and is being removed from the system.
End of change
Start of changeBATCH_MESSAGE_WAITEnd of change Start of changeBATCH_MSGWEnd of change Start of changeINTEGEREnd of change Start of changeThe number of batch jobs waiting for a reply to a message before they can continue to run.End of change
Start of changeBATCH_HELD_WHILE_RUNNINGEnd of change Start of changeBATCH_RHLDEnd of change Start of changeINTEGEREnd of change Start of changeThe number of batch jobs that had started running, but are now held.End of change
Start of changeBATCH_HELD_ON_JOBQEnd of change Start of changeBATCH_SHLDEnd of change Start of changeINTEGEREnd of change Start of changeThe number of batch jobs that were submitted, but were held before they could begin running.End of change
Start of changeBATCH_ON_HELD_JOBQEnd of change Start of changeBATCH_JHLDEnd of change Start of changeINTEGEREnd of change Start of changeThe number of batch jobs on job queues that have been assigned to a subsystem, but are being held.End of change
Start of changeBATCH_ON_UNASSIGNED_JOBQEnd of change Start of changeBATCH_NOSEnd of change Start of changeINTEGEREnd of change Start of changeThe number of batch jobs on job queues that have not been assigned to a subsystem.End of change
Start of changeBATCH_PRINT_WAITINGEnd of change Start of changeBATCH_PRTEnd of change Start of changeINTEGEREnd of change Start of changeThe number of completed batch jobs that produced printer output that is waiting to print.End of change
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.

Start of changeThis information has moved to the QSYS2.SYSTEM_ACTIVITY_INFO table function: SYSTEM_ACTIVITY_INFO table function. End of change

AVERAGE_CPU_UTILIZATION CPU_AVG DECIMAL(5,2) Always returns 0.

Start of changeThis information has moved to the QSYS2.SYSTEM_ACTIVITY_INFO table function: SYSTEM_ACTIVITY_INFO table function. End of change

MINIMUM_CPU_UTILIZATION CPU_MIN DECIMAL(5,2) Always returns 0.

Start of changeThis information has moved to the QSYS2.SYSTEM_ACTIVITY_INFO table function: SYSTEM_ACTIVITY_INFO table function. End of change

MAXIMUM_CPU_UTILIZATION CPU_MAX DECIMAL(5,2) Always returns 0.

Start of changeThis information has moved to the QSYS2.SYSTEM_ACTIVITY_INFO table function: SYSTEM_ACTIVITY_INFO table function. End of change

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.
Start of change
TEMPORARY_JOB_STRUCTURES_
AVAILABLE
End of change
Start of changeTEMP_JSEnd of change Start of changeINTEGER
Nullable
End of change
Start of changeThe 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.

End of change
Start of change
PERMANENT_JOB_STRUCTURES_
AVAILABLE
End of change
Start of changePERM_JSEnd of change Start of changeINTEGER
Nullable
End of change
Start of changeThe 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.

End of change
Start of changeTOTAL_JOB_TABLE_ENTRIESEnd of change Start of changeTOTAL_JOBTEnd of change Start of changeINTEGEREnd of change Start of changeThe total number of job table entries. This includes AVAILABLE_JOB_TABLE_ENTRIES and IN_USE_JOB_TABLE_ENTRIES. End of change
Start of changeAVAILABLE_JOB_TABLE_ENTRIESEnd of change Start of changeAVAIL_JOBTEnd of change Start of changeINTEGEREnd of change Start of changeThe total number of job table entries that are available.End of change
Start of changeIN_USE_JOB_TABLE_ENTRIESEnd of change Start of changeINUSE_JOBTEnd of change Start of changeINTEGEREnd of change Start of changeThe 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.End of change
Start of changeACTIVE_JOB_TABLE_ENTRIESEnd of change Start of changeACT_JOBTEnd of change Start of changeINTEGEREnd of change Start of changeThe total number of entries that are in use by active jobs.End of change
Start of changeJOBQ_JOB_TABLE_ENTRIESEnd of change Start of changeJOBQ_JOBTEnd of change Start of changeINTEGEREnd of change Start of changeThe total number of entries that are in use by jobs on a JOBQ. End of change
Start of changeOUTQ_JOB_TABLE_ENTRIESEnd of change Start of changeOUTQ_JOBTEnd of change Start of changeINTEGEREnd of change Start of changeThe total number of entries that are in use by jobs that have ended but have spooled output still attached to the job.End of change
Start of changeJOBLOG_PENDING_JOB_TABLE_ENTRIESEnd of change Start of changePEND_JOBTEnd of change Start of changeINTEGEREnd of change Start of changeThe total number of entries that are in use by jobs that have ended but have a pending job log.End of change
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.
Start of changePARTITION_NAME End of change Start of changePART_NAMEEnd of change Start of changeVARGRAPHIC(255) CCSID 1200
Nullable
End of change
Start of changeThe name of the partition as it is known to the HMC.End of change
Start of changePARTITION_GROUP_IDEnd of change Start of changePART_GROUPEnd of change Start of changeINTEGER
Nullable
End of change
Start of changeThe LPAR group for this partition.End of change
Start of changeSHARED_PROCESSOR_POOL_IDEnd of change Start of changePOOL_IDEnd of change Start of changeINTEGER
Nullable
End of change
Start of changeThe 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.

End of change
Start of changeDEFINED_MEMORYEnd of change Start of changeDEF_MEMEnd of change Start of changeBIGINT
Nullable
End of change
Start of changeThe amount of memory (in megabytes) that was configured for this partition through the HMC.End of change
Start of changeMINIMUM_MEMORYEnd of change Start of changeMIN_MEMEnd of change Start of changeBIGINT
Nullable
End of change
Start of changeThe minimum amount of main storage (in megabytes) that can be assigned to this partition.End of change
Start of changeMAXIMUM_MEMORYEnd of change Start of changeMAX_MEMEnd of change Start of changeBIGINT
Nullable
End of change
Start of changeThe maximum amount of main storage (in megabytes) that can be assigned to this partition.End of change
Start of changeMEMORY_INCREMENTEnd of change Start of changeMEM_INCREnd of change Start of changeBIGINT
Nullable
End of change
Start of changeThe smallest amount of main storage (in megabytes) that can be added to or removed from this partition's memory.End of change
Start of changeDEDICATED_PROCESSORSEnd of change Start of changeDED_PROCEnd of change Start of changeVARCHAR(3)
Nullable
End of change
Start of changeWhether the partition uses dedicated processors.
NO
The partition does not use dedicated processors.
YES
The partition uses dedicated processors.
End of change
Start of changePHYSICAL_PROCESSORSEnd of change Start of changePHY_PROCEnd of change Start of changeINTEGER
Nullable
End of change
Start of changeThe 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.End of change
Start of change
PHYSICAL_PROCESSORS_SHARED_
  POOL
End of change
Start of changePHY_SHAREEnd of change Start of changeINTEGER
Nullable
End of change
Start of changeThe 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.

End of change
Start of changeMAXIMUM_PHYSICAL_PROCESSORSEnd of change Start of changeMAX_PHYEnd of change Start of changeINTEGER
Nullable
End of change
Start of changeThe 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.End of change
Start of changeDEFINED_VIRTUAL_PROCESSORSEnd of change Start of changeDEF_VIRTEnd of change Start of changeINTEGER
Nullable
End of change
Start of changeThe number of virtual processors configured for this partition through the HMC.End of change
Start of changeVIRTUAL_PROCESSORSEnd of change Start of changeVIRT_PROCEnd of change Start of changeINTEGER
Nullable
End of change
Start of changeThe number of virtual processors currently used by this partition.End of change
Start of changeMINIMUM_VIRTUAL_PROCESSORSEnd of change Start of changeMIN_VIRTEnd of change Start of changeINTEGER
Nullable
End of change
Start of changeThe minimum number of virtual processors that can be configured for this partition.End of change
Start of changeMAXIMUM_VIRTUAL_PROCESSORSEnd of change Start of changeMAX_VIRTEnd of change Start of changeINTEGER
Nullable
End of change
Start of changeThe maximum number of virtual processors that can be configured for this partition.End of change
Start of changeDEFINED_PROCESSING_CAPACITYEnd of change Start of changeDEF_CAPEnd of change Start of changeDECIMAL(5,2)
Nullable
End of change
Start of changeThe amount of processing capacity that was configured for this partition through the HMC.End of change
Start of changePROCESSING_CAPACITYEnd of change Start of changeCAPACITYEnd of change Start of changeDECIMAL(5,2)
Nullable
End of change
Start of changeThe current (usable) amount of processing capacity available to the partition (also known as partition's entitled capacity).End of change
Start of changeUNALLOCATED_PROCESSING_CAPACITYEnd of change Start of changeAVAIL_CAPEnd of change Start of changeDECIMAL(5,2)
Nullable
End of change
Start of changeThe amount of processing capacity in the partition group this partition belongs to, which is not allocated to any partition and is available for allocation.End of change
Start of change
MINIMUM_REQUIRED_PROCESSING_
  CAPACITY
End of change
Start of changeMIN_REQCAPEnd of change Start of changeDECIMAL(5,2)
Nullable
End of change
Start of changeThe minimum amount of processing capacity that the operating system in this partition requires for its operation.End of change
Start of change
MAXIMUM_LICENSED_PROCESSING_
  CAPACITY
End of change
Start of changeMAX_LICCAPEnd of change Start of changeDECIMAL(5,2)
Nullable
End of change
Start of changeThe current limit on processing capacity of this partition imposed by the operating system software license for this partition.End of change
Start of changeMINIMUM_PROCESSING_CAPACITYEnd of change Start of changeMIN_CAPEnd of change Start of changeDECIMAL(5,2)
Nullable
End of change
Start of changeThe minimum amount of processing capacity that can be assigned to this partition.End of change
Start of changeMAXIMUM_PROCESSING_CAPACITYEnd of change Start of changeMAX_CAPEnd of change Start of changeDECIMAL(5,2)
Nullable
End of change
Start of changeThe maximum amount of processing capacity that can be assigned to this partition.End of change
Start of changePROCESSING_CAPACITY_INCREMENTEnd of change Start of changeCAP_INCREnd of change Start of changeDECIMAL(5,2)
Nullable
End of change
Start of changeThe smallest capacity that can be added to or removed from this partition's processing capacity.End of change
Start of changeDEFINED_INTERACTIVE_CAPACITYEnd of change Start of changeDEF_INTCAPEnd of change Start of changeDECIMAL(5,2)
Nullable
End of change
Start of changeThe 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.End of change
Start of changeINTERACTIVE_CAPACITYEnd of change Start of changeINT_CAPEnd of change Start of changeDECIMAL(5,2)
Nullable
End of change
Start of changeThis partition's current (usable) portion of the physical machine interactive capacity.End of change
Start of changeINTERACTIVE_THRESHOLDEnd of change Start of changeINT_THRESHEnd of change Start of changeDECIMAL(5,2)
Nullable
End of change
Start of changeThe maximum interactive CPU utilization which can be sustained in this partition, without causing a disproportionate increase in system overhead.End of change
Start of change
UNALLOCATED_INTERACTIVE_
  CAPACITY
End of change
Start of changeAVL_INTCAPEnd of change Start of changeDECIMAL(5,2)
Nullable
End of change
Start of changeThe 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. End of change
Start of changeMINIMUM_INTERACTIVE_CAPACITYEnd of change Start of changeMIN_INTCAPEnd of change Start of changeDECIMAL(5,2)
Nullable
End of change
Start of changeThe minimum portion of the physical machine's interactive capacity that can be assigned to this partition.End of change
Start of changeMAXIMUM_INTERACTIVE_CAPACITYEnd of change Start of changeMAX_INTCAPEnd of change Start of changeDECIMAL(5,2)
Nullable
End of change
Start of changeThe maximum portion of the physical machine's interactive capacity that can be assigned to this partition.End of change
Start of change
DEFINED_VARIABLE_CAPACITY_
  WEIGHT
End of change
Start of changeDEF_CAPWEnd of change Start of changeINTEGER
Nullable
End of change
Start of changeThe 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.

End of change
Start of changeVARIABLE_CAPACITY_WEIGHTEnd of change Start of changeVAR_CAPWEnd of change Start of changeINTEGER
Nullable
End of change
Start of changeThe 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.

End of change
Start of change
UNALLOCATED_VARIABLE_CAPACITY_
  WEIGHT
End of change
Start of changeAVAIL_CAPWEnd of change Start of changeINTEGER
Nullable
End of change
Start of changeThe 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.

End of change
Start of changeHARDWARE_MULTITHREADINGEnd of change Start of changeHW_MLT_THREnd of change Start of changeVARCHAR(3)
Nullable
End of change
Start of changeIndicates whether hardware multi-threading is enabled.
NO
Hardware multi-threading is not enabled.
YES
Hardware multi-threading is enabled.
End of change
Start of changeBOUND_HARDWARE_THREADSEnd of change Start of changeHW_BND_THREnd of change Start of changeVARCHAR(3)
Nullable
End of change
Start of changeWhether hardware threads are bound.
NO
Hardware threads are not bound.
YES
Hardware threads are bound.
End of change
Start of changeTHREADS_PER_PROCESSOREnd of change Start of changeTHREADS_PPEnd of change Start of changeINTEGER
Nullable
End of change
Start of changeThe number of hardware threads per processor when hardware multi-threading is enabled.

Contains the null value if HARDWARE_MULTITHREADING is NO.

End of change
Start of changeDISPATCH_LATENCYEnd of change Start of changeLATENCYEnd of change Start of changeDECIMAL(20,0)
Nullable
End of change
Start of changeThe maximum time in nanoseconds between dispatches of this partition on a physical processor.End of change
Start of changeDISPATCH_WHEEL_ROTATION_TIMEEnd of change Start of changeDISPATCH_TEnd of change Start of changeDECIMAL(20,0)
Nullable
End of change
Start of changeThe 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.End of change
Start of changeTOTAL_CPU_TIMEEnd of change Start of changeCPU_TOTALEnd of change Start of changeDECIMAL(20,0)
Nullable
End of change
Start of changeThe number of nanoseconds of CPU time used by this partition since IPL.End of change
Start of changeINTERACTIVE_CPU_TIMEEnd of change Start of changeCPU_INTEREnd of change Start of changeDECIMAL(20,0)
Nullable
End of change
Start of changeThe 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.End of change
Start of change
INTERACTIVE_CPU_TIME_ABOVE_
  THRESHOLD
End of change
Start of changeCPU_THRESHEnd of change Start of changeDECIMAL(20,0)
Nullable
End of change
Start of changeThe amount of CPU time, in nanoseconds, used by interactive processes while exceeding the interactive threshold. This is a total since IPL.End of change
Start of changeUNUSED_CPU_TIME_SHARED_POOLEnd of change Start of changeCPU_UNUSEDEnd of change Start of changeDECIMAL(20,0)
Nullable
End of change
Start of changeThe 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.

End of change
Start of changeMACHINE_TYPEEnd of change Start of changeMACH_TYPEEnd of change Start of changeCHAR(4)End of change Start of changeThe machine type.End of change
Start of changeMACHINE_MODELEnd of change Start of changeMACH_MODEnd of change Start of changeCHAR(4)End of change Start of changeThe machine model.End of change
Start of changeSERIAL_NUMBEREnd of change Start of changeSERIALEnd of change Start of changeCHAR(8)End of change Start of changeThe machine serial number.End of change
Start of changeMACHINE_SERIAL_NUMBEREnd of change Start of changeMACH_SEREnd of change Start of changeCHAR(8)End of change Start of changeThe machine serial number.End of change
Start of changeATTENTION_LIGHTEnd of change Start of changeATTN_LIGHTEnd of change Start of changeVARCHAR(3)End of change Start of changeThe status of the system attention light.
OFF
The light is off.
ON
The light is on.
End of change
Start of changeIPL_MODEEnd of change Start of changeIPL_MODEEnd of change Start of changeVARCHAR(9)End of change Start of changeThe 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.
End of change
Start of changeIPL_TYPEEnd of change Start of changeIPL_TYPEEnd of change Start of changeCHAR(1)End of change Start of changeType 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.
End of change
Start of changeJOURNAL_RECOVERY_COUNTEnd of change Start of changeJRNRCYCNTEnd of change Start of changeINTEGEREnd of change Start of changeSpecifies 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.

End of change
Start of changeJOURNAL_CACHE_WAIT_TIMEEnd of change Start of changeCACHEWAITEnd of change Start of changeINTEGEREnd of change Start of changeThe 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.

End of change
Start of change
ACCESS_PATH_TARGET_
RECOVERY_TIME
End of change
Start of changeSMAPP End of change Start of changeVARCHAR(7)
Nullable
End of change
Start of changeThe time, in minutes, targeted for access path protection for the system.
1-1440
The number of minutes set for the system access path recovery time.
*MIN
The system access path recovery time is set to the minimum access path recovery time for the system, which provides for the fastest access path recovery. The eligible access paths for the entire system are protected.
*NONE
No system access path recovery time is set. No access path protection is provided by the system unless needed to meet an ASP specific target access path recovery time. However, current access path exposure is monitored and estimated access path recovery times are available.
*OFF
No access path protection is provided by the system. The system does not monitor current exposure and no estimated access path recovery times are available.
*SYSDFT
The system access path recovery time is set to the system default value.

Contains the null value if the user does not have *JOBCTL special authority.

End of change
Start of change
SMAPP_INCLUDE_ACCESS_PATHS
End of change
Start of changeSMAPP_AP End of change Start of changeVARCHAR(9)
Nullable
End of change
Start of changeIndicates whether the access path recovery time should include only those access paths which are considered eligible for protection or include all access paths.
*ALL
The access path recovery time includes all access paths, both those that are and those that are not eligible.
*ELIGIBLE
The access path recovery time includes only those access paths which are considered eligible for protection.

Contains the null value when ACCESS_PATH_RECOVERY_TIME is *OFF or if the user does not have *JOBCTL special authority.

End of change
Start of change
ACCESS_PATH_ ESTIMATED_
RECOVERY_TIME
End of change
Start of changeAP_RECOVEnd of change Start of changeINTEGER
Nullable
End of change
Start of changeThe 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.
  • If SMAPP_INCLUDE_ACCESS_PATHS is *ELIGIBLE, this value is the estimated system access path recovery time of all the eligible access paths that are not chosen for protection.
  • If SMAPP_INCLUDE_ACCESS_PATHS is *ALL, this value is the estimated system access path recovery time of all the eligible access paths that are not chosen for protection plus all the access paths that are not eligible for protection.

Contains the null value when ACCESS_PATH_RECOVERY_TIME is *OFF or if the user does not have *JOBCTL special authority.

End of change
Start of change
ACCESS_PATH_ESTIMATED_INELIGIBLE_
RECOVERY_TIME
End of change
Start of changeAP_INELIGEnd of change Start of changeINTEGER
Nullable
End of change
Start of changeThe 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.

End of change
Start of changeSMAPP_DISK_STORAGE_USED End of change Start of changeSMAPP_STGEnd of change Start of changeBIGINT
Nullable
End of change
Start of changeThe 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.

End of change
Start of change
POWER_ENTERPRISE_
POOL_PROCESSORS
End of change
Start of changePEP_PROCEnd of change Start of changeINTEGER
Nullable
End of change
Start of changeThe 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.

End of change

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;