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
- This value is set to -1 for most table spaces, and theFIRSTKEYCARDF column contains the collected value. For non-large table spaces, it is the number of distinct values of the first key column, as an integer value.
For more information about non-large table spaces, see Table space types and characteristics in Db2 for z/OS.
- firstkeycardf-value
- The number of distinct values of the first key column, as a floating point value
- fullkeycard-value
- This value is set to -1 for most table spaces, and the FULLKEYCARDF column contains the collected value. For non-large table spaces, it is 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
This message is routed to SYSPRINT.
System action
Processing continues.
User response
No action is required.
Severity
0 (informational)