DB2 UDB for z/OS System/Disaster Recovery Workshop

M/UX
Atlanta, Chicago, Santa Clara, United States

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

Course Description:

'' 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.

Course Materials

The course materials cover DB2 UDB for z/OS, Version 8 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. Also, included in the lab document are appendices showing the new SYSTEM BACKUP/RESTORE function in DB2 V8 and how to install, execute, and restore DB2 using this new database recovery function.

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 8.


Skills Taught

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

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
Implement procedures for establishing and recovering DB2 V8 using SYSTEM BACKUP/RESTORE


Course outline

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

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
Instructor demonstration showing SYSTEM BACKUP/RESTORE

SYSTEM BACKUP Full only option implemented and displayed
SYSTEM RESTORE executed backing out a database create

...''

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: Atlanta, Chicago, Santa Clara
Houses & Roommates: Atlanta, Chicago, Santa Clara

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 9 for LUW Advanced Database Recovery
DB2 Stored Procedures Programming Workshop
DB2 UDB Application Programming 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
Backup and Recovery Media Services/400 Workshop
System i Performance Analysis Workshop
IBM WebSphere Application Server V6.0 Administration on System i

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.