Over the past year or so, I’ve seen more and more situations in which a too-small Db2 for z/OS log output buffer is negatively impacting system and application performance. The Db2 development team took aggressive action to remedy that situation via a change to the default value of OUTBUFF (the relevant ZPARM parameter) with Db2 13, but if you are not yet on Db2 13 you should make this change yourself in your Db2 12 environment (and, if you are on Db2 13, you should definitely be using the new OUTBUFF default, or an even higher value). In this blog entry I’ll provide information that I hope will make all of this clear and meaningful for you.
OUTBUFF: A Db2 for z/OS ZPARM You Really Ought to Check
Robert Catterall is a Senior Consulting Db2 for z/OS Specialist with IBM. He has worked in IT for 37 years, and has worked with Db2 for z/OS - as an IBMer, an independent consultant, and a user - since 1987.
Sign up to receive the latest mainframe information
Read More
Db2 Month at Planet Mainframe: Resilience, Innovation, and a Thriving Community
June was a standout month for Planet Mainframe, as we turned the spotlight on Db2 for z/OS—a cornerstone technology of the enterprise world. This month’s campaign featured expert articles, technical deep-dives, trivia, and live events that brought together voices from...
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...
Inside Db2 for z/OS: How Optimized B+ Trees Power High-Speed Indexing
High-quality indexes are critical for fast data access and returns. IBM Db2 for z/OS relies on an advanced data structure called the Optimized Balanced Plus Tree to power high-speed indexing. This structure, an evolution of the classic B+ Tree, helps Db2 deliver...
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...
0 Comments