News
Abstract
The SYSTEM_STATUS table function returns a single row containing details about the current partition.
The information returned is similar to the detail seen from the Work with System Status (WRKSYSSTS) and the Work with System Activity (WRKSYSACT) and the Edit Recovery for Access Paths (EDTRCYAP) commands, and information available in the HMC and with the Retrieve Partition Information (dlpar_get_info) API.
Content
You are in: IBM i Technology Updates > Db2 for i - Technology Updates > IBM i Services (SQL) > QSYS2.SYSTEM_STATUS()
For complete detail, visit this IBM Documentation page: SYSTEM_STATUS table function
Enhanced with IBM i 7.5 SF99950 Level 8 & IBM i 7.4 SF99704 Level 29:
- Add column for POWER_ENTERPRISE_POOL_PROCESSORS
- Return both the serial number and the virtual serial number
Enhanced with IBM i 7.5 SF99950 Level 4 & IBM i 7.4 SF99704 Level 25:
- Add the ACCESS_PATH_TARGET_RECOVERY_TIME,
SMAPP_INCLUDE_ACCESS_PATHS,
ACCESS_PATH_ESTIMATED_RECOVERY_TIME,
ACCESS_PATH_ESTIMATED_INELIGIBLE_RECOVERY_TIME, and
SMAPP_DISK_STORAGE_USED columns
Enhanced with IBM i 7.5 SF99950 Level 3 & IBM i 7.4 SF99704 Level 23:
- SYSTEM_STATUS returns summary detail for jobs and batch job status
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
Enhanced with IBM i 7.4 SF99704 Level 10 and IBM i 7.3 SF99703 Level 22:
- Add the AVAILABLE_JOB_TABLE_ENTRIES,
IN_USE_JOB_TABLE_ENTRIES,
ACTIVE_JOB_TABLE_ENTRIES,
JOBQ_JOB_TABLE_ENTRIES,
OUTQ_JOB_TABLE_ENTRIES, and
JOBLOG_PENDING_JOB_TABLE_ENTRIES columns - Add the JOURNAL_RECOVERY_COUNT and JOURNAL_CACHE_WAIT_TIME columns
Enhanced with IBM i 7.4 SF99704 Level 7 and IBM i 7.3 SF99703 Level 18:
- Add the TEMPORARY_JOB_STRUCTURES_AVAILABLE &
PERMANENT_JOB_STRUCTURES_AVAILABLE columns - Add the MACHINE_TYPE, MACHINE_MODEL, SERIAL_NUMBER, ATTENTION_LIGHT, IPL_MODE, IPL_TYPE columns
Enhanced with IBM i 7.4 SF99704 Level 4 and IBM i 7.3 SF99703 Level 16:
- Many new columns are returned
[{"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.2.0;and future releases"}]
Was this topic helpful?
Document Information
Modified date:
28 September 2024
UID
ibm11128693