DB2 9 for LUW Advanced Database Recovery

DB2 9 for LUW Advanced Database Recovery Course Description

Duration: 4.00 days (32 hours)

Price: $2,680.00

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.

Next Class Dates

Sep 25, 2017 – Sep 28, 2017
10:00 AM – 7:00 PM ET

View More Schedules »

Contact us to customize this class with your own dates, times and location. You can also call 1-888-563-8266 or chat live with a Learning Consultant.

Back to Top

Intended Audience for this DB2 9 for LUW Advanced Database Recovery Course

  • » 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.

Back to Top

This Course is also part of:

Back to Top

DB2 9 for LUW Advanced Database Recovery Course 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

Back to Top

DB2 9 for LUW Advanced Database Recovery Course Outline

      1. Module: 1
        1. DB2 Database Recovery Review
        2. Configuring DB2 for Recovery
        3. DB2 Recovery Log Management
        4. Managing DB2 Log Files
        5. Dropped Table Recovery
        6. DB2 Dropped Table Recovery
      2. Module: 2
        1. Database Rebuild Support
        2. Database Rebuild Support
        3. Table Space Recovery
        4. Table Space Point-in-Time Recovery
        5. Incremental Backup and Recovery
        6. Incremental Backup and Restore
        7. DB2 Database Crash Recovery
      3. Module: 3
        1. Database Crash Recovery
        2. DB2 Database and Table Space Relocation
        3. DB2 Table space Relocation
        4. DB2 Additional Recovery Facilities
        5. Additional Recovery Facilities
        6. DB2 Recovery History File
        7. High Availability and Split Mirror Database Copy
      4. Module: 4
        1. DB2 High Availability using split mirror copies
        2. Basic Database Disaster Recovery Techniques
        3. DB2 Database Disaster Recovery using Log Shipping
        4. DB2 High Availability Disaster Recovery (HADR)
        5. DB2 High Availability Disaster Recovery (HADR)
        6. DB2 DPF Partitioned Database Recovery

Back to Top

Do you have the right background for DB2 9 for LUW Advanced Database Recovery?

Skills Assessment

We ensure your success by asking all students to take a FREE Skill Assessment test. These short, instructor-written tests are an objective measure of your current skills that help us determine whether or not you will be able to meet your goals by attending this course at your current skill level. If we determine that you need additional preparation or training in order to gain the most value from this course, we will recommend cost-effective solutions that you can use to get ready for the course.

Our required skill-assessments ensure that:

  1. All students in the class are at a comparable skill level, so the class can run smoothly without beginners slowing down the class for everyone else.
  2. NetCom students enjoy one of the industry's highest success rates, and pass rates when a certification exam is involved.
  3. We stay committed to providing you real value. Again, your success is paramount; we will register you only if you have the skills to succeed.
This assessment is for your benefit and best taken without any preparation or reference materials, so your skills can be objectively measured.

Take your FREE Skill Assessment test »

Back to Top

Award winning, world-class Instructors

Our instructors are passionate at teaching and are experts in their respective fields. Our average NetCom instructor has many, many years of real-world experience and impart their priceless, valuable knowledge to our students every single day. See our world-class instructors.   See more instructors...

Back to Top

Client Testimonials & Reviews about their Learning Experience

We are passionate in delivering the best learning experience for our students and they are happy to share their learning experience with us.
Read what students had to say about their experience at NetCom.   Read student testimonials...

Back to Top

Ways to contact us

Back to Top