DB2 System Recovery and Restart

Course:  DB2SR
Duration:  2 Days
Level:  I
Course Summary

The course provides detailed coverage of DB2 UDB for z/OS and OS/390 System Recovery and Restart. It is intended for DBAs, systems programmers and anyone responsible for system-wide recovery. Students should have attended the Application Data Recovery course or have a similar level of knowledge before attending this course. The course includes practical demonstrations.

« Hide The Details
Topics Covered In This Course

Application Data Recovery

  • Overview.
  • Image Copy.
  • Recovery.
  • Index Recovery.
  • Report Recovery.
  • Modify.
  • Point of Consistency.
  • Quiesce.
  • Report Tablespaceset.
  • Recovery to POC.
  • Recover Tocopy.
  • Recover Logonly.
  • Data Object States.

Catalog & Directory Recovery

  • Catalog & Directory Backup.
  • Catalog & Directory Recovery.
  • Work Database Recovery.
  • Catalog and Directory Structures.

Subsystem Shutdown & Restart

  • Normal Shutdown.
  • Fast Controlled Shutdown.
  • Uncontrolled Shutdown.
  • Slow Shutdown.
  • Restart Processing.
  • Log Initialization Phase.
  • Current Status Rebuild Phase.
  • Two Phase Commit.
  • Forward Log Recovery Phase.
  • Backward Log Recovery Phase.
  • Resolving In-Doubt URs.
  • Deferred Restart.

Log and BSDS Failures

  • Active Log Errors.
  • Archive Log Errors.
  • BSDS Failures.
  • Print Log Map Utility.
  • Change Log Inventory Utility.
  • Log Failures on Restart.
  • Conditional Restart.
  • Severe Log Errors on Restart.

Disaster Recovery

  • Objectives.
  • System Wide POC.
  • Volume Dump POC.
  • DB2 POC.
  • Copying Archive Logs
  • Recovery to Last Log.
  • Utilities In Flight.
  • DB2 and CICS Synchronisation.
  • DB2 and IMS Synchronisation.
  • Fallback Options.
  • Tracker Site.

Data Sharing Recovery

  • Application Data Recovery.
  • CF Structure Failures.
  • Group Restart.
  • DB2 Member Failure.
  • Disaster Recovery.
« Hide The Details
Related Courses
Code Course Title Duration Level
DB2 for z/OS Administration
5 Days
DB2 Data Sharing Implementation
3 Days
DB2 for LUW (Linux, UNIX, Windows)
2 Days
DB2 Application Data Recovery
3 Days
Advanced DB2 Application Programming
3 Days
DB2 UDB/390 Version 9 Transition
2 Days

Every student attending a Verhoef Training class will receive a certificate good for $100 toward their next public class taken within a year.

You can also buy "Verhoef Vouchers" to get a discounted rate for a single student in any of our public or web-based classes. Contact your account manager or our sales office for details.

Schedule For This Course
There are currently no public sessions scheduled for this course. We can schedule a private class for your organization just a couple of weeks from now. Or we can let you know the next time we do schedule a public session.
Notify me the next time this course is confirmed!
Can't find the course you want?
Call us at 800.533.3893, or
email us at [email protected]