It can be potentially troublesome when DB2 lock promotion and escalation occur. These situations can greatly reduce the availability of conc...

Data sharing adds an additional level of complexity to the DB2 locking strategies and techniques we have been discussing in this series. Bec...

DB2 provides a way to change the way that a program or SQL statement acquires locks. That way is known as the isolation level and it can be...

Unless you plan for, and issue regular COMMITs in your DB2 application programs, you will be causing locking problems. It is important for e...

When a row is read or modified in a table containing LOB columns, the application will obtain a normal transaction lock on the base table. T...