Consider Application-Level Lock Control in Db2 13 for z/OS

Apr 26, 2023

DB2

Regular Planet Mainframe Blog Contributor Craig Mullins is President & Principal Consultant of Mullins Consulting, Inc., and the publisher/editor of The Database Site. Craig also writes for many popular IT and database journals and web sites, and is a frequent speaker on database issues at IT conferences. He has been named by IBM as a Gold Consultant and an Information Champion. He was recently named one of the Top 200 Thought Leaders in Big Data & Analytics by AnalyticsWeek magazine.

It has been close to a year since Db2 13 for z/OS has been generally available. It was announced in April 2022 and delivered for GA on May 31, 2022.

As you think about migrating from Db2 12 to Db2 13, it is inevitable that you will consider the new functionality and capabilities that comes with the new version. I’ve discussed the AI functionality of SQL Data Insights delivered in Db2 13, but haven’t really dug into some of the other interested new features.

Today, I want to briefly discuss application-level lock control. This new feature enables applications to take more control over Db2 locking. If you have applications that could benefit from different lock parameters than the system-wide settings used by Db2, then this new capability could be useful for at least some of your applications and tasks.

Continue reading on the Db2 Portal Blog.

Db2 Workload Performance on Fire

0 Comments

Sign up to receive the latest mainframe information

This field is for validation purposes and should be left unchanged.

Read More

Learning from SMF: Managing Db2 Buffer Pools

Learning from SMF: Managing Db2 Buffer Pools

Unlocking the Value of Cheryl Watson’s Tuning Letter Back Catalog If you work with IBM mainframes, you’ve probably heard of Cheryl Watson’s Tuning Letter, which I now have the pleasure of editing. For decades, it’s been one of the most trusted resources for...

Streamlining Your Db2 13 Migration: 7 Steps to Get Ahead

Streamlining Your Db2 13 Migration: 7 Steps to Get Ahead

Adapted and summarized by ChatGPT. Download Paul’s full article. Migrating to a new version of a critical platform like Db2 for z/OS might sound daunting, but with the right strategy, it can be manageable and an opportunity to improve operational efficiency. Db2 13 is...