OUTBUFF: A Db2 for z/OS ZPARM You Really Ought to Check

Jun 19, 2023

DB2

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.

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.

Continue Reading at Robert’s Db2 Blog.

0 Comments

Sign up to receive the latest mainframe information

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

Read More

All I Want for Christmas is an IBM Db2 Analytics Accelerator

All I Want for Christmas is an IBM Db2 Analytics Accelerator

It’s always the right time to talk about my absolute favorite mainframe technology, the IBM Db2 Analytics Accelerator (we users like to call it IDAA). As you finalize your wish list for your CFO or Santa, don’t forget this!What’s Not in a Name If you’ve ever heard me...