Moving from IMS to Db2?
As a Db2 consultant and regular blogger I often receive questions about technical things, but also on strategy and industry…
Top 10 Steps to Building the Right Indexes
One of the constant struggles with Db2 development, and indeed developing for any relational DBMS, is designing and creating appropriate…
Db2 for z/OS: Clearing Up Some Matters Pertaining to PGSTEAL(NONE) Buffer Pools
I have written a few entries for this blog in which I provided information about Db2 for z/OS buffer pools…
Where do Db2 Containers Come From and How are they Used
In my last post, I wrote an overview of running Db2 in containers. Today, I’d like to talk a bit…
The Developer-DB Love-Hate Relationship
There’s a reason why database administration or engineering remains a separate specialty. There are a large number of rabbit holes…
Accelerating Your Db2 Database
Your Db2 database The IBM mainframe and its Db2 database is the transaction processing workhorse for the world’s biggest banks,…
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…