Solving Operational Business Intelligence with InfoSphere Warehouse Advanced Edition

292 Solving Operational Business Intelligence with InfoSphere Warehouse Advanced Edition

backups. Creating a full database backup can now take place independent of the

production data warehouse. Support for IBM Tivoli® Storage Manager is

included. This tool eliminates the need to take repeated full database backups,

reduces backup times, and can help provide access to a current full database

backup at all times.

DB2 Recovery Expert

The DB2 Recovery Expert tool interrogates your database transaction logs and

backup history to help identify the restore options available to you, and even

generates the undo or redo SQL necessary for recovery. In addition, DB2

Recovery Expert can analyze logs to identify which tables have been changed,

and this information can be used to determine which table spaces are hot and

need to be backed up. Backup images created using the DB2 Merge Backup tool

are supported.

Optim High Performance Unload

IBM Optim High Performance Unload for DB2 for Linux, UNIX, and Windows

(Optim High Performance Unload) allows data to be unloaded directly from

backup images or from table space containers without being directed through the

DB2 software layer and optimizer. This allows for increased unload speeds and

avoids unnecessary effect on DB2 resources and the query workload. When

used in conjunction with the LOAD or INGEST commands, application data can

be unloaded and directed to the database more efficiently.

8.2 Plan a backup and recovery strategy

A recovery strategy drives a database backup plan. The most effective recovery

strategy is the one that requires the least amount of data and steps to complete;

only the data that is lost is recovered.

Identifying and planning for the recovery scenarios that are most likely to occur

are the key factors in determining the speed with which you can recover from

data loss or corruption. To begin planning your backup and recovery strategy, be

aware of the following information:

򐂰 Recovery scenarios and objectives to be addressed by the backup strategy

򐂰 Strategy and schedule for loading data

򐂰 Backup and recovery infrastructure

򐂰 Data needs of downstream systems