DSNU617I csect-name SYSINDEXES CATALOG STATISTICS FOR index-name

Explanation

The RUNSTATS utility issues this message on multiple lines to report the statistics collected for the specified index.

CLUSTERED = clustered-value
CLUSTERRATIO = clusterratio-value
CLUSTERRATIOF = clusterratiof-value
FIRSTKEYCARD = firstkeycard-value
FIRSTKEYCARDF = firstkeycardf-value
FULLKEYCARD = fullkeycard-value
FULLKEYCARDF = fullkeycardf-value
NLEAF = nleaf-value
NLEVELS = nlevels-value
SPACEF = spacef-value
DATAREPEATFACTORF = datarepeatfactorf-value
csect-name
The name of the control section that issued the message.
index-name
The name of the index.
clustered
Whether the table is actually clustered by this index (YES or NO)
clusterratio-value
The percentage of data rows that are in clustering order for this index, as an integer value
clusterratiof-value
A number in the range 0–1 that when multiplied by 100 gives the percentage of data rows in the partition that are in clustering order for this index, as a floating point value
firstkeycard-value
The number of distinct values of the first key column, as an integer value
firstkeycardf-value
The number of distinct values of the first key column, as a floating point value
fullkeycard-value
The number of distinct values of the key, as an integer value
fullkeycardf-value
The number of distinct values of the key, as a floating point value
nleaf-value
The number of active leaf pages in the index
nlevels-value
The number of levels in the index tree
spacef-value
The space currently allocated for all extents, measured in kilobytes.
datarepeatfactorf-value
The anticipated number of data pages repeatedly scanned, following index key order
For large table spaces, the values of FIRSTKEYCARD and FULLKEYCARD are set to -1. RUNSTATS uses floating point fields to report these statistics.

All partition-by-growth (PBG) and partition-by-range (PBR) UTS, and partitioned (non-UTS) table spaces with table-controlled partitioning, are considered large table spaces because they use 5-byte RIDs and can contain more than 64 GB of data. For more information, see "Non-large table spaces (deprecated)" in Table space types and characteristics in Db2 for z/OS.

This message is routed to SYSPRINT.

System action

Processing continues.

User response

No action is required.

Severity

0 (informational)