Reorg table DB2 Step 1 run reorgchk: ------CODE START--------------- db2 reorgchk update statistics on table all > output.out ------CODE END------------------ Running the command this way will run across all tables rather than RUNSTATS across every table. The reorgchk update statistics report has two sections; the first section is the table information and the second section is the indexes. If there's an asterisk in the last column a reorganization is needed. To reorganize the tables with an asterisk in the last column: -------CODE START---------------- db2 reorg table table_name -------CODE END------------------ where table_name is the name of the table to be reorganized;... Read more →