IBM Support

QSYS2.SYSPARTITIONSTAT and QSYS2.SYSTABLESTAT views

News


Abstract

QSYS2.SYSPARTITIONSTAT and QSYS2.SYSTABLESTAT views

Content

You are in: IBM i Technology Updates > Db2 for i - Technology UpdatesDb2 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:
  1. VARIABLE_LENGTH_SEGMENTS - The number of variable-length data space segments in all partitions or members of the table.
  2. BLOCKED_INSERT_OPERATIONS - Number of SQL blocked insert operations for the partition or member since the last IPL.
  3. BLOCKED_INSERT_ROWS - Number of rows inserted with SQL blocked insert operations for the partition or member since the last IPL.
systablestat and syspartitionstat columns for blocked insert and more

See the IBM Documentation for details:  QSYS2.SYSPARTITIONSTAT and QSYS2.SYSTABLESTAT

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Component":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB57","label":"Power"}}]

Document Information

Modified date:
11 April 2021

UID

ibm16174441