Reorganization of tables and indexes in DB2

When many updates are made on a table, the space can become fragmented. You can reorganize data to reclaim space in a table and to improve system performance. Use the IBM® DB2® REORGCHK and REORG commands to optimize table spaces and indexes. You cannot reorganize metadata tables.

The following conditions can indicate that the database tables require reorganization:

The following conditions can indicate that the indexes require reorganization:

If you determine that a reorganization can improve the performance of the table or index, you can complete the reorganization online or offline. By default, the REORG command completes offline reorganizations.

Database maintenance can reduce the time needed for reorganization. Your database maintenance routine should include archiving and trimming tables on a regular basis. Your regular database maintenance should also include running the REORGCHK command to identify tables and indexes that might require reorganization.



Feedback