Live Chat
Monday - Friday 8am - 6pm EST Chat Now
Contact Us
Monday - Friday 8am - 8pm EST 1-866-716-6688 Other Contact Options
Checkout

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:

    $

DB2 10 for LUW Advanced Database Recovery

IBM Course Code: CL493G

Vendor# CL493G

GK# 0904

Course Overview

Gain a deeper understanding of the advanced recovery features of DB2 10 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 Advanced Enterprise Edition 10.5 for Linux.

Delivery Format Options

  • Classroom Live

    Classroom Live

    Receive face-to-face instruction at one of our training center locations.

    From

    $2995 CAD

    4 day

  • Virtual Classroom Live

    Virtual Classroom Live

    Experience expert-led online training from the convenience of your home, office or anywhere with an Internet connection.

    From

    $2995 CAD

    4 day

  • Self-Paced

    Self-Paced

    Recordings, hands-on labs and expert instructors empower you to train on your own schedule.

    From

    $1440 CAD

    1 session

  • Private Group Training

    Private Group Training

    Train your entire team in a private, coordinated professional development session at the location of your choice.

    Receive private training for teams online and in-person.

Request a date or location for this course.

What You'll Learn

  • ├┐Describe the unique recovery planning requirements for DB2 10 single partition and 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
  • List the benefits and limitations of disaster recovery alternatives including log shipping to a standby database or using DB2 replication
  • Describe the use of the db2haicu command to select options for the integrated high availability cluster support for DB2 LUW 10 databases
  • List some of the advantages and disadvantages associated with various High Availability and Disaster Recovery configurations DB2 databases
  • Describe some of the differences between DB2 recovery facilities for DB2 pureScale database clusters compared to non-pureScale databases, including the use of the Cluster Caching Facilities to support Member Crash Recovery
  • Plan and implement the use of split mirror copies of DB2 databases to create snapshot database copies or use as an alternative to a standard DB2 database backup.
  • Plan, implement, and manage the Primary and Standby databases using the High Availability Disaster Recovery (HADR) facilities of DB2 10.5 for Linux, UNIX and Windows databases
  • Implement Read-Only application access to the Standby database in a HADR environment
  • Manage a HADR environment with multiple standby databases

Who Needs To Attend

This advanced course is for experienced database administrators who plan and implement recovery and high availability plans for DB2 10 for Linux, UNIX and Windows databases using single or multiple partition databases. The lab exercises can be performed using a single partition or a multiple partition database using DB2 Advanced Enterprise Edition 10.5 for Linux. This course is appropriate for those using DB2 in a z/Linux environment.

Course Outline

Download Course Outline