News
Abstract
Two of the Db2 for i statistical catalogs have been extended to include the NUMBER_PARTITIONING_KEYS column.
Content
You are in: IBM i Technology Updates > Db2 for i - Technology Updates > Db2 for i Database Engineer (DBE) Enhancements > Number of partition keys - added to statistical views
Two of the Db2 for i statistical catalogs have been extended to include the NUMBER_PARTITIONING_KEYS column.
This column returns the number of partitioning keys to make it easier for other IBM and third-party products to process the partitioning keys.
The new column has been added to these statistical catalogs:
QSYS2 and SYSIBM - SYSPARTITIONSTAT
QSYS2 and SYSIBM - SYSTABLESTAT
QSYS2 and SYSIBM - SYSPARTITIONSTAT
QSYS2 and SYSIBM - SYSTABLESTAT
Figure 1. NUMBER_PARTITIONING_KEYS Column definition
[{"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:
25 March 2025
UID
ibm11168792