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 Through the Decades
For more than four decades, Db2 has been a cornerstone of enterprise data management—but its roots stretch back even further, to IBM research in the 1970s and the early development of the relational database model and SQL. Along the way, Db2 evolved from a new...
10 Ways to Take Control of Db2 Access Path Performance
Virtual Db2 User Group Recap | Presented by Denis Tronin, Broadcom When it comes to Db2 for z/OS performance, a well-written SQL statement is only part of the equation. The access path selected by the Db2 optimizer determines how the database retrieves data, which...
CICS. Db2. IPL. The Latest Cheryl Watson’s Tuning Letter
The Latest Tuning Letter issue is out now! Subscribers to Cheryl Watson’s Tuning Letter will find the newest issue, 2026 No.1, on our Tuning Letter website. If you are not a current subscriber yet, sign up today! This subscription-only resource is available to both...
Mainframe Careers Rarely Follow a Script – featuring Chris Muncan
Mainframe careers rarely follow a script. Rather, they grow through curiosity, mentorship, and a willingness to keep learning. This trifecta is especially necessary as tools, platforms, and expectations evolve. Planet Mainframe caught up with Chris Muncan, Lead DB2...
0 Comments