DB2 UDB for OS/390 System/Disaster Recovery Workshop

start > courses and registration > training feature sheet

code.

CF910

length.

4 days

type.

Instructor-Led

partner.

IBM

price.

$2,500

IACET credits 3.2

Learn how to design and implement recovery and restart procedures for DB2 UDB for z/OS and OS/390. Emphasize the three most difficult recovery emergencies: conditional restart, broken catalog/directory, and off-site recovery. Design and set up procedures for database recovery (point-in-time or application point of consistency), and catalog/directory or database broken data recovery. More than half of the course is devoted to hands-on labs and lab reviews.

Washington, DC	aug.18.2008 - aug.21.2008	register

who can benefit

This is an advanced course for senior system administrators, senior database administrators, and senior technical system professional individuals, who plan, implement, and maintain DB2 UDB for z/OS and OS/390, Version 7.

prerequisites

You should complete:

? DB2 UDB for z/OS and OS/390 Database Administration Workshop - Part 1 (CF830)
? DB2 UDB for z/OS and OS/390 System Administration (CF850)
? OR have equivalent experience

You should be able to use:

? Recovery-related utilities
? Basic database recovery procedures
? Normal restart and termination procedures

skills gained

	Implement database recovery procedures that maximize availability
	Use DSN1LOGP and Print Log Map reports to diagnose system problems
	Implement procedures for establishing and recovering to application and system-wide points of consistency
	Design procedures for off-site recovery and conditional restart
	Develop procedures for diagnosing and recovering broken data, including catalog and directory data
	Design procedures for resolving indoubt units of recovery

course materials

The course materials cover DB2 UDB for z/OS and OS/390, Version 7 with topics pertaining to DB2 system recovery/restart.

hands-on labs

Thirteen labs are included to help the student to master skills in changing active log sizes, using Conditional Restart Control Record (CRCR) recoveries, consistent restarts, resolving Logical Page Lists (LPL), critical log read errors, missing checkpoint entries, unequal time stamps in Boot Strap Data Sets (BSDS), down-level detections, and dilemmas with a DB2 cold start.

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

related courses, exams and materials

	other related training and products

CF881 DB2 for OS/390 System Performance and Tuning

	before related training and products

	CF830 DB2 UDB for z/OS and OS/390 V7 Database Administration Workshop - Part 1
	CF850 DB2 UDB for z/OS and OS/390 System Administration

	after related training and products

CI240 CICS DB2 Interface for System Programmers

course content details

	Backup/recovery

	explain the use of DB2 utilities used in database backup/recovery
	explain the use of DB2 catalog/directories used in database backup/recovery
	design procedures for doing database backup/recovery
	explain how to resolve page-set exceptions
	explain application point of consistency

	Logs and BSDS

	describe the DB2 recovery logging process
	understand the offloading process
	analyze the contents of DB2's BSDS, active and archive logs
	list functions of DB2 log-related utilities

	Three labs: hands-on laboratory exercise topics:

	rebuild a DB2 environment from a disaster recovery situation
	enlarge a DB2 catalog page-set
	change a DB2 active log size

	Termination/restart

	explain the process done by DB2 during startup and shutdown
	implement procedures to avoid DB2 startup and shutdown problems

	Indoubt unit of recovery - manual resolution

	explain DB2's use of logging to support a two-phase commit
	explain how to locate log records in Information Management System (IMS), CICS, and DB2 that are of the same unit of work
	develop procedures for indoubt Unit of Recovery (UR) resolution

	Conditional restart

	explain how to perform a DB2 conditional restart
	explain how to do DSN1LOGP summary analysis

	Four labs: hands-on laboratory exercise topics:

	make use of a CRCR with BACKOUT=NO
	restart DB2 with a consistent restart
	restart DB2 with a consistent restart with Data Definition Language (DDL) back out
	resolve a DB2 LPL situation

	Broken user data

	describe the format of user page sets
	list the health check utilities for problem resolution with user page sets
	identify problems with user page sets
	resolve problems with user page sets

	Broken system data

	describe the utilities used with DB2 system data
	understand contents in DB2 system data
	describe the Database Definitions (DBD) (database descriptor records)

	Four labs: hands-on laboratory exercise topics:

	resolve a DB2 critical log read error
	resolve a DB2 critical log read error with DDL
	resolve a DB2 missing checkpoint entry
	resolve a DB2 unequal time stamp error in BSDS

	Down-level detection

	explain DB2 down-level page sets
	explain how DB2 detects down-level page sets
	explain how to recover from down-level page sets

	System Point of Consistency (POC) recovery

	establish a system-wide POC
	recover to a system-side POC
	choose correct alternative for a system-wide POC

	Off-site recovery

	discuss the procedures for a DB2 off-site recovery
	discuss the recover process using the procedure established at the off-site recovery

	Two labs: hands-on laboratory exercise topics:

	resolve a DB2 down-level detection problem
	complete a DB2 cold start and recognize the problems