IBM Support




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.


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.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":"LOB57","label":"Power"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"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:
05 October 2023