To avoid fragmentation, you must manage tables and indexes in your DB2 UDB for UNIX and Windows database. An object (that is, a table or index) is fragmented if it has, for example, overflow rows or a bad cluster ratio. Fragmented objects can reduce database performance and lead to poor application response time.
Fragmentation has the following effects:
Tables are fragmented if the table has overflow rows or the ratio between allocated pages and used pages is bad. The result is bad buffer-pool quality, high IO rates, and less free space for other objects in the same table space.
Indexes are fragmented if the cluster ratio is bad. The result is bad buffer pool quality, high IO rates, and less free space for other objects in the same table space.
You avoid fragmentation and so minimize loss of performance for your DB2 UDB for UNIX and Windows database and the SAP system.