Friday, April 26, 2019

Db2 12 for z/OS Statistics Profiles: Just What the Optimizer Ordered

›
Here is an interesting story for you: not long ago, an analytics-type query was executed on a Db2 for z/OS system that had recently been mig...
4 comments:
Sunday, March 31, 2019

A Case Study: Implementing a Db2 for z/OS Implicit Trusted Connection

›
I've been interested in the role and trusted context features of Db2 for z/OS for a long time (I posted a two-part blog entry on the top...
4 comments:
Monday, February 25, 2019

Db2 for z/OS: Isolating REST Client Activity in Db2 Monitor Accounting Reports

›
In an entry posted to this blog some years ago , I described the form of a Db2 monitor-generated accounting report that I most like to use t...
Friday, January 4, 2019

A Case Study: Measuring the Impact of Db2 for z/OS Buffer Pool Changes

›
Not long ago, a Db2 for z/OS administrator contacted me with a request. His team had made some changes to the buffer pool configuration in t...
4 comments:
Friday, December 28, 2018

Db2 for z/OS Partitioned Table Spaces: How the Number of Partitions can Impact Performance

›
This past summer, I delivered a couple of presentations at a meeting of a regional Db2 users group in the USA. During the lunch break, I sha...
9 comments:
Friday, November 30, 2018

Db2 for z/OS Global Variables: What is a "Session"?

›
Has this ever happened to you? You're looking at the Db2 for z/OS SQL Reference  (or in the Db2 for z/OS Knowledge Center on the Web), ...
7 comments:
Wednesday, October 31, 2018

Db2 for z/OS Buffer Pools: Clearing the Air Regarding PREFETCH DISABLED - NO READ ENGINE

›
Has this ever happened to you? You're looking at the output of a Db2 for z/OS -DISPLAY BUFFERPOOL(ACTIVE) DETAIL command, or maybe at a ...