DSNU602I csect-name STATISTICS ARE NOT COLLECTED FOR NONPARTITIONED INDEX creator.index-name

Explanation

A LOAD or REORG TABLESPACE utility invocation specified the STATISTICS and PART keywords. A nonpartitioned index is defined on the table space. Partition-level inline statistics cannot be collected for the nonpartitioned index.

For LOAD, statistics cannot be collected because a complete index scan is needed to capture the statistics.

For REORG TABLESPACE, all keys for the nonpartitioned index need to be sorted. Not all keys for the nonpartitioned index were sorted for one of the following reasons:

  • The value of REORG TABLESPACE parameter SORTNPSI is NO, or SORTNPSI is not specified, and the value of subsystem parameter REORG_PART_SORT_NPSI is NO.
  • SORTNPSI or REORG_PART_SORT_NPSI were set to AUTO or YES, but REORG could not sort all of the nonpartitioned index keys because the amount of data that was being reorganized or the sizes of objects exceeded internal thresholds.

System action

No statistics are collected for the specified indexes, and processing continues. When INDEX ALL is specified, a DSNU602I message is issued for each nonpartitioned index.

User response

Invoke the RUNSTATS utility for the object to collect statistics for the nonpartitioned indexes.

Severity

4 (warning)