1 to 7 of 7
Sort by

Blog Entry
The Key To Mastering Db2 Locking On Row-Store Tables

by: Zoltan Toth, IBM and Michael Feng, IBM A database lock is a mechanism utilized by Db2 to govern the access to a database object amongst different transactions. The following is a list of objects that Db2 usually regulates via the usage of locks: - Table - Table partition -...

Zoltan Toth's profile image

Blog Entry
Lessons Learned of Locking and Latches by Adrian Burke

Lessons Learned of Locking and Latches Locking and latching are both key mechanisms employed by relational database management systems to ensure data integrity, consistency, and the proper serialization of resources. In the Db2 for z/OS world, IRLM manages the locks, but...

Adrian Burke's profile image

Blog Entry
Db2 for z/OS locking basics

With this month’s topic being “locking, concurrency and waits”, it may not be a bad time to review some of the locking basics. It might help your junior colleagues or your developers to get a better understanding. Hopefully after this article you won’t have to explain any more that “yes a reader...

Kurt Struyf's profile image

Blog Entry
A Beginners Guide to Locks, Latches, Claims and Drains in DB2 for z/OS by Steve Thomas

Steve Thomas of CA Technologies presents a great introduction into the world of locks, latches, claims and drains. A must see for all developers working wit Db2 for z/OS as well as all DBAs wanting to refresh their knowledge. This session will provide an introduction to how data integrity is...

Steve Thomas's profile image

Blog Entry
How to deadlock yourself in three simple steps

Some time ago I had a discussion with a DBA who guided the developers to use a singleton SELECT instead of fetching from a cursor in cases where just a single row would be selected. Singleton SELECT is a select statement that returns a single row at most. Even though I did not know any further...

Emil Kotrc's profile image

Blog Entry
Using Stored Procedures to Lock Application Objects

We live in a massively multithreaded world. Lots of actions are occurring around us. We are jumping from one task to another. Every now and then, we have to slow down and stop what we are doing to let another task make its way in the stream of activities. That task isn’t necessarily ours. In...

John Maenpaa's profile image

Library Entry
[A13] Analyzing DB2 for z/OS resource serialization and concurrency problems

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...