DSNU251I csect-name UNLOAD PHASE STATISTICS. NUMBER OF RECORDS UNLOADED= mmmmmm FOR obj-type obj-qual.obj-name PART nn

Explanation

This message is issued at the completion of the UNLOAD phase of the REORG utility. It gives the number of records that were unloaded mmmmmm for partition nn of the tablespace, index, or indexspace that was specified. The count can indicate the amount of processing.

System action

Only valid table records are unloaded. Dropped table record counts are not reported.

Operator response

Count can be indicative of the amount of processing that remains.

User response

The record count represents the current cardinality of the table or index that was indicated in the error message. Consider invoking the RUNSTATS utility and then rebinding the involved PLANs if this value differs greatly from the SYSTABLE.CARD value so that the SQL optimizer can bring the PLANs up to date.

Severity

0 (informational)