Maintaining the enterprise database

The enterprise database used with a IBM Traveler High Availability pool requires periodic maintenance just like the internal database used by a standalone server.

After many changes to table data, the table and its indexes can become fragmented. Logically sequential data might reside on nonsequential pages, forcing the database manager to perform additional read operations to access data. Enterprise database servers provide utilities for maintaining the databases. For example, DB2® provides REORG and RUNSTATS utilities to help maintain optimal performance for the database. These utilities can be configured to run automatically. Microsoft SQL Server provides similar index reorganization utilities. Whether run manually or automatically, a regularly scheduled maintenance plan is essential to maintain peak performance of your system. We recommend performing online index maintenance once a week during non-peak hours and offline maintenance about once a month. Consult the database server product documentation for more information on database maintenance.
Note: Since server version 9.0.1.8, IBM Traveler includes the ability to run database maintenance. For more information, refer to IBM Traveler database maintenance for standalone servers.

Online database maintenance

The database allows read and write access during maintenance action and there is minimum performance impact to the application.
DB2
REORG INDEXES ALL FOR TABLE <tablename> CLEANUP ONLY
For more information about this command and performing REORG commands for DB2, refer to the information on the REORG INDEXES/TABLE command in this topic.
Microsoft SQL Server
ALTER INDEX ALL ON <tablename> REORGANIZE
For more information about this statement and maintaining indexes, refer to the Reorganize and Rebuild Indexes section of this link.

Offline database maintenance

The database only allows read access or no access during maintenance action or the maintenance action causes excessive locking. Either case can cause temporary service outages for your Traveler environment.
DB2
REORG INDEXES ALL FOR TABLE <tablename>REORG TABLE <tabelname>
For more information about performing REORG commands for DB2, refer to the information on the REORG INDEXES/TABLE command in this topic
Microsoft SQL Server
ALTER INDEX ALL ON <tablename> REBUILD
For more information about this statement and performing ALTER INDEX commands for Microsoft SQL Server, refer to the information on the ALTER INDEX section of this link.
ALTER TABLE <tablename> REBUILD
For more information about this statement and performing ALTER TABLE commands for Microsoft SQL Server, refer to the information in the ALTER TABLE section of this link.
DBCC CHECKDB
For more information about performing DBCC CHECKDB commands for Microsoft SQL Server, refer to the information in the DBCC CHECKDB section of this link.