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.
This week we have IBM's Florence Dubois' presentation from IDUG NA 2014 on best practices to prepare of the recovery of multiple objects. Taking regular backups is necessary but far from sufficient for anything beyond minor application recovery.
October is Backup and Recovery month. It is also the month of goblins, ghouls and scary stories. Kurt Struyf tells us that these two themes often go together. Kurt presents a horror story of what can go terribly wrong when you don't have a good backup and recovery strategy.