DB2 Application Data Recovery

Course:  DB2DR
Duration:  3 Days
Level:  I
Course Summary

The course provides detailed coverage of DB2 for z/OS

Application Data Recovery. It is intended for application DBAs and designers and anyone else who needs to understand DB2 data recovery. A general knowledge of DB2 is a prerequisite. The course includes practical exercises.

« Hide The Details
Topics Covered In This Course

DB2 Objects

  • Tables.
  • Storage Groups & Databases.
  • Tablespaces.
  • Indexes.
  • Free Space.
  • Referential Integrity.
  • The Catalog and Directory.

Physical Database Organisation

  • Tablespace Layout and Index Structure.

Recovery Overview

  • Backup & Recovery.
  • The Unit of Recovery.
  • Logging.
  • DB2 Buffer Pool.
  • Commit Processing.
  • Forward Recovery and Rollback.
  • Locking.

DB2 Utilities

  • Standard Recovery Utilities.
  • Utilities that Impact Recovery.
  • Stand Alone Utilities.
  • Invoking Utilities.

Standard Backup and Recovery

  • Image Copy.
  • Recovery.
  • Index Recovery.
  • Mergecopy.
  • Report Recovery.
  • Modify.
  • Concurrent Copy.
  • Inline Image Copies.

Recovery Data

  • Image Copies.
  • Logs & BSDS.
  • Log Records.
  • Catalog & Directory.

Data Object States

  • Display Database Command.
  • Possible Statuses.
  • Changing States.
  • Resetting States set by DB2.
  • Check Data, Check LOB, Check Index.
  • Repair.
  • Error Range and LPL.

Recovery to a Prior Point in Time

  • Point of Consistency.
  • Quiesce.
  • Report Tablespaceset.
  • Recovery to POC.
  • Recover Tocopy.
  • Recover Logonly.

Recovery after Drop

  • Problems caused by Drop.
  • Recovering the data.
  • Finding the Object Ids.

Third Party Utilities

  • Using third party utilities.
  • General differences.
  • BMC Copy Plus and Recover Plus.
« 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
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]