Sunday, February 26, 2017

DB2 for z/OS: the PGSTEAL and PGFIX Options of -ALTER BUFFERPOOL

›
Recently, a DB2 for z/OS professional I’ve known for some years sent to me a question about the relationship between the PGSTEAL and PGFIX ...
5 comments:
Tuesday, January 31, 2017

Are You Using System Profile Monitoring to Manage Your DB2 for z/OS DDF Workload? Perhaps You Should

›
Here's a scenario that might sound familiar to you: you have a particular transaction, which I'll call TRNX, that is the source of q...
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: