I think that you have all seen the various announcements and press around the new DB2 10.5 and all the various features and functions. I wanted to dive a little bit deeper on the DB2 Advanced Recovery Feature. First of all now there is one package that contains all 3 of the backup and recovery tools for DB2 for LUW – DB2 Recovery Expert V4.1, DB2 Merge Backup V2.1 and Optim High Performance Unload V5.1.
With DB2 Recovery Expert V4.1 for Linux, UNIX and Windows one of the most significant features added in this release is the capability now to do granular recovery and log analysis in DB2 pureScale environments. This means that you can monitor changes to the database and quickly restore or correct erroneous data when time is of the essence. Also new in this release is the support for Adaptive Compression and Multi-Temperature Features in DB2 for LUW. The remote log analysis feature means that you can move your logs off your production machine and run log analysis without impacting the database server. Quiet Time Reporting allows you to look for times where there is least activity on the database so you can plan for database intensive activities.
In DB2 Merge Backup V2.1 for Linux, UNIX and Windows we have built on the added capability of allowing you to merge delta and incremental backups with full backups by now letting you work with different types of backups, eg. even if one is on disk and the other on some storage manager like TSM.
Optim High Performance V5.1 for DB2 LUW, which allows you to unload at lightning fast speed either from the database itself or from a database backup – now is integrated with the Optim Masking on Demand product line. This means you can unload and mask all in one step. You can use the libraries that are part of products like Optim Test Data Management, Optim Data Privacy, etc. and call them directly from within the HPU product. Also new in this release are enhancements to install and configure more easily and more performance enhancements to make this tool even faster than it already is.
These releases are optimized for DB2 10.5 Linux, UNIX and Windows but work equally as well with older versions of DB2. Have a look at these tools if you are looking for capabilities to help improve data availability, mitigate risk and accelerate crucial administrative tasks.