Solving Operational Business Intelligence with InfoSphere Warehouse Advanced Edition

24 Solving Operational Business Intelligence with InfoSphere Warehouse Advanced Edition

multi-temperature storage functionality, InfoSphere Optim Configuration

Manager allows administrators to automate storage procedures, thus reducing

storage costs and enchancing savings to the business.

2.1.17 DB2 Recovery Expert

DB2 Recovery Expert is a tool designed to help reduce the time taken by

database administrators and support staff in recovering damaged or dropped

database objects from within production database, quickly and safely without the

need for a full database recovery. By analyzing log transactions, DBAs can

isolate accidental or incorrect changes made to tables and objects and undo

these changes with minimal impact to the business.

DB2 Recovery Export can also be applied to reduce log transactions and only

keep itemized, by table, those subsets that assist in determining the best

possible path and those resources required for a speedy recovery.

Administrators can monitor critical tables, and view changes made by date, user,

table, and other criteria.

Utilizing a simple web interface, administrators can rapidly implement recovery

strategies to best protect business database assets.

2.1.18 DB2 Merge Backup

DB2 is designed to minimize the impact of backups and shorten recovery times

on production servers. Due to time constraints, DBAs often can create only

incremental backups of there databases. This process has the benefit of only

needing short periods of time, allowing for a fast turnaround on production

databases. However, restoring a database from such a backup strategy can be

time-consuming because each incremental backup has to be restored.

DB2 Merge Backup can merge several incremental backups with the latest full

backup to create a new, more current full backup. This backup can then be used

to merge with the next day’s incremental backup to produce the next full backup.

2.1.19 InfoSphere Warehouse Packs

InfoSphere Warehouse Packs are specially created “enablers” with the goal of

helping customers implement rapid solutions to their data warehouse

requirements. They have been developed from years of experience within IBM

Note: DB2 Merge Backup is implemented from a command line interface.