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 Updates > Db2 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":"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"}}]
Was this topic helpful?
Document Information
Modified date:
13 January 2020
UID
ibm11146490