DSNU618I csect-name SYSINDEXPART 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 index.

CARD = card-value
CARDF = cardf-value
NEAROFFPOS = nearoffpos-value
NEAROFFPOSF = nearoffposf-value
FAROFFPOS = faroffpos-value
FAROFFPOSF = faroffposf-value
LEAFDIST = leafdist-value
SPACEF = spacef-value
DSNUM = dsnum-value
EXTENTS = extents-value
LEAFNEAR = leafnear-value
LEAFFAR = leaffar-value
PSEUDO_DEL_ENTRIES= psuedo_del_entries-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. If this value equals 0, the statistics apply to the entire index. If it is a non-zero value, the statistics apply to the specified partition of the index.

card-value

This value is set to -1 for most table spaces, and CARDF contains the collected statistic value. For a non-large table spaces only, it is the number of rows in the partition or index, as an integer value.

For more information about non-large table spaces, see Table space types and characteristics in Db2 for z/OS.

cardf-value

The number of rows in the partition or index, as a floating point value.

nearoffpos-value

The number of rows pointed to that are near but not at their optimal positions, as an integer value. For large table spaces, the value of NEAROFFPOS is set to -1.

nearoffposf-value

The number of rows pointed to that are near but not at their optimal positions, as a floating point value.

faroffpos-value

The number of rows pointed to that are far from their optimal positions, as an integer value. For large table spaces, the value of FAROFFPOS is set to -1.

faroffposf-value

The number of rows pointed to that are far from their optimal positions, as a floating point value.

leafdist-value

100 times the average distance in page IDs between successive leaf pages during a sequential access of the index.

spacef-value

The space currently allocated for all extents, measured in kilobytes.

dsnum-value

The number of data sets.

extents-value

The number of extents for the last data set of the object.

leafnear-value

The number of leaf pages physically near the previous leaf page for successive active leaf pages.

leaffar-value

The number of leaf pages located physically far away from the previous leaf pages for successive active leaf pages accessed in an index scan.

psuedo_del_entries-value

The number of entries that are logically deleted.

This message is routed to SYSPRINT.