DSNU624I csect-namecsect-name SYSTABSTATS CATALOG STATISTICS FOR table-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 table space that contains the table.

CARD = card-value
CARDF = cardf-value
NPAGES  = npages-value
PCTPAGES = pctpages-value
NACTIVE = nactive-value
PCTROWCOMP = pctrowcomp-value

card-value

This value is set to -1 for most table spaces, and CARDF contains the collected statistics value. For 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 table space partition, as a floating point value

npages-value

The number of pages on which rows of the table space partition appear

pctpages-value

The percentage of total pages of the table space partition that contain rows from this table

nactive-value

The number of active pages in the table space partition

pctrowcomp-value

The percentage of rows compressed within the total number of active rows in the partition

This message is routed to SYSPRINT.