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
SQL & SQL PL Enhancements in Db2 12 and 13 — Technical Insights from the Virtual Mainframe User Group with Chris Crone
In this session of the Mainframe Virtual User Groups, Broadcom Distinguished Engineer Chris Crone provided a practical walkthrough of SQL and SQL PL enhancements across Db2 12 and Db2 13. Drawing on 35 years of experience working in Db2 internals, including SQL...
With Geniez, You Can Talk to Your Mainframe in Natural Language
How Geniez Is Turning Real-Time Mainframe Data Into Fuel for Modern LLMs Amanda Hendley, Managing Editor of Planet Mainframe, met with Gil Peleg, CEO of Geniez, for a conversation about artificial intelligence (AI)—specifically, the future of AI on the mainframe.Read...
Mainframe Data on the Move: A Security-Centric Perspective, featuring Colin Knight
At the September Virtual Db2 User Group, we hosted Colin Knight, longtime mainframer and Db2 Systems Programming Tech Lead at NatWest. With over 40 years in the field—36 of them working with Db2—Colin cut through the hype to focus on what matters most: security when...
Virtual Db2 Recap – From Root to Leaf-Managing Index Splits in Db2
Demystifying Page Splitting in Db2: Insights from Saurabh Pandey In a recent technical session, Saurabh Pandey, Lead Product Manager at BMC Software, walked attendees through the often-overlooked but critical topic of Db2 index management—with a spotlight on page...
0 Comments