 | Level: Introductory Sylvia Qi (sylviaq@ca.ibm.com), WebSphere Application Server Function Verification Tester, IBM Toronto Lab
Raul Chong (rfchong@ca.ibm.com), DB2 Express Community Facilitator, IBM Toronto Lab
18 Jul 2006 Learn the basics of database backup and recovery. This tutorial explains the different methods of database recovery and logging, and how to use the BACKUP, RESTORE, ROLLFORWARD, and RECOVER commands. It also covers the new DATABASE REBUILD operation. This is the first of a two-part discussion of high availability; Part 7 covers split mirroring and high-availability disaster recovery. This is the sixth in a series of seven tutorials to help you prepare for the DB2® 9 for Linux®, UNIX®, and Windows™ Database Administration (Exam 731). Objectives - Understand the recovery methods available with DB2
- Understand the transaction logs and the different types of logs available
- Understand the types of logging methods that can be used
- Perform backup and recovery operations
- Understand index re-creation issues
Prerequisites
To take the DB2 9 DBA exam, you must have already passed the DB2 9 Fundamentals exam 730.
If it's available, we recommend that you take the DB2 Fundamentals tutorial series before starting this series. If the Fundamentals series is not yet available, it's fine to do this DBA series first.
To understand the material presented in this tutorial you should be familiar with:
- The DB2 environment
- Use of the command line processor and DB2 GUI tools
- The different DB2 objects, such as buffer pools, tablespaces, tables, and indexes
- Basic SQL operations that can be performed against a database
System requirements
You do not need a copy of DB2 to complete this tutorial. However, you will get more out of the tutorial if you download the free trial version of IBM DB2 9 to work along with this tutorial.
Duration
Less than two hours
Formats html, pdf
| | | |
