As Db2 DBAs we often find ourselves chasing two elusive targets: speed and capacity. We want our systems to handle everything all at once, a...

In the complex ecosystem of enterprise mainframes and hybrid cloud environments, performance tuning often feels like chasing ghosts in the m...

Ensuring efficient data access while maintaining data integrity is critical to both performance and stability. One of the mechanisms Db2 emp...

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