KT-CL490 DB2 9 for LUW Advanced Database Recovery Training - Minneapolis, Minnesota IT MN Technical Financial New York, NY
Knowledge Transfer Microsoft Certified Silver Training Partner CPLS
Knowledge Transfer is a Microsoft Certified Silver Learning Partner
Oracle University

 

Microsoft Certified Training Partner CTEC
Search for a Course Topic:
Public Courses
Corporate Services & Training
 

 

 



 Course Search
Keyword
Course #
State

 Training Delivery
 
Training Delivery
Custom Curriculum
Course List
Certifications
 
 Main Menu
 
Home
View Courses
Site Index
 
 


DB2 9 for LUW Advanced Database Recovery


Description: 

Gain a deeper understanding of the advanced recovery features of DB2 9 for Linux, UNIX, and Windows database environments with single and multiple partition databases. Get practical experience in the planning and utilization of a wide variety of DB2 recovery facilities in a series of database recovery scenarios you complete during lab exercises using DB2 Enterprise 9.7 for Linux.

The purpose of this course is to enable the learning to gain a deeper understanding of the advanced recovery features of DB2 9 for Linux, UNIX, and Windows database environments with single and multiple partition databases. In this course, the learning will receive practical experience in the planning and utilization of a wide variety of DB2 recovery facilities in a series of database recovery scenarios you complete during lab exercises using DB2 Enterprise 9.7 for Linux.

This advanced course is for experienced database administrators who plan and implement recovery and high availability plans for DB2 9 for Linux, UNIX and Windows databases using single or multiple partition DPF databases. The lab exercises can be performed using a single partition or a multiple partition DPF database using DB2 Enterprise 9.7 for Linux.

This course is appropriate for those using DB2 in a z/Linux environment.

Objectives

  • Describe the unique recovery planning requirements for DB2 9 single partition and DPF multiple partition databases
  • Explore the DB2 for Linux, UNIX and Windows recovery facilities and database configuration options
  • Plan the implementation of automated archival and retrieval of database logs
  • Recover a DB2 table following a DROP TABLE command issued in error
  • Utilize the REBUILD option of the RESTORE Utility to recover a full or partial database copy using either database or table space backups
  • Plan and execute the recovery of table spaces to a selected point in time
  • Effectively utilize incremental backup and restore to reduce the size and duration of DB2 database backups
  • Describe the database crash recovery processing performed when there is an unplanned outage of a DB2 database server and select database configuration options to minimize the restart time.
  • Utilize the redirected restore option to recover DB2 data to alternate disk configurations and invoke the db2relocatedb command to alter the configuration of a DB2 database
  • Execute recovery scenarios, including loss of DB2 log data using the DB2 log mirroring option, and configure a database for automatic backups
  • Utilize the information in the DB2 recovery history file to plan and execute various DB2 utilities
  • Configure a DB2 database to automatically remove recovery objects that are no longer needed, including backups and archived logs
  • List the benefits and limitations of disaster recovery alternatives including log shipping to a standby database or using DB2 replication
  • Utilize the db2haicu command to select options for the integrated high availability cluster support for DB2 databases
  • Explore the options for operation of DB2 databases in high availability environments including the use of a split mirror copy of the database
  • Plan, implement, and manage the Primary and Standby databases using the High Availability Disaster Recovery (HADR) facilities of DB2 9 for Linux, UNIX and Windows databases
  • Implement Read-Only application access to the Standby database in a HADR environment

 
Click here to view the Course Outline
     
Prerequisite: 

You should complete:

  • DB2 9 Database Administration Workshop for Linux, UNIX, and Windows (CL2X2)
  • DB2 9 Database Administration Workshop for Linux (CL202) or
  • DB2 9 Database Administration Workshop for UNIX (CL212) or
  • DB2 9 Database Administration Workshop for Windows (CL232) or
  • Fast Path to DB2 9 for Experienced Relational DBAs (CL282) or
  • DB2 9 for Linux, UNIX, and Windows Quickstart for Experienced Relational DBAs (CL482) or
  • DB2 9 for LUW Multiple Partition DBA Workshop (CL24) or
  • DB2 9 for LUW Multiple Partition Environment for Single Partition DBAs (CL25)
  • or have equivalent experience.
 
   
     
Duration: 
4 Days  
     
     

View Printer Friendly Page

 


To Inquire About Future Classes

Request a class date

if one is not scheduled.



Comments on the Course

This Course is available as a Private Class