DATA SHEET - RECOVERY MANAGEMENT for DB2

RECOVERY MANAGER for DB2
       

Benefits

> Automates disaster recovery

> Reduces outages by optimizing job streams

> Reduces recovery time with exclusive recovery avoidance features

> Identifies and recovers all objects required for maintaining referential integrity

> Increases recovery accuracy

> Reduces backup time with exclusive backup avoidance features

> Reduces errors and costs by supporting disaster recovery simulation

Features

> Automatically chooses the best recovery strategy

> Supports automatic index backup and recovery

> Supports LOBs

> Supports revalidation and analysis against LB/RB copies and LP/RP copies

> Supports DB2 7.1 and DB2 8.1

Your Business Challenge

DB2 recoveries are becoming increasingly difficult and complex. If your organization is going to be prepared to handle any recovery contingency, you need answers to these questions:

> How do you minimize recovery time and costs?

> How do you recover all necessary objects?

> How do you determine the optimal recovery point?

> How do you maintain referential integrity?

> How do you ensure that your JCL is coded correctly the first time?

> How do you compensate for shrinking IT staff and decreasing levels of experience?

> How do you verify that you have all copies and logs that are required for a disaster recovery?

BMC Software Answers the Challenge

The BMC Software RECOVERY MANAGER for DB2 product provides an innovative, cost-effective method to manage DB2 backup and recovery procedures. RECOVERY MANAGER is a comprehensive management tool for application and system object backup and recovery that provides unrivalled functionality and ease of use.

DB2 8.1 Exploitation

RECOVERY MANAGER supports DB2 8.1 by providing support for the following features:

> UNICODE names

> 4096 partitions

> data-partitioned secondary indexes (DPSIs)

> table-controlled partitioning

> online schema evolution

> long keys (up to 2000 bytes) and nonpadded varying-length index keys

> variable CISIZE

> long names (up to 128 characters) for creator, table, index, and STOGROUP names

Push Button Recovery

With RECOVERY MANAGER, you can act quickly, regardless of the size of table spaces, the complexity of structures, or the frequency of backups.

RECOVERY MANAGER lets you group related objects for recovery. RECOVERY MANAGER finds all dependencies, analyzes all recovery requirements, and generates the most efficient recovery job streams possible. RECOVERY MANAGER eliminates time-consuming, manual, error-prone steps.

Streamlined Preparation

RECOVERY MANAGER lets you prepare for any type of recovery before it becomes necessary.

Recovery Manager for DB2 Main Menu

Object grouping

With RECOVERY MANAGER, you can create groups of DB2 objects that must be recovered together. Identifying objects in advance gives you the advantage of speed and accuracy when a recovery becomes necessary. RECOVERY MANAGER lets you group these objects in a variety of ways, including table space name pattern, referential integrity relationships, plan or package dependencies, pending status, volume, and application owner name. You can establish backup and recovery options for these groups, reducing the number of tasks and decisions at recovery.

Ease of use

RECOVERY MANAGER provides features to make your tasks easier and quicker to perform. Among these features are the following:

Online interface

You can perform most functions using the RECOVERY MANAGER ISPF interface. Panel flow ensures that you set all necessary options and lets you view and save the generated JCL. Online help is provided to aid in usage.

Batch group maintenance

You can rename, delete, or set options for multiple groups at the same time in batch mode. You can identify groups by name or by wildcard pattern.

Job stream generation and optimization

RECOVERY MANAGER generates optimized job streams for you, which reduces manual efforts and errors. The generated JCL includes the following advantages:

> reduces tape handling by performing stacked tape analysis before generating job steps

> enables concurrent processing by generating multiple jobs based on workload analysis

> optimizes concurrent processing by performing data set sizing before generating job steps

Speed and Efficiency

RECOVERY MANAGER can greatly reduce the time and resources that are required for backup and recovery. With its exclusive backup and recovery avoidance features, RECOVERY MANAGER reduces your resource usage while increasing your speed and efficiency. RECOVERY MANAGER also assists in determining the optimal recovery point.

Backup avoidance

For backups, RECOVERY MANAGER identifies objects that have not changed since the last backup and excludes them from the backup process. Your backups take less time and require less media space. These savings let you back up your applications more frequently, which can reduce the time necessary for a recovery.

Recovery avoidance

For recoveries, RECOVERY MANAGER identifies objects that have not changed between the recovery point and the current time and excludes them from recovery. Reducing the number of objects that must be recovered can significantly reduce processing time and CPU usage.

Recovery point selection

Choosing an optimal recovery point can speed recovery by reducing the amount of log that you must apply to restore your applications. RECOVERY MANAGER assists in identifying the best recovery points through SYSCOPY and log-range analysis. RECOVERY MANAGER can also convert a logical recovery point into a physical recovery point, saving you time and effort.

Recovery of DB2 system resources

RECOVERY MANAGER eases the most complex, infrequent recoveries by generating job streams to recover all critical DB2 system resources, as follows:

> DB2 catalog and directory

> Active logs

> Archive logs

> Bootstrap data set

By providing JCL that ensures that all system resources are recovered correctly and in the proper sequence, RECOVERY MANAGER lets you begin recovery within minutes instead of hours.

Volume Recovery

Although hardware failure occurs infrequently, it is still a possibility with serious potential consequences. Even when a volume is completely unavailable, RECOVERY MANAGER can interactively determine which objects need to be recovered and generate an optimized recovery job online or in batch mode.

RECOVERY MANAGER also generates IDCAMS steps to delete and redefine the objects, which dramatically reduces downtime. If the failing volume contained both IMS and DB2 data sets, you can coordinate recovery activities between RECOVERY MANAGER products for IMS and DB2.

RECOVERY MANAGER Work Flow

Disaster Recovery

Disaster recovery is the most complex and error-prone type of recovery and yet the recovery that you can least afford to have go wrong. RECOVERY MANAGER saves valuable time and resources by automating disaster recovery functions for the DB2 subsystem.

Disaster recovery preparation at the local site

RECOVERY MANAGER streamlines the recovery process by gathering information from the local site and building a comprehensive job to execute at the recovery site. RECOVERY MANAGER can also make copies of the archive logs and capture DB2 system information that are required for recovery of the system resources offsite.

RECOVERY MANAGER provides a tape pick list for copies and logs to ensure that the right resources are identified for offsite shipment. The tape pick list also speeds recovery at the recovery site.

Disaster recovery at the recovery site

In a disaster, RECOVERY MANAGER generates JCL to perform the processes required to restart and recover the DB2 system and the application data. RECOVERY MANAGER optimizes the recovery process by logically dividing work across multiple jobs and synchronizing job steps. With proper preparation, RECOVERY MANAGER can have your applications running at the recovery site with remarkable ease.

Disaster recovery simulation

The costs that are associated with testing disaster recovery plans are considerable. RECOVERY MANAGER, with RECOVER PLUS for DB2, supports a disaster recovery simulation feature. Simulation lets you confirm that all required recovery resources are available and verify their integrity before they are needed for a test (or real) recovery. While simulation cannot fully replace disaster recovery tests, it can reduce errors and costs that are associated with tests.

LOB Support

RECOVERY MANAGER supports the backup and recovery of DB2 large object (LOB) and LOB-related table spaces by using BMC Software or IBM utilities.

Ensuring success

Successful recoveries require more than speed—they also demand accuracy. With RECOVERY MANAGER, recoveries are performed correctly the first time. Automated processes decrease the amount of DBA time and expertise that are required for building and maintaining a recovery plan.

Group revalidation

The group revalidation feature ensures that objects which are added to the system are not lost to the group definitions. RECOVERY MANAGER supports revalidation and analysis against LP/RP copies and LB/RB copies, using the alternate resources option in the BMC Software RECOVER PLUS for DB2 product.

Recovery validation

RECOVERY MANAGER analyzes all required objects to determine whether they are recoverable.

Batch reporting

Reports can be generated to help you validate or verify your groups:

> Recoverability

> Recovery assets

> Recall list

> Tape volume list

Dependency analysis

RECOVERY MANAGER identifies all objects that must be recovered together to the same point of consistency.

Recovery post-processing

As an option, RECOVERY MANAGER generates job streams to make backups of newly recovered table spaces and to run a CHECK utility (from BMC Software or IBM). You can use the job stream function to reset table space pending indicators.

Log optimization

The logging environment modeling tool in RECOVERY MANAGER can dramatically reduce the amount of DASD space that is required by the DB2 logs. You can examine and view logging scenarios for a selected DB2 subsystem to optimize the amount of DASD space that is required by active and archive logs.

Recovery Management for DB2 Solution

RECOVERY MANAGER remains an individual product but is also available as a component of the Recovery Management for DB2 solution. The Recovery Management for DB2 solution comprises the following components:

> RECOVERY MANAGER for DB2

> RECOVER PLUS for DB2

> COPY PLUS for DB2

> Log Master for DB2

> SNAPSHOT UPGRADE FEATURE for DB2

The Recovery Management for DB2 solution provides the features of the individual components and integrates exclusive component technologies into more powerful and robust methods for backup and recovery of your data.

Features exclusive to the Recovery Management for DB2 solution include

> inflight recovery technology to eliminate the need for application quiesces

> backout recovery strategy

> backup and recovery avoidance

> disaster recovery data collection and analysis

> index recover-to-rebuild strategy

> Online Consistent Copy technology

World Class Support

At BMC Software, we want our customers to succeed. We realize that our Recovery Management products are an integral part of your business-critical environment. That is why we provide comprehensive, best-of-breed customer support services 24/7. Whether you have a basic question or a complex product issue, our support services and expert technical analysts are available to address your needs effectively.

Helping you maintain advantage

BMC Software Education Services offers a strategic investment for your business, maximizing the value for your employees and Business Service Management initiatives. Education ensures successful product implementation, promoting mastery of all product capabilities and highest productivity with your BMC Software solutions. To explore our education offerings, visit our web page at http://www.bmc.com/bmceducation, or contact BMC Software Education Services by telephone or e-mail:

> North America
Telephone: 800 574 4262
E-mail: education@bmc.com

> Asia Pacific
Telephone: +61 3 9657 4404
E-mail: ISD_AP@bmc.com

> Europe, Middle East, and Africa (EMEA)
Telephone: 00800 26233822
E-mail: emea_education@bmc.com

About BMC Software

BMC Software, Inc. [NYSE:BMC], is a leading provider of enterprise management solutions that empower companies to manage their IT infrastructure from a business perspective. Delivering Business Service Management, BMC Software solutions span enterprise systems, applications, databases, and service management. Founded in 1980, BMC Software has offices worldwide and fiscal 2004 revenues of more than $1.4 billion. For more information about BMC Software, visit www.bmc.com.

Copyright 2005 BMC Software, Inc., as an unpublished work. All rights reserved.

BMC Software, the BMC Software logos, and all other BMC Software product or service names are registered trademarks or trademarks of BMC Software, Inc.

IBM is a registered trademark of International Business Machines Corporation.

DB2 is a registered trademark of International Business Machines Corporation.

All other trademarks belong to their respective companies.

December 16, 2005

58270