IBM Support

Enhanced QSYS2.SYSPARTITIONSTAT catalog

News


Abstract

The SYSPARTITIONSTAT view contains one row for every table partition or table member. If the table is a distributed table, the partitions that reside on other database nodes are not contained in this catalog view. They are contained in the catalog views of the other database nodes.

Content

You are in: IBM i Technology Updates > Db2 for i - Technology UpdatesDb2 for i Functional Enhancements > Enhanced QSYS2.SYSPARTITIONSTAT catalog
See the SQL Reference for details: SYSPARTITIONSTAT view

Enhanced with IBM i 7.3 SF99703 Level 3 and IBM i 7.2 SF99702 Level 14

  • Addition of the PARTITION_TEXT column

[{"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":"","Line of Business":{"code":"LOB08","label":"Cognitive Systems"}}]

Document Information

Modified date:
13 January 2020

UID

ibm11146490