DB2 UDB Advanced Recovery for Single Partition Databases

start > courses and registration > training feature sheet

This course has been upgraded to:

»	CF492 DB2 9 for LUW Advanced Database Recovery

This course is no longer publicly scheduled and displayed for reference purposes only. To find more information about this course expiry or request this archived course, send us an email.

DB2 UDB Advanced Recovery for Single Partition Databases

course schedule			who can benefit
prerequisites			skills gained
other notes			course content
related solutions

code.

CF491

length.

4 days

type.

Instructor-Led

partner.

IBM

price.

$2,500

IACET credits 3.2

Gain a deeper understanding of the advanced recovery features of DB2 UDB for Linux, UNIX, and Windows environments. Get practical experience in the planning and utilization of a wide variety of DB2 UDB recovery facilities in a series of database recovery scenarios you complete during lab exercises DB2 UDB Enterprise Server Edition Version 8 for a single partition database.

Note: If you support multiple partition DB2 UDB databases you should plan on attending:

DB2 UDB Advanced Recovery for Multiple Partition Databases (CF49E)

There are currently no scheduled dates for this course. If you are interested in this course, request a course date with the links below.

who can benefit

This is an advanced course for experienced database administrators and technical individuals, who plan, implement, and maintain recovery and high availability for DB2 UDB for UNIX, Windows, and Linux single partition databases.

prerequisites

You should complete:

	DB2 Universal Database Administration Workshop for Linux (CF201) or
	DB2 Universal Database Administration Workshop for UNIX (CF211) or
	DB2 Universal Database Administration Workshop for Windows NT (CF231) or
	DB2 UDB Administration Workshop for Sun Solaris (CF271) or
	Fast Path to DB2 UDB for Experienced Relational DBAs (CF281) or
	DB2 UDB Advanced Administration for Experienced Relational DBAs (CF482)
	OR have equivalent experience

skills gained

	Gain a better understanding of the unique recovery planning requirements for DB2 UDB ESE Version 8 single partition databases
	Explore the DB2 UDB recovery facilities and database configuration options
	Plan the implementation of a user exit for archival of database logs
	Recover a DB2 table following a DROP TABLE command issued in error
	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 UDB crash recovery facilities
	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
	Implement the DB2 UDB Utility Throttle to limit the performance impact of online backups on production workloads
	Utilize the information in the DB2 recovery history file to plan and execute various DB2 utilities
	Understand the benefits and limitations of disaster recovery options for DB2 UDB databases
	Explore the options for operation of DB2 databases in high availability environments including the use of split mirrors of the database

course materials

The course materials cover DB2 UDB Version 8.1 for Linux, UNIX, and Windows.

hands-on labs

Eleven labs are included to address using DB2 UDB Version 8.1 for Linux, UNIX, and Windows.

certification

Prepare for IBM Certification Test 704: DB2 UDB V8.1 for Linux, UNIX and Windows Advanced Database Administration.

ibm education advantage program eligibility:

	Yes - IBM Education Card
	Yes - IBM Education Pack
	Yes - IBM Corporate Education Pass
	Yes - IBM Education Pack - online account

skill level

Advanced

course content details

	DB2 UDB database recovery review

	state the three types of recovery support
	explain the principles DB2 uses for its recovery/restart
	describe the capabilities and functional requirements of DB2 logging
	configure the DB2 database parameters that support recovery

	DB2 UDB recovery log management

	configure the DB2 database parameters that support the DB2 logs
	implement a DB2 UDB USEREXIT program to enable archival and retrieval of DB2 logs
	describe the utilization and considerations for DB2 logs on a raw device
	understand the options provided by DB2 UDB to reduce log volume

	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

	Table space recovery

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

	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 db2diag.log messages to track the processing of an Incremental backup or restore process

	DB2 UDB 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 UDB database options, parallel recovery to support crash recovery for various applications
	describe the impact of a database crash and restart for DB2 Utilities like LOAD, REORG and IMPORT

	Redirected restore

	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
	plan the use of redirected restore as part of a disaster recovery
	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 files
	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 theUTIL_IMPACT_LIM database manager configuration option

	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
	utilize the Graphical User Interface (GUI) journal application to view the information contained in the recovery history file
	use the PRUNE HISTORY command to remove outdated information in the recovery history
	restore a damaged recovery history file

	DB2 UDB database disaster recovery

	describe the benefits and limitations of various methods for database disaster recovery
	explain use of 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 UDB database high availability

	describe various techniques for supporting high availability of DB2 UDB databases
	explain the concepts involved when implementing the automated failover of a DB2 database
	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
	describe the considerations for disk media failures for DB2 UDB databases