IBM Support

Number of partition keys - added to statistical views

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 UpdatesDb2 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
Figure 1. NUMBER_PARTITIONING_KEYS Column definition
image-20200117132149-1

[{"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

ibm11168792