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 ...
Friday, September 21, 2018

The Two Paths to the Db2 for z/OS Distributed Data Facility

›
It's been almost two years since the general availability date of Db2 12 for z/OS and, by way of that new version, the availability of D...
2 comments:
Wednesday, August 29, 2018

How Big is Big? (2018 Update - Db2 for z/OS Buffer Pools and DDF Activity)

›
Almost 5 years ago, I posted to this blog an entry on the question, "How big is big?" in a Db2 for z/OS context. Two areas that I...
Friday, July 27, 2018

Db2 for z/OS: Using the Profile Tables to Direct DDF Applications to Particular Package Collections

›
I've posted several entries to this blog on the topic of high-performance DBATs (for example, one from a few years ago covered a MAXDBA...
4 comments:
Tuesday, June 26, 2018

Db2 for z/OS PBG Table Spaces: The Ins and Outs of Partition Addition

›
In an entry posted to this blog about three years ago, I advocated for putting some thought into the PBG versus PBR decision (partition-by-...
18 comments: