Db2 for z/OS: SEPARATE_SECURITY and SECADM
In the Db2 for z/OS module called DSNZPARM (ZPARM, for short), which provides the configuration settings for a Db2 subsystem,…
What Db2 for z/OS People Should Know About Data Fabric
“Data fabric” is an increasingly hot topic in IT circles, and with good reason—an effectively implemented data fabric can deliver…
What Should a Modern Db2 for z/OS Client-Server Application Environment Look Like?
The distributed data facility (aka DDF) is the component of Db2 for z/OS that enables data access by applications that…
Db2 for z/OS: The Online Path from a Partition-by-Growth Table Space to Partition-by-Range
Last month, I posted to this blog an entry on the long-awaited capability to migrate tables, in an online way,…
Db2 for z/OS: The Online Path from a Multi-Table Table Space to Universal Table Spaces
Back in 2014, I posted an entry to this blog on the topic of getting to universal table spaces from…
Db2 for z/OS: Answering Some Questions About DBATs (i.e., DDF Threads)
Sometimes, a DBA will email me a question about Db2 for z/OS, and I'll respond in a pretty comprehensive way, and…
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 defined…
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…
