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:
-
In the Table owner field, type the table owner name, or use the
push button to search in the subsystem
for a valid USER ID name. -
In the Table name field, type the table name, or use
the push button to search in the subsystem
for a valid table name. The table must already
exist in the table space.
- In the Percent rows sampled for non-index columns field, 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.
- When a Table name is known (from the above field), the
columns in that table are listed in the Available columns list in
the Column options box. Click on a column and click
the > push button to move a column from the Available columns list
to the Selected columns list. You can move all the columns in the
table with a single action if you click the >> push button. The
reverse actions, to remove single or all columns is the <
or << push buttons. This removes columns
from the Selected columns list back to the Available columns list.
All columns in the Selected columns list
are the columns on which statistics
are gathered. You can select a maximum of
10 columns with one table space
statistics operation.
-
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 ]