Reorg table DB2

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 →

DB2 database design : physical design is important

The regular comment passed by DBA s is “90 % of the overall db performance is based on the code written against it” There is truth to this comment , and large amounts are written on optimising queries on DB2 databases. DB2 database design physical supports logical database design This comment came up today at a team meeting . It turned out the developer wrote a query assuming an index existed – and the query reflected this assumption. It turned out the index was missing Good physical design is important , and in most cases the DBA is responsible for... Read more →