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 > Logging

IBM Tivoli Monitoring, Version 6.3 Fix Pack 2


Log retain logging

With log retain logging, each log file is archived when it fills with log records.

New log files are made available for log records. Retaining log files enables roll-forward recovery, which reapplies changes to the database based on completed units of work (transactions) that are recorded in the log. You can specify that roll-forward recovery is done to the end of the logs, or to a specific point in time before the end of the logs. Because DB2 never directly deletes archived log files, the application is responsible for maintaining them (for example, archiving, purging, and so on).


Parent topic:

Logging

+

Search Tips   |   Advanced Search