News
Abstract
QSYS2.SYSPARTITIONSTAT and QSYS2.SYSTABLESTAT views
Content
You are in: IBM i Technology Updates > Db2 for i - Technology Updates > Db2 for i Database Engineer (DBE) Enhancements > QSYS2.SYSPARTITIONSTAT and QSYS2.SYSTABLESTAT
Enhanced with IBM i 7.4 SF99704 Level 7 and IBM i 7.3 SF99703 Level 18:
Columns added:
- VARIABLE_LENGTH_SEGMENTS - The number of variable-length data space segments in all partitions or members of the table.
- BLOCKED_INSERT_OPERATIONS - Number of SQL blocked insert operations for the partition or member since the last IPL.
- BLOCKED_INSERT_ROWS - Number of rows inserted with SQL blocked insert operations for the partition or member since the last IPL.
See the IBM Documentation for details: QSYS2.SYSPARTITIONSTAT and QSYS2.SYSTABLESTAT
[{"Business Unit":{"code":"BU070","label":"IBM Infrastructure"},"Product":{"code":"SWG60","label":"IBM i"},"Component":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB68","label":"Power HW"}}]
Was this topic helpful?
Document Information
Modified date:
22 March 2025
UID
ibm16174441