Thinking about your availability and recovery strategy shouldn't give you sleepless nights. Db2 understands the importance of keeping your database online 24x7 and with Db2 11.1 / 11.5 and its continuous delivery of new features and enhancements, you are on the right path of achieving such goals.
With the many new features introduced in 126.96.36.199, not to be overlooked are some of the enhancements made in the area of Recovery and Availability.
DB2 for LUW has undergone a lot of changes to become more “cloud friendly”. This article focuses on new DB2 11.1 features that enable direct use of Amazon S3 cloud storage, and offers considerations about security and cost when integrating some aspects your database with the cloud.
The purpose of this article is to decode the DB2 backup and restore performance statistics that are now logged in the db2diag.log. It will also discuss some factors that influence backup performance and how the performance stats can be used to identify where performance bottlenecks exist.
Data integrity is an critical feature within every DBMS, and part of integrity is keeping data in a consistent state and recoverable. It all starts in the DB2 log. Martin Hubel describes the role of the log in recovery options gives some thoughts for log management.