Db2 Month
Learning from SMF: Managing Db2 Buffer Pools
Unlocking the Value of Cheryl Watson’s Tuning Letter Back Catalog If you work with IBM mainframes, you’ve probably heard of Cheryl Watson’s Tuning Letter, which I now have the pleasure of editing. For decades, it’s been one of the most trusted resources for...
Inside Db2 for z/OS: How Optimized B+ Trees Power High-Speed Indexing
High-quality indexes are critical for fast data access and returns. IBM Db2 for z/OS relies on an advanced data structure called the Optimized Balanced Plus Tree to power high-speed indexing. This structure, an evolution of the classic B+ Tree, helps Db2 deliver...
Welcome to the Virtual Db2 user group
The Virtual Db2 user group launches in January with a presentation on the 17th from Craig S Mullins, President & Principal Consultant at Mullins Consulting Inc. And being a virtual meeting, you don’t have to face the hard task of convincing your company to fund...
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, there is a parameter named SEPARATE_SECURITY. This ZPARM was introduced with Db2 10, and its purpose is to enable a Db2 for z/OS-using...
Know Your Isolation Levels to Develop Correct and Efficient Db2 Programs
Did you know that Db2 provides a method to change the way a program or SQL statement acquires locks? That way is known as the isolation level and it can be set to specify the locking behavior for a transaction or statement. Standard SQL defines four isolation levels...
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 significant dividends by enabling an organization to get more value from its data assets. Db2 for z/OS people should have some familiarity...
All About zIIPs
If you work with Db2 then you need to know about the IBM zIIP specialty processor. This is true whether you are a DBA or a developer... and, let's face it, if you work on a mainframe in any capacity, you'll want to know at least something about zIIPs. With that in...
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 connect to Db2 via TCP/IP communication links. DDF has been around for over 30 years, but especially during the past 10 years or so DDF workloads...
Db2 Month
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 I’ll look at that outbound message and think to myself, “Hmm. I may have written most of a blog entry there.” This is one of those ca…
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 trends. I try to help but I always make it clear when answering that I cannot predict the future, only make educated guesses… …
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 indexes. Perhaps the most important thing you can do to assure optimal application performance when accessing data …
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 with PGSTEAL(NONE), including one from a few years ago in which I differentiated the PGSTEAL and PGFIX buffer pool specifications, and another...
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 about where we get Db2 containers and several common ways they are used. Catch my next post about a critical mistake I think IBM is making with containerization. Ways...
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 you can go down. I’m well aware that there’s probably 40% of Db2 LUW alone that I don’t know, even though I’ve spent 20 years working...
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, insurers and financial services companies. It was designed to execute their high-intensity transaction processing workloads very...
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 as long as I can remember, and Db2 people, by and large, are familiar with the concept. In recent weeks, however, I discovered that...
Sign up to receive the latest mainframe information
Upcoming Events
Events
-
-
Virtual Db2 User Group | My All-Time Db2 Top Ten Lists
Virtual MeetingDate: November 17, 2026 - 11:30am ET Presenter: Craig Mullins What do Db2 performance, application development, database administration, and David Letterman have in common? Top Ten lists, of course! Join […]
-
Virtual Db2 User Group | November 17, 2026
Zoom - Virtual Meeting -
-
Virtual CICS User Group | Latest Update on Security in CICS TS 6.3: The Journey to Zero Trust
Zoom - Virtual MeetingCICS has been advocating zero trust principles and introducing security-focused enhancements since CICS TS 6.1. This session will explore the latest security capabilities available in CICS TS 6.3 and how […]
-
Virtual IMS User Group | December 15, 2026
Zoom - Virtual Meeting
IBM Expands Its Digital Banking Infrastructure, Agentic AI on the Mainframe, and more
Kyndryl Report: As AI Broadens Modernization Agenda, Leaders Prioritize Business Outcomes Over Replacing Legacy Systems IBM Expands Its Digital Banking Infrastructure with Swift Integration and Digital Asset Haven On-Premises Rocket Software Advances Governed, Agentic...
Agentic AI on the Mainframe
It’s AI month at Planet Mainframe, and for Round Two of our Trivia Challenge, we’re turning to agentic AI. On the mainframe, this emerging technology is moving beyond answering questions and generating code. Agents can interpret goals, reason through multi-step...
Risk and Compliance Portfolio for IBM Z Environments, IBM Z Datathon, and more
Rocket Software Launches Rocket® z/Assurance™, a Risk and Compliance Portfolio for IBM Z® Environments IBM Z Datathon: Build AI for Good. In 24 Hours. At Global Scale. Broadcom 2026 North American Mainframe Technical Exchange LTM Collaborates with IBM and Red Hat on...
❓Think You Know Mainframe AI
Mainframes have powered intelligent decisions for decades. Today, artificial intelligence (AI) takes that role further – spotting fraud as transactions happen, anticipating workload demands, helping developers understand legacy code, and strengthening system...
Next-Generation Dual-Architecture Processor, Advances in AI Enablement for Application Modernization, and more
IBM Unveils Next-Generation Dual-Architecture Processor for IBM Z and LinuxONE BMC Survey Finds 94% Confidence in the Mainframe as Enterprises Scale AI With Human Oversight Rocket Software Advances AI Enablement for Application Modernization Across Mission-Critical...
Partnership to Accelerate Secure AI Deployment, Introduction of New Agentic Modernization, and more
IBM Partners with OpenAI to Accelerate Secure AI Deployment for Enterprises Across Core Operations Kyndryl Introduces New Agentic Modernization Services-As-Software Scaled Through Kyndryl Bridge BMC Achieves the AWS AI Competency Kyndryl Named 2026 CIO 100 Award...

