DSNU286I csect-name REORG TABLESPACE dbname.tsname OFFPOSLIMIT SYSINDEXPART ROWS

Explanation

This is the header message for the SYSINDEXPART section of the REORG TABLESPACE OFFPOSLIMIT output. This section lists the SYSINDEXPART rows for the table space or table space partition as specified in the REORG TABLESPACE input statement. The fields from SYSINDEXPART are:
CREATOR
Index creator name
IXNAME
Index name
CREATOR
Table creator name
TBNAME
Table name
PART
Partition number
CARDF
Number of rows referenced (floating point)
FAROFFPOSF
Number of rows referenced afar (floating point)
NEAROFFPOSF
Number of rows referenced nearby (floating point)
STATSTIME
TIMESTAMP of RUNSTATS update
Rows which meet the OFFPOSLIMIT criteria are prefaced with '*'.

System action

Processing continues normally

User response

If the TIMESTAMP reported in the STATSTIME column is not recent, the OFFPOSLIMIT criteria might be evaluated with obsolete statistics.

Severity

0 (informational)