DB2 for LUW Advanced Database Recovery Training Course and Workshop in Bangalore, Mysore, Chennai, Hyderabad, Pune, Mumbai, Delhi, Noida, Gurgaon, Kolkata

In DB2 for LUW Advanced Database Recovery training course, you gain a deeper understanding of the advanced recovery features of DB2 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.

By attending DB2 for LUW Advanced Database Recovery workshop, delegates will learn to:

Describe the unique recovery planning requirements for DB2 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 for Linux, UNIX and Windows databases

This DB2 for LUW Advanced Database Recovery class is intended for experienced database administrators.

DB2 Database Recovery Review

State the three types of recovery support
Explain the basic principles DB2 uses for database recovery and restart
Describe the capabilities and functional requirements of DB2 logging
Select options for some of the DB2 database parameters that support recovery

DB2 Recovery Log Management

Select the DB2 Database parameters that support the DB2 logs
Configure the database options to automate archive log management
Implement infinite active logging to support applications that require large amounts of logged database changes
Describe the options provided by DB2 for Linux, UNIX, and Windows to reduce log volume, including the NOT LOGGED INITIALLY option

DB2 Dropped Table Recovery

Explain the DB2 facility to recover from an SQL DROP TABLE statement issued in error
Implement dropped table recovery for selected table spaces
Use the DB2 LIST HISTORY command to gather the information needed to recover a dropped table
Plan and invoke the DB2 utilities involved in recovering a dropped table

Database Rebuild Support

Review the considerations of using standard DB2 database recovery options
Explain the capabilities of the REBUILD option for the RESTORE command
List the types of information included in each DB2 backup image and describe how it is used to support rebuilding a database
Plan for supporting database and disaster recovery scenarios using DB2 database and table space backups using the RESTORE command with a REBUILD option
Utilize LIST UTILITIES SHOW DETAIL to monitor progress of a RESTORE Utility during database rebuilding

Table Space Recovery

Perform a point-in-time recovery of a table space
Quiesce table spaces in share, update, and exclusive mode

DB2 Incremental Backup and Recovery

Plan a database recovery strategy that includes both full and Incremental backups to reduce the duration and size of database backups
Implement a physical database design to take advantage of Incremental backups of selected table spaces
Utilize an Incremental restore to recover a DB2 database or table space from Incremental backup images
Use the LIST UTILITIES command to track the processing of an Incremental backup or restore process

DB2 Database Crash Recovery

Describe the concepts and processing for DB2 database crash recovery
Select an appropriate value for SOFTMAX to reduce database crash recovery time
Configure DB2 database options to support crash recovery for applications
Describe the impact of a database crash and restart for DB2 Utilities like LOAD, REORG and IMPORT

DB2 Database and Table Space Relocation

Explain the facility of the DB2 RESTORE command to recover table spaces to different containers
Use the SET TABLESPACE CONTAINERS command to define new containers during a redirected restore
Utilize the RESTORE utility to change the database storage paths for AUTOMATIC STORAGE table spaces
Plan the use of redirected restore as part of a disaster recovery
Use the GENERATE SCRIPT option of RESTORE to set up a command script for a redirected restore operation
Use db2relocatedb when moving or copying DB2 databases with non-DB2 utilities

DB2 Additional Recovery Facilities

Explain the LOAD Utility options COPY YES, COPY NO and NONRECOVERABLE impact on database recovery
Select the appropriate method for protecting the database from loss of log file
Select the BACKUP Utility option to include the required logs in an online backup image
Use the DB2 ARCHIVE LOG command to make the current DB2 log available for archival
Implement the DB2 option for blocking update transactions when the log disk becomes full
Implement the DB2 Utility Throttle using the UTIL_IMPACT_LIM Database Manager configuration option
Configure a DB2 database for automatic backups
Explain the self optimizing features of the Backup Utility

DB2 Recovery History File

Explain the information recorded in the Recovery History file
Use the DB2 LIST HISTORY command to display selected information needed to plan database recovery
Retrieve information from the database recovery history using SQL
Configure a DB2 database for automatic removal of database recovery objects including backups and archived logs
Use the PRUNE HISTORY command to remove outdated information in the Recovery History
Restore a damaged Recovery History file

High Availability and Split Mirror Database Copy

Describe various techniques for supporting High Availability of DB2 databases
Explain the concepts involved when implementing the automated failover of a DB2 database
Describe the integrated cluster configuration and management features of DB2
Plan for using split mirror copies to create a standby database, a database snapshot or a database mirror
Utilize the SET WRITE SUSPEND and DBD2INIDB commands with split mirror database copies
Use the AS SNAPSHOT option of the DB2 BACKUP and RESTORE utilities

Basic Database Disaster Recovery Techniques

Describe the benefits and limitations of several methods for supporting database disaster recovery
Explain setup for a Standby database at a remote location
Plan for database disaster recovery using remotely mirrored disks
Describe the use of DB2 Replication to recover selected DB2 tables in a remote database

DB2 High Availability Disaster Recovery (HADR)

Describe the benefits and limitations of implementing High Availability Disaster Recovery (HADR)
Implement HADR, including the setup of a Primary and Standby database
Use the commands START HADR, STOP HADR, and TAKEOVER to manage an operational HADR system
Plan for the use of the DB2 Utilities like LOAD, REORG, Backup and Restore in an HADR environment
Select appropriate HADR database configuration options in order to meet the requirements of a specific application environment including the HADR_PEER_WINDOW
Monitor the status of the Primary and Standby database using GET SNAPSHOT FOR DATABASE or db2pd - hadr

DB2 DPF Partitioned Database Recovery Considerations

Explain database recovery facilities in a DB2 DPF partitioned database
Describe the use of the Single System View options for Backup of a partitioned database
Recover a partitioned database using the TO END OF LOGS option of the ROLLFORWARD command
Create an online Backup of a DPF partitioned database that includes all of the required active logs
Implement automated archival of DB2 logs in a DPF partitioned database
Perform dropped table recovery in a DPF partitioned database
Use the REBUILD option of RESTORE to build a partial copy of a DPF Partitioned database
Describe the crash recovery processing performed for a DPF partitioned database
Explain the use of redirected restores and db2relocatedb with DPF partitioned databases
Use db2inidb for split mirror copies with a DPF partitioned databases

Encarta Labs Advantage

One Stop Corporate Training Solution Providers for over 6,000 various courses on a variety of subjects
All courses are delivered by Industry Veterans
Get jumpstarted from newbie to production ready in a matter of few days

Trained more than 50,000 Corporate executives across the Globe
All our trainings are conducted in workshop mode with more focus on hands-on sessions

DB2 for LUW - Advanced Database Recovery

COURSE AGENDA