DB2 9 for LUW Advanced Database Recovery

M/UX
Chicago, Denver, KC, Los Angeles, Phoenix, San Francisco, Sacramento, Seattle, St. Louis, United States

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' This is an advanced course 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 for Linux.


Skills Taught

--------------------------------------------------------------------------------

After completing this course, you should be able to: 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 Gain a better understanding of DB2 database crash recovery processing 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 Understand the benefits and limitations of disaster recovery alternatives including log shipping to a standby database or using DB2 replication 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


Course outline

--------------------------------------------------------------------------------

DB2 Database Recovery Review: This lecture will review the basic concepts and facilities involved in DB2 Database recovery that were covered in the student’s prerequisite DB2 Database Administration Course. In the lab exercise, the student will configure the DB2 logs to support a specific application. DB2 Recovery Log Management: This lecture will describe DB2 database configuration parameters that effect logging. The management of DB2 logs is described including the archival and retrieval of logs by the log manager function. Other key concepts are introduced, including the database seed and log sequence numbers. The DB2 facility for infinite log space will be described. In the lab exercise, the database will be configured to support automatic archiving for DB2 logs. The log management routines will be used to retrieve archived logs during a database roll forward. Dropped Table Recovery: This lecture will describe the DB2 facility to recover from an SQL DROP TABLE statement issued in error, including implementing dropped table recovery for selected table spaces and using the DB2 LIST HISTORY command to gather the information needed to recover a dropped table. This lab exercise will demonstrate the ability to recover a single table’s data online after being DROPed. Database Rebuild Support: This unit describes the option of the RESTORE Utility to REBUILD a database. The processing for a disaster recovery and a partial database recovery using the standard recovery option available prior to DB2 9 will be reviewed. Recovery options like performing database recovery using a set of table space backup images instead of using a database backup image will be explained. The use of the REBUILD option to simplify a series of different recovery scenarios will be presented. Students will also learn how to monitor the database rebuild processing using the LIST UTILITIES command. This unit will include the special considerations for rebuilding a partial database that only includes a specific list of table spaces. Planning for rebuilding partitioned DB2 databases and nonrecoverable databases will be explained. The lab exercise allows the student to recover a subset of the table spaces in a database and then later complete the recovery or the excluded table space. Table space Recovery: The lecture describes the planning and considerations for doing point in time recovery of selected table spaces. The usage of the QUIESCE command to establish a consistent point in time for recovery will be described. This lab will take the student through a recovery scenario to better understand the implications of recovering a DB2 database after a Point in Time Rollforward for a selected table space has completed. Incremental Backup and Restore: This lecture will describe the DB2 backup options for creating incremental database and table space backup images to reduce the duration of the backup processing and the size of the backup image. The lab will let the student experience the use of the incremental database and table space backup images for automatic and manual incremental restoring of table spaces. DB2 Database Crash Recovery: This lecture will describe database configuration parameters that effect crash recovery, including parallel recovery processing. The handling of offline table spaces will also be described. This lab exercise will allow the student to review the messages created during a DB2 database restart that performs crash recovery processing. One exercise will measure the impact of the softmax DB2 database configuration option on the performance of database crash recovery. DB2 Database and Table Space Relocation: The lecture will describe the option of the Restore Utility to alter the containers for selected table spaces during the restore process. Topics include using the SET TABLESPACE CONTAINERS command to define new containers during a redirected restore and using redirected restore as part of a disaster recovery. The relocation of the automatic storage managed table spaces will be explained. This lab exercise provides the student with experience using the REDIRECT option of the Restore command in two different situations, using a Redirected Restore to add a container for an SMS table space and performing a Redirected Restore to replace a container for a DMS table space, both using the CLP commands. The db2relocatedb command will be used to update the DB2 database configuration to reflect container changes made with operating system facilities. DB2 Additional Recovery Facilities: The lecture describes the LOAD Utility options COPY YES, COPY NO and NONRECOVERABLE impact on database recovery. Other topics include protecting the database from loss of log files, using the DB2 ARCHIVE LOG command to make the current DB2 log available for archival and implementing the DB2 option for blocking update transactions when the log disk becomes full. The option of the DB2 Backup Utility to include the active logs associated with an online backup will be explained. Several autonomic management options will be presented, including automation of database backups and options to limit the performance impact of database backups on the applications using the database. The lab exercise is an online lab which allows the student to test the three recovery modes for the DB2 LOAD Utility: COPY YES, COPY NO and NONRECOVERABLE. One exercise will demonstrate the option to bypass the closing of the active log by an online backup. The student will also implement log mirroring and use the mirror copy of the logs for Crash recovery processing. DB2 Recovery History File: The lecture will describe the contents of the DB2 Recovery History file and how to u ...''

Phone:866-700-9811

School Address:

pSeries/AIX, CISCO, Linux, Microsoft, Professional Skills, Project Management, RedHat LINUX Enrollments 866-700-9811 (Toll Free) or 916-226-2537

CICS, iSeries/OS400, Enterprise/zSeries and WebSphere Enrollments 888-689-3326 (Toll Free) or 916-226-2511

DB2 UDB, Rational Software, and Tivoli Enrollments 866-700-9817 (Toll Free) or 916-226-2533

M/UX
9245 Laguna Springs Drive
Suite 315
Elk Grove, CA 95758 USA

Jobs & Resumes: Chicago, Denver, KC, Los Angeles, Phoenix, San Francisco, Sacramento, Seattle, St. Louis
Houses & Roommates: Chicago, Denver, KC, Los Angeles, Phoenix, San Francisco, Sacramento, Seattle, St. Louis

Using Rational Data Architect
DB2 9 Database Administration Workshop for Linux/UNIX/Windows
DB2 Universal Database Administration Workshop for Windows
DB2 Universal Database Administration Workshop for UNIX
DB2 UDB Multi Partition Database Administration Workshop for UNIX
DB2 9 for LUW Multiple Partition DBA Workshop
DB2 UDB for z/OS and OS/390 Data Sharing Implementation
DB2 for z/OS and OS/390 Data Sharing Recovery and Restart
DB2 for Linux, UNIX, and Windows Performance Tuning and Monitoring Workshop
DB2 Stored Procedures Programming Workshop
DB2 UDB Application Programming Workshop
DB2 UDB for z/OS System/Disaster Recovery Workshop
Query and Manage XML data with DB2 9
DB2 UDB for z/OS Stored Procedures using COBOL
DB2 and SQL Programming Workshop
iSeries RPG IV Version 5 Programming Fundamentals Workshop
iSeries RPG IV Version 5 Programming Advanced Workshop
iSeries Advanced System Operator Workshop Version 5

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: Want to find a place to stay close to the school? Or homestay in a different country? Try the house rental message board where you can search for roommates and post shared rooms or apartments for rent.