Online Reorganization
DB2 UDB v8 has the capability of reorganizing both tables and indexes online; that is, while users have full read or write access to these objects. Along with an enhanced REORG TABLE command, there is a new REORG INDEXES command.
Table Reorganization
The performance of your database is significantly impacted by the physical distribution of the table data. After many transactions, logically sequential data might no longer reside on physically sequential data pages, making additional read operations to access data necessary. Table reorganization corrects this problem while reclaiming space.
There are two main approaches that you can use to determine whether a table needs to be reorganized:
Invoke the runstats utility, which ...
Get DB2® Version 8: The Official Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
