Search

1 to 6 of 6
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
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

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

EU13A13.pdf


Library Entry
[A16] How to design For High Volume Concurrent Insert

This session to introduce and discuss the most common use cases for high volume concurrent insert, share the associated IBM benchmark results, and provide recommended best practice in term of physical database design and tuning advice.The uses cases are: random insert and delete, insert at the...

EU13A16.pdf