 | Level: Intermediate Michael Dang (dangm@ca.ibm.com), DB2 UDB Database Administrator, IBM Toronto
Sylvia Qi (sylviaq@ca.ibm.com), WebSphere Application Server Function Verification Tester, IBM Toronto Lab
19 Jul 2006 This is the last in a series of seven tutorials to help you prepare for the DB2® 9 for Linux®, UNIX®, and Windows™ Database Administration (Exam 731). This tutorial focuses on two advanced high availability topics: split mirroring and high availability disaster recovery (HADR). With split mirroring you can restore databases using disk copies. HADR provides failover support, simliar to the failover capability provided by HACMP and Microsoft™ Cluster Server. Objectives - Understand the concept of high availability
- Learn how log shipping works
- Understand how split mirroring works and learn how to use a split mirror to provide high availability
- Understand how HADR works and learn how to set up an HADR system
- Update your system online using dynamic configuration parameters
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
| | | |
