IBM Support

QSYS2.SYSTEM_STATUS_INFO_BASIC

News


Abstract

The SYSTEM_STATUS_INFO_BASIC view returns a single row containing details about the current partition.

This view contains the same information as SYSTEM_STATUS_INFO except it excludes the job table and job summary 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 SYSTEM_STATUS table function.

Content

You are in: IBM i Technology Updates > Db2 for i - Technology Updates > IBM i Services (SQL) > QSYS2.SYSTEM_STATUS_INFO_BASIC
 
 
For complete detail, visit this IBM Documentation page: SYSTEM_STATUS_INFO_BASIC view
 

Enhanced with IBM i 7.6 SF99960 Level 3 IBM i 7.5 SF99950 Level 12: 

  • Add column for PARTITION_UUID

Enhanced with IBM i 7.5 SF99950 Level 8 & IBM i 7.4 SF99704 Level 29: 

  • Add column for POWER_ENTERPRISE_POOL_PROCESSORS

Enhanced with IBM i 7.5 SF99950 Level 5 and IBM i 7.4 SF99704 Level 26: 

  • Return both the serial number and the virtual serial number

Enhanced with IBM i 7.5 SF99950 Level 1, IBM i 7.4 SF99704 Level 20, and IBM i 7.3 SF99703 Level 28: 

  • Add the JOB_SCHEDULE_STATUS column

[{"Type":"MASTER","Line of Business":{"code":"LOB68","label":"Power HW"},"Business Unit":{"code":"BU070","label":"IBM Infrastructure"},"Product":{"code":"SWG60","label":"IBM i"},"ARM Category":[{"code":"a8m0z0000001go6AAA","label":"IBM i Db2-\u003ESQL Services \/ table functions"}],"ARM Case Number":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.3.0;and future releases"}]

Document Information

Modified date:
29 June 2026

UID

ibm16340749

Page Feedback