 | Level: Introductory Amol D. Barsagade (amolbarsagade@in.ibm.com), Database Consultant, IBM
16 Aug 2007 A tried and tested backup and recovery strategy is essential in preventing data loss. A database can encounter any number of problems, including power interruptions, storage media failure, and application crashes. Each of these can result in a database failure and each failure requires a different recovery action. This tutorial introduces the backup and recovery capabilities in IBM® DB2® for Linux®, UNIX® and Windows®. In addition, it presents a step-by-step approach showing how to recover data in various failure scenarios.
In this tutorial
- Database logging
- How to change the database logging mode
- Best practices to keep database data safe
- How to recover an entire database after a failure
- How to recover when a table space container gets dropped or corrupted
- How to recover a table that is dropped by accident
- How to recover to a specific point-in-time
Objectives - Understand the different data recovery options offered by a database
management system (DBMS).
- Have a data recovery plan in place that implements the various options.
Prerequisites
This tutorial is written for DB2 9. Therefore, general familiarity with DB2 9 is
assumed.
System requirements
To complete this tutorial, you must have DB2 9 installed and running.
Duration
1 hour
Formats html, pdf
Tutorial overview
Global support organizations are based on customer service and satisfaction.
As such, protecting against failures is a huge challenge for the database administrator.
In production or 24 X 7 environments, where databases are mission critical, any data loss
is unacceptable. This tutorial helps you to understand the different data recovery options offered by a DBMS as well as have a data recovery plan in place that implements them.
| | | |
