Use offline reorganization of tables and indexes

With Tivoli® Storage Manager Version 7.1.1, you can reorganize indexes and tables offline to maintain server stability and improve database performance. To enable this feature, set the DISABLEREORGTABLE, DISABLEREORGINDEX, and DISABLEREORGCLEANUPINDEX server options.

You can specify these server options in the dsmserv.opt file to resolve the following issues:
  • Delays when you reorganize tables, which prevents reorganization on other tables.
  • Server that halts because the active log becomes full during index reorganization.
  • Server applications cancel when you use reorganization to resolve deadlocks.