Adding table options for RUNSTATS

These steps are part of the larger task of collecting table space statistics. When you complete the steps for adding table options for RUNSTATS, return to the main Table Space Statistics task from the RUNSTATS utility option or the LOAD utility option.

To add table options for table space statistics:

  1. In the Table owner field, type the table owner name.

  2. In the Table name field, type the table name. The table must already exist in the table space.

  3. In the Percent rows sampled for non-index columnsfield, specify a percentage of rows to sample. Valid values are from 1 to 100 percent. The default is 25 percent. Do not use this field if your table space is a LOB table space.

  4. Click OK to accept the values and close the window.

[Return to Partitioned Table Space Statistics task ]

[Return to Table Space Statistics task ]

[Return to Table Space Load task ]