Articles & Content

Archives

Best Practices for Your Database Recovery Strategy (C08)

Topic: DB2 for LUW

Subtopic: 2011



DATE: 2011-5-4 (02:45 PM - 03:45 PM)
SPEAKERS: Katherine Kurtz (IBM Canada Lab ), Dale McInnis (IBM Canada Lab )

In a perfect world, accidents would not happen, and no one would ever need to recover their database - but then there is reality! It is important that you are able to recover the data you need rapidly, especially in today's dynamic warehousing environments. This presentation will cover an overview of how to plan the backup and recovery strategy for your data warehouse database. We will be focused on DPF (ie. partitioned) databases, and the strategies you can put in place for the backup and recovery of large databases.

EXP. LEVEL: Beginner,Intermediate

OBJECTIVES:

How to structure your backup strategy, ensuring you are able to recover the information you need to.

Partition level recovery to end of logs

Database recovery to end of logs

Database recovery to point in time

Use of Optim High Performance Unload to reload an object.



Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.