Training Course: DB2 UDB Advanced Recovery for Single Partition Databases

Training Course Summary:

This course is designed to gain a deeper understanding of the advanced recovery features of DB2 Universal Database (UDB) for UNIX, Windows, and Linux environments with single partition databases.

Pre-Requisites:

You should complete:
DB2 UDB Administration Workshop for UNIX (CF21N7GB) or
DB2 UDB Administration Workshop for Windows (CF23N7GB) or
Fast Path to DB2 UDB for Experienced Relational DBA's (CF28N4GB) or
DB2 UDB Multi Partition DBA Workshop (CF24N5GB)



DB2 UDB Administration Workshop for UNIX (CF21N7GB)
DB2 UDB Administration Workshop for Windows (CF23N7GB)
Fast Path to DB2 UDB for Experienced Relational DBA's (CF28N4GB)
DB2 UDB Multi Partition DBA Workshop (CF24N5GB)

Who Should Attend:

DB2 UDB experienced database administrators who plan and implement recovery and high availability for DB2 UDB for UNIX, Windows, and Linux single partition databases. The lab exercises for a single partition database will be run on Windows operating system.

Training Course Overview/Content:

After completing this course, you should be able to:
o Gain a better understanding of the unique recovery planning requirements
for DB2 UDB Enterprise Server Edition single partition databases
o Explore the DB2 UDB recovery facilities and database configuration options
o Plan the implementation of a user exit for archival of database logs
o Recover a DB2 table following a DROP TABLE command issued in error
o Plan and execute the recovery of table spaces to a selected point-in-time
o Effectively utilize incremental backup and restore to reduce the size and
duration of DB2 database backups
o Gain a better understanding of DB2 UDB crash recovery facilities
o Utilize the redirected restore option to recover DB2 data to alternate
disk configurations
o Use the db2relocatedb utility to reconfigure a DB2 database
o Execute recovery scenarios, including loss of DB2 log data
o Utilize the information in the DB2 recovery history file to plan and
execute various DB2 utilities
o Explore the options for operation of DB2 databases in high availability
environments including the use of split mirrors of the database
o Select an appropriate method for supporting Disaster Recovery of a DB2 UDB
database to another location