DSNU614I csect-name SYSTABLES CATALOG STATISTICS FOR table-nametable-name

Explanation

CARD = card-value
CARDF = cardf-value
NPAGES = npages-value
NPAGESF = npagesf-value
PCTPAGES = pctpages-value
PCTROWCOMP = pctrowcomp-value
AVGROWLEN = avgrowlen-value
SPACEF = spacef-value

csect-name

The name of the control section that issued the message.

table-name

The name of the table.

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, as a floating point value.

npages-value

The number of pages on which rows of the table appear.

pctpages-value

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

pctrowcomp-value

The percentage of rows compressed within the total number of active rows in the table.

avgrowlen-value

The total number of bytes divided by the number of rows.

spacef-value

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

This message is routed to SYSPRINT.