Recovery for DB2

Master your recovery strategy and execution

Unplanned database downtime may be unavoidable, but BMC Recovery for DB2 can keep it from ruining your day. Recover from your next outage or data corruption with lightning speed by using this powerful set of recovery tools to:

  • Speed up and streamline your backup processes.
  • Recover your from a disaster immediately, with no loss of integrity.
  • Establish automatic backup and recovery jobs to lessen the impact of disaster.
  • Simulate and estimate disaster recovery scenarios to plan for resource needs.
  • Reverse damaging changes to your operational data, no matter how they were caused.

Related topics:  Mainframe, Mainframe Cost Optimization

Supercharge your backup and recovery procedures

Disaster could strike your databases at any moment. You need backup processes that keep you prepared and recovery procedures you can rely on when that moment arrives. The utilities in the Recovery for DB2 solution cover both, with high-speed, low-impact options for creating data-consistent backups, as well as the ability to automatically build recovery processes to cope with even the most complex applications.

Create backups fast, with no downtime

Use advanced copy features to create complete, data-consistent backups of your data without suspending read/write access.

Tailor backups to your needs

Choose the backup technique that best matches the size of your data—or let the tool autonomously manage the techniques for you, on an object-by-object basis.

Simulate disaster scenarios

Verify the integrity of your disaster recovery processes, check that their resource requirements will be met, and ensure that they will complete in the desired timeframe.

Automate common backup and recovery tasks

Build optimized backup and recovery job streams to run for specified groups of database objects.

Recover backward, forward, or sideways

When recovering from a disaster, choose whether to back out database changes from its current state, recover forward from a point-in-time copy, or recover into a new table space with online data migration.

Generate SQL from log information

Automatically build the SQL you need to perform recovery tasks using the information in your DB2 logs.

Maintain your data integrity

Perform multi-level checks of your data integrity, validating table spaces, indexes, and column data.

Restart failed batch processes

Improve your data’s integrity and reduce processing time with finer control over batch job restarts.

Get the most out of your backups

Put your backups to good use, not just for ensuring recoverability but for other database tasks, such as data migration between DB2 subsystems.

Contact Sales ›

Deliver near-continuous availability

  • Keep comprehensive, easy-to-recover backups without interrupting availability.  
  • Simplify the recovery process so you can get up and running again in record time.
  • Reduce the risks of disaster with integrity checks, recovery simulations, and resource assessments.
  • Ease the burden on your recovery team by automating as many tasks as possible.

“Using BMC Recovery Manager for DB2, we can determine if an object has changed after the last full copy — which means there’s no need to re-copy the extra tables. Overall, we estimate that up to 60 percent of tables are no longer copied.”

— Veit Blaeser, Systems Programmer, IDG Read more about IDG’s success with BMC solutions

Products included in this solution

The Recovery for DB2 solution is made up of the following products, all of which are designed to give you powerful, comprehensive control over your backup and recovery processes.

Recovery Manager for DB2

Prepare your systems to recover quickly and dependably from any type of disaster or corruption with BMC Recovery Manager for DB2. You’ll cut back on time and resource consumption by identifying objects that have not changed since the last backup or recovery point and excluding them from processing. Recovery Manager allows you to group similar database objects and build optimized backup and recovery job streams to protect them. In addition, you can troubleshoot your database recovery scenarios by running simulations to reducing the errors and inconsistencies you’ll find when performing full recovery tests. Recovery Manager for DB2 will gather all the information you need from your local site to build a comprehensive job that can be executed at the recovery site.

Recover Plus for DB2

Take advantage of three options for high-speed recovery with BMC Recover Plus for DB2. With advanced recovery features, Recover Plus for DB2 lets you choose the right approach for the job. With the backout recovery option, you can start from the current state of your database and back out erroneous updates until you reach your desired point. Alternatively, you can use the forward recovery function to restore an earlier point-in-time copy and apply updates from there. Finally, you have the option to use image copies and log records to recover over into a new table space and translate the object IDs. In addition, unlike traditional recovery methods, Recover Plus for DB2 allows you to recover dropped objects automatically. 

Copy Plus for DB2

Simplify and speed up your backup jobs with BMC Copy Plus for DB2, a replacement for the native DB2 copy utility. With options for compression and encryption, as well as the ability to write copies simultaneously to tape and DASD, Copy Plus for DB2 makes the backup process faster and more dependable. Copy Plus will copy related data sets automatically and can quiesce groups of related table spaces to support application recovery, if needed. The utility also automatically updates DB2 catalog information, without the need to execute RUNSTATS separately.

Check Plus for DB2

Ensure the consistency of your DB2 data using the range of integrity checking features offered by BMC Check Plus for DB2. Ranging from structural checks for your table spaces and indexes to detailed referential integrity checks on column data, Check Plus for DB2 provides a faster, more powerful alternative to the native DB2 utilities. And, with the Snapshot Upgrade Feature, running integrity checks won’t interfere with database availability.

Read more in the Check Plus for DB2 datasheet

Log Master for DB2

Leverage your log information to automatically generate SQL for critical recovery tasks using BMC Log Master for DB2. Let this utility do your work for you, when it comes to building the SQL jobs necessary to undo, redo, or migrate changes after a disaster. Log Master for DB2 will take the hassle out of batch migration jobs, drop recovery, and database audits.

Application Restart Control

Restart failed or interrupted batch jobs with minimal re-run time using BMC Application Restart Control. Simplify your application restarts with automatic checkpoint creation and selection, program exception handling, and minimal implementation requirements. Application Restart Control lets you maintain an ideal balance of performance, restart time, and checkpoint overhead.

Read more in the Application Restart Control datasheet

Snapshot Upgrade Feature

Working in concert with a variety of other BMC utilities, the Snapshot Upgrade Feature provides for near-continuous availability during many database processes. By exploiting the hardware capabilities of intelligent storage devices, the Snapshot Upgrade Feature allows you to create data-consistent copies instantaneously, with little to no outages. These point-in-time snapshot copies can be used to enhance recovery, unload, and reorg tasks.