DSNU627I csect-name SYSINDEXSTATS CATALOG STATISTICS FOR index-name PARTITION part-number

Explanation

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

CLUSTERRATIO =clusterratio-value
CLUSTERRATIOF = clusteratiof-value  
FIRSTKEYCARD = firstkeycard-value
FIRSTKEYCARDF = firstkeycardf-value  
FULLKEYCARD = fullkeycard-value
FULLKEYCARDF = fullkeycardf-value  
NLEAF = nleaf-value
NLEVELS = nlevels-value
KEYCOUNT = keycount-value 
KEYCOUNTF = keycountf-value  
DATAREPEATFACTORF= datarepeatfactorf-value

csect-name

The name of the control section that issued the message.

index-name

The name of the index.

part-number

The value that identifies the partition or data set.

clusterratio-value

The percentage of data rows in the partition that are in clustering order for this index, as an integer value.

clusterratiof-value

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 in the partition, as an integer value.

firstkeycardf-value

The number of distinct values of the first key column in the partition, as a floating point value.

fullkeycard-value

The number of distinct values of the key in the partition, as an integer value.

fullkeycardf-value

The number of distinct values of the key in the partition, as a floating point value.

nleaf-value

The number of active leaf pages in the index partition.

nlevels-value

The number of levels in the index tree in the partition.

keycount-value

The number of index keys (entries) in the partition, as an integer value.

keycountd-value

The number of index keys (entries) in the partition, as a floating point value.

datarepeatfactorf-value

The anticipated number of data pages repeatedly scanned, following index key order.

This message is routed to SYSPRINT.