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 Management 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 i Knowledge Center for details:  QSYS2.SYSPARTITIONSTAT and QSYS2.SYSTABLESTAT

[{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Component":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions","Edition":""}]

Document Information

Modified date:
14 April 2020

UID

ibm16174441