To run statistics using The DB2 Control Center, select the desired tables (to 

select more than one table, press the 

Ctrl 

or 

Shift

 key while clicking the table 

names; to select all tables, click any table name and then press Control + A), 

right click the selection, and choose the 

Run Statistics 

option as shown in 

Figure 9 10.

Figure 9 10   Running RUNSTATS on multiple tables

On the first 

Tables

 tab move all items from the 

Available

 list to the 

Selected

 list 

by clicking the 

>>

 button. Figure 9 11 presents the sample result of the operation.

 Chapter 9. Testing and tuning 

309