Did you know that Db2 provides a method to change the way a program or SQL statement acquires locks? That way is known as the isolation leve...

This month, June 2020, IBM introduced a new function level, FL507 , for Db2 12 for z/OS. This is the first new function level this year, and...

Let's talk about dirty reads (with apologies to the AC/DC pun in the title of this blog post). Application programmers must ...

T oday I am introducing a new series of blog posts here on misunderstood DB2 features and functions. But before I start this blog post I ...

There seems to be a LOT of confusion out there in DB2-land about the CURRENTDATA parameter, so I thought it might be helpful to blog about ...

This week I attended the NoSQL Now Conference in San Jose, California. This conference focused on NoSQL technology and implementations and a...

Today's blog post concludes our multi-part series on DB2 for z/OS locking and concurrency. We have touched on a great many aspects of lo...

DB2 10 for z/OS introduces a new technique for concurrency. As we have discussed previously in this series on DB2 locking, one of the most ...

Many shops battle with locking issues and frequently, the cause of performance issues can be traced back to locking issues, more specifical...

We continue the series on DB2 locking today with a look at the SQL statement: LOCK TABLE . You can issue the LOCK TABLE statement in your ...