Server performance can degrade when database tables and table indexes are not reorganized.
Over time, database information becomes fragmented, causing unexpected database growth and increased space requirements for the active and archive logs. Reorganizing tables and table indexes reduces fragmentation and reclaims space.
Tivoli® Storage Manager reorganizes tables and indexes by default. Allow server-initiated reorganization of both tables and indexes to run. If automatic reorganization is affecting server performance, you can schedule reorganization manually. For the most recent information about running reorganization and other considerations for Tivoli Storage Manager Version 6 servers, see technote 1452146 at http://www.ibm.com/support/docview.wss?uid=swg21452146.