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 > Database design details
IBM Tivoli Monitoring, Version 6.3 Fix Pack 2
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.
The database log is used to roll back changes for units of work that are not committed and to recover a database to a consistent state.
DB2 provides the following strategies for logging:
- Circular logging
Circular logging is the default log mode in which log records fill the log files and later overwrite the initial log records in the initial log file.
- Log retain logging
With log retain logging, each log file is archived when it fills with log records.
- Log performance
Ignoring the logging performance of your database can be a costly mistake, especially in terms of time. Optimize the placement of the log files for write and read performance, because the database manager must read the log files during database recovery.
Parent topic:
Database design details