Verhoef Training USA

Training Courses and On-Line Classes Preferred By IT Pros

Visit us at:   http://www.verhoef-training.com

103 Hillside Ave., PO Box 1515
West Caldwell, NJ 07006
Main Office:  800.631.0410
Sales Office:  800.533.3893

DB2 Application Data Recovery

Course:   DB2DR
Duration:   3 Days
Level:   I
On our website at:   http://www.verhoef-training.com/courses/DB2DR.html
 
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.

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.
  • DSN1COPY.
  • Recover Logonly.

Recovery after Drop

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

Third Party Utilities

  • Using third party utilities.
  • General differences.
  • BMC Copy Plus and Recover Plus.
Related Courses
Code Course Title Duration Level
DB2A
DB2 for z/OS Administration
5 Days
I
Details
DB2DSI
DB2 Data Sharing Implementation
3 Days
I
Details
DB2UDBI
DB2 for LUW (Linux, UNIX, Windows)
2 Days
I
Details
DB2M
Advanced DB2 Application Programming
3 Days
II
Details
DB2M9
DB2 UDB/390 Version 9 Transition
2 Days
II
Details

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.