It's inevitable that you see a couple of DB2 fix packs every year and place the readme document in a drawer somewhere for perusal later when you are not busy. While the fix packs may contain fixes there are sometimes a few enhancements buried in the fine print.
One of the most painful experiences in the work life of a database administrator (DBA) is probably the accidental drop of a database object on a production subsystem. Most IT shops have procedures to prevent this occurrence, yet it still happens.
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.