Friday, December 30, 2016

In Praise of the Invisible DB2 for z/OS System

›
I've been working with DB2 for z/OS -- as an IBMer, as a user, as an independent consultant -- for 30 years. I was with IBM when DB2 was...
Sunday, November 27, 2016

DB2 for z/OS ZPARMs that Organizations Consistently Set in a Sub-Optimal Fashion

›
Over the past several years, I have reviewed DB2 for z/OS systems running at quite a few client sites. Part of the analysis work I do in per...
8 comments:
Monday, October 31, 2016

How Should Your Network-Attached Applications Access DB2 for z/OS?

›
Some relatively recent developments have plenty of people asking, "How should my applications that connect to a z/OS server via a netwo...
1 comment:
Friday, September 23, 2016

DB2 for z/OS: Using PGFIX(YES) Buffer Pools? Don't Forget About Large Page Frames

›
Not long ago, I was reviewing an organization's production DB2 for z/OS environment, and I saw something I very much like to see: a REAL...
14 comments:
Monday, August 29, 2016

DB2 for z/OS: Clearing Up Some Matters Pertaining to Database Access Threads

›
I have recently received a number of questions pertaining to DB2 for z/OS database access threads, or DBATs. DBATs are threads used in the e...
13 comments:
Thursday, July 28, 2016

DB2 for z/OS: Clearing the Air Regarding CLOSE YES for Table Spaces and Indexes

›
This is another of my DB2 for z/OS blog entries motivated by a desire to clear up a matter about which there is some misunderstanding in the...
5 comments:
Tuesday, June 28, 2016

DB2 for z/OS: Indexes and Foreign Keys

›
The functionality of DB2 for z/OS is enhanced, in ways small and big, on a regular basis. There's plenty to keep up with, and it is unde...
9 comments: