Database maintenance
To maintain optimal performance of your system, you must plan for and complete regularly scheduled maintenance and tuning of the TADDM database.
Default database configurations
The default database configurations that are provided with TADDM are sufficient for proof of concept, proof of technology, and small pilot implementations of TADDM.
Tuning guidelines for both DB2 and Oracle databases
- Based on storage capacity alone, do not limit the number of physical disk drives that are available to your database.
- Ideally, the following components should be placed on separate
disk drives or arrays:
- Application data (such as tables and indexes)
- Database logs
- Database temporary space: used for sort and join operations
- Use the fastest disks that are available for your log files.
- Enable Asynchronous I/O at the operating system level.
For more information on DB2 and Oracle database tuning, refer to Database Performance Tuning on AIX® at http://www.redbooks.ibm.com/redbooks/pdfs/sg245511.pdf.
For more information that is specific to DB2 database tuning, also refer to Relational Database Design and Performance Tuning for DB2 Database Servers at http://www-01.ibm.com/support/docview.wss?uid=tss1wp100764 and to DB2 UDB Version 8 Product Manuals at http://www.ibm.com/support/docview.wss?rs=71&uid=swg27009554.