Articles & Content


C17 - Demystifying Logging & Recovery in DB2 LUW

Topic: 2015 EMEA

Subtopic: DB2 for LUW

For many DBAs, how DB2 captures the changes to a database and can use that to recover from failures is a mystery. But with over 20% of the 100+ configurable database configuration parameters being related to logging and recovery, it’s important to understand how it all works and how you can be sure that you’re logging in an efficient matter and that you’re protected from various types of failures. Learn about logging strategies, how to properly configure the most important parameters (for feature and performance), and how to monitor the logging that is happening in your environment. Topics also include logging basics and concepts, mirrored logging, infinite logging, log archiving, types of recovery (crash recovery vs. roll forward), minimizing crash recovery time, and methods for limiting what gets logged.

Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.