Db2 for z/OS EXPLAIN: What an Access Path Is, and What it Would Be
The EXPLAIN functionality of Db2 for z/OS, by which the query optimizer’s access path determinations are externalized, has been around…
Db2 12 for z/OS Buffer Pools – Recommendations for PGSTEAL, PGFIX and FRAMESIZE
Not too long ago, I received a note from the leader of a Db2 for z/OS database administration team, asking…
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…