On-site & Public, Instructor-led, Hands-on IT Training
(International 01) 908.233.8900
  400+ Course Offerings:

Search for Course:

DB3041 DB2 for z/OS Data Sharing Operations and Recovery Restart
Duration2 Days
Delivery MethodInstructor Led, Hands-on Workshops
Public Price$1200.00

DESCRIPTION (Return to Top)

As DB2 data sharing is introduced in your environment, you must review many of the procedures you currently have for managing DB2. The many operational, recovery, and disaster recovery issues that data sharing introduces may force you to change the way you currently manage DB2.

This workshop will help you understand the overall operational implications, how recovery works in a data sharing environment and the procedures you should have in place to recover from errors or unexpected conditions.

AUDIENCE (Return to Top)

This course is intended for DB2 Systems Administrators, DBAs and systems support personnel who are responsible for the day to day operations and the implementing of recovery procedures for a DB2 for z/OS data sharing installation.

OBJECTIVES (Return to Top)

Upon completing this course, students should be able to:

  • Describe the DB2 operational considerations for a data sharing group.
  • Describe how DB2 recovery and restart processes are different in a data sharing environment versus a standalone DB2 environment
  • Describe the architecture of DB2 data sharing groups and the recovery and restart considerations associated with system components that enable data sharing on a parallel sysplex
  • Describe how coupling facility structures are allocated and recovered
  • Describe the DB2 group restart process
  • Describe how disaster recovery processes should be updated to account for the presence of a DB2 data sharing system in the environment

TOPICS (Return to Top)
  • DB2 Data Sharing Overview
  • Normal DB2 Operations
  • Database Recovery Environment
  • DB2 Restart
  • Data Sharing non-Sysplex Failures
  • Data Sharing Sysplex Failures
  • Disaster Backup and Recovery


Students should be thoroughly familiar with the DB2 for z/OS mainframe environment, ideally with production experience with DB2 for z/OS.