DSNU1375I NO ROWS SAMPLED FOR TABLE SPACE table-space-or-partition

Explanation

One of the following situations occurred for RUNSTATS with the TABLE TABLESAMPLE SYSTEM keyword when it was run on a populated table:

  • The specified sampling rate was too small.
  • If TABLE SAMPLE SYSTEM AUTO was specified, no rows were sampled for the partition.
  • If a sampling rate was specified, the partition was skipped because it contained too few pages with data rows for the specified sampling rate.
table-space-or-partition
The name of a table space, or a partition identified by the table space name followed by PARTITION part-num , where part-num is the partition number.

System action

Processing continues.

User response

Run the utility again with the SAMPLE keyword for the table space or partition that was identified by table-space-or-partition. If page sampling is employed, which it is by default starting in function level 505, you must specify TABLESAMPLE SYSTEM NONE SAMPLE integer.

If the original utility job specified a sampling rate for the TABLESAMPLE SYSTEM keyword other than AUTO, consider increasing the sampling rate before you submit the original RUNSTATS job again.

Severity

4 (warning)