Thursday, May 25, 2023

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

›
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...
Friday, April 28, 2023

Migrating to Db2 13 for z/OS When You Have Old (pre-11.1) Db2 Client Code on Your App Servers

›
Not long ago, I had a talk with a Db2 for z/OS systems programmer who works at a pretty big site. In a somewhat dramatized form, our convers...
Thursday, March 30, 2023

Db2 for z/OS: If Index FTB Functionality is Disabled at Your Site, It's Time to Reconsider That

›
Over the course of the past three weeks, I reviewed ZPARM settings (i.e., configuration parameter values) for three different production Db2...
3 comments:
Thursday, February 23, 2023

Two RMF (z/OS Monitor) Reports with which Db2 for z/OS People Should be Familiar

›
When it comes to analyzing the performance of a Db2 for z/OS system and associated applications, I think of a set of concentric circles. The...
8 comments:
Friday, January 20, 2023

Db2 for z/OS: What is "Wait for Other Read" Time, and What Can You Do About It?

›
A recent conversation I had with some folks who support a large Db2 for z/OS system reminded me of the importance of something called "...
2 comments:
Wednesday, December 21, 2022

Db2 13 for z/OS: Setting Lock Timeout Limit and Deadlock Priority at the Application Level

›
Db2 13 for z/OS, which became generally available about seven months ago, introduced two interesting features that are similar in some ways ...
6 comments:
Friday, November 11, 2022

A Case Study: Using Db2 for z/OS Monitor Reports to Zero In on a Performance Problem

›
I had an interesting exchange recently with a Db2 for z/OS systems programmer. This individual had been asked to assist in determining the c...
15 comments: