Changing table options
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 either the Table
Space Statistics task from Partitioned Table Space Statistics task (for DB2 for OS/390 Version 5 or 6) or Table Space Statistics task (for DB2 for OS/390 Version 5 or 6) or the
table space or table LOAD (for DB2 for OS/390 Version 6 and later).
To change table options for table space statistics
using individual tables:
- 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.
Depending on the task that you were doing
when you selected to change table options
for RUNSTATS, return to either:
[Partitioned Table Space Statistics task ]
[Table Space Statistics task ]
[Table Space Load task ]