Articles & Content


B15 P1 - Understanding and analyzing DB2 for z/OS resource serialization and concurrency control

Topic: DB2 for z/OS

Subtopic: 2015

While Locking and other means of concurrency control are essential to any database management system, they are often the cause of problems in today's production systems.
Applications are not always designed with concurrency in mind, so it is not uncommon that with increased transactions volumes concurrency issues start to surface in your production systems.

Therefore it is important to understand serialization mechanisms used by DB2, how to detect (potential) locking problems, and how to analyze them to find the root cause of the problem even with little or no prior knowledge of the application.

In this session, we discuss:
* Different types of serialization mechanism used by DB2, including locks, latches, claims and drains
* Different types of locking and concurrency problems
* Concurrency warning signs
* How to set up periodic monitoring for concurrency problems

We also describe the different tools you have at your disposal to investigate a concurrency problem in order to discover the root cause of the problem.
Lastly we demonstrate how to perform this type of analysis for a  simple deadlock scenario.

The target audience are application designers, DBAs and system administrators.

Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.