Ability to Manage Logs
All databases have logs associated with them. These logs keep records of database changes. If a database needs to be restored and the transactions recovered to a point beyond the time of the last full, offline backup, the logs are required to roll the data forward to that point in time. There are two types of DB2 logging, and each provides a different level of recovery capability: circular logging and archive logging.
Circular logging is the default method when a new database is created.
In the database configuration, the LOGRETAIN and USEREXIT parameters are set to NO. It is set to OFF by default.
When circular logging is used, only full, offline backups of the database are allowed.
The database must be offline (no connections ...
Get Advanced DBA Certification Guide and Reference for DB2® Universal Database™ v8 for Linux®, UNIX®, and Windows® now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
