If I had to identify a single most overlooked Db2 performance metric, it would be GETPAGEs . Many organizations focus on CPU utilization, ...

One of the primary goals of Db2 for z/OS locking is to maximize concurrency while maintaining data integrity. In a perfect world, every appl...

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

It is important to review SQL statements during testing... certainly before they get to production! A good SQL review workflow shouldn’t fee...