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
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)