Monday, August 31, 2015

DB2 for z/OS: Which Buffer Pools Should You Page-Fix?

›
A few days ago, I delivered a presentation on DB2 for z/OS performance monitoring and tuning for the DBA team at a large financial instituti...
2 comments:
Wednesday, August 12, 2015

What Does a DB2 for z/OS System Look Like When You Have Memory to Burn?

›
I've long been an advocate of Big Memory (meaning, lots of real storage) for DB2 for z/OS systems. For years, I was disappointed at seei...
Friday, July 31, 2015

DB2 for z/OS Group Buffer Pools: ALLOWAUTOALT, Directory Entries, and GBP Size

›
So, I've seen something interesting lately in reviewing some DB2 for z/OS data sharing systems, and as is often the case in such situati...
7 comments:
Thursday, July 9, 2015

How Will You Use DB2 for z/OS Global Variables?

›
About seven years ago, in an entry posted to the blog I maintained while working as an independent DB2 consultant (prior to rejoining IBM),...
5 comments:
Thursday, June 18, 2015

Are You Using DB2 for z/OS Real-Time Statistics? DB2 Is

›
DB2 for z/OS is making increased use of the information that it keeps in the real-time statistics tables in the DB2 catalog. You should be d...
25 comments:
Thursday, May 28, 2015

DB2 11 for z/OS: Setting Aside Space for Updates

›
A DB2 table space is well-organized when rows are physically located where they should be per the clustering index of the associated table. ...
4 comments:
Wednesday, May 13, 2015

For a Large DB2 for z/OS Table, Should You Go With Partition-by-Range or Partition-by-Growth?

›
There are several aspects to this question: What do I mean by "large?" Is the table in question new, or does it exist already? Wha...
11 comments: