IBM Tivoli Monitoring > Version 6.3 Fix Pack 2 > Installation Guides > Installation Guide > Performance tuning > Tivoli Data Warehouse > Relational database design and performance tuning for DB2 Database servers
IBM Tivoli Monitoring, Version 6.3 Fix Pack 2
Database design details
Key factors for database design include table spaces, buffer pools, and logging.
The subsequent sections include information about the following topics:
- Files that are created to support and manage your database
- Amount of required space for storing your data
- Determine how you use the table spaces that are required to store your data
- Set the various database parameters to fit your environment
- Table spaces
A table space is a physical storage object that provides a level of indirection between a database and the tables stored within the database. It is made up of a collection of containers into which database objects are stored.
- Buffer pools
A buffer pool is an area of memory into which database pages are read, modified, and held during processing.
- Logging
Maintaining the integrity of your data is important. All databases maintain log files that record database changes. DB2 logging involves a set of primary and secondary log files that contain log records that show all changes to a database.
- Database maintenance
A regularly scheduled maintenance plan is essential for maintaining peak performance of your system.
Parent topic:
Relational database design and performance tuning for DB2 Database servers