DB2 Locking & Concurrency in a Data Sharing Environment

Course Code: DZOLC3
Duration: 2 days
Environment: Data Sharing
Audience: System Administrators, Database Administrators and Capacity Planners.
Prerequisites: A working knowledge of data sharing in a z/OS environment.
Summary: The, mainly, locking performance and tuning course begins by recounting:
  • What is a sysplex?
  • What is DB2 data sharing?
Approximately 70-percent of the course focuses on DB2 locking and performance in a data sharing environment. Performance tools such as the following are used:
  • -DISPLAY GROUPBUFFERPOOL
  • -DISPLAY GROUP
  • Statistics reports
  • Accounting reports
  • And the like.
Objectives: Upon completion of this presentation, the participant should be able to understand:
  • The DB2 data sharing environment
  • DB2 locking in a data sharing environment
  • How to use performance tools such as a DB2 PM and -DISPLAY commands to monitor and tune locking in a DB2 data sharing environment.
View full outline in PDF formatDetailed Outline

Course Schedule

Request a date for this course

Book Course

Course Outlines

Detailed course outlines are available in PDF format. Download Adobe's Acrobat Reader free from: www.adobe.com
Get Acrobat Reader

Training Topics

GENERAL

print  |  top of page