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 all tables:

When you select to collect statistics on all tables, you can only change the sample percentage.

  1. Type a value from 1 to 100 percent. The default is 25 percent. Not applicable for LOB table spaces.

[Partitioned Table Space Statistics task ]

[Table Space Statistics task ]

[Table Space Load task ]