Db2 Month
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...
Streamlining Your Db2 13 Migration: 7 Steps to Get Ahead
Adapted and summarized by ChatGPT. Download Paul’s full article. Migrating to a new version of a critical platform like Db2 for z/OS might sound daunting, but with the right strategy, it can be manageable and an opportunity to improve operational efficiency. Db2 13 is...
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 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, from a multi-table segmented or simple table space to multiple single-table partition-by-growth table spaces (a capability delivered with function level 508...
The DB2Night Show #246: Db2 Advanced Log Space Management – Unleashed
Show Host Martin Hubel Commentary Michael did a great job in providing an important update for log management. Search #DB2Night to learn more. Get the Download Replays To download a recorded replay of Episode 246 in WMV format:"Episode 246, 10 Jun 2022, Db2 Advanced...
Time to Download the Db2 13 for z/OS Manuals!
Yesterday I posted a brief piece about the new version of Db2 for z/OS that is now generally available: Db2 13 for z/OS is Here! It is always an exciting time when a new version of Db2 for z/OS is unleashed on the world and one of the first things I recommend is to...
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 non-universal table spaces. In that entry, I noted that there was an online path (ALTER followed by online REORG) for getting from a "classic" partitioned...
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 cases. I recently got a...
Db2 Month
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...
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 for my take on a Db2 12 buffer pool configuration set-up that his team had devised. An interesting characteristic of the configuration was the use of the options...
Removing Duplicates From a List in Elixir
Thanks to the Enum module, in Elixir we can trivially remove duplicates from a list. In the following example, we take a list of integers and pass it to the Enum.uniq/1 function which removes duplicates from the list without altering the original...
Developing with Elixir/OTP Course Review
Ruby was the first programming language I truly fell in love with. Yes, I had used several others before (and have since), but Ruby was and still is something dear to me. I can appreciate the usefulness of Python, the simplicity of Go, and the mind-expanding nature of...
Sorting Results by Specific Values in SQL with CASE
Recently I rewrote the backend for my service, Any New Books, due to an Amazon API change. Generally speaking, rewriting an entire codebase is a bad idea. However, the code was quite old and the API changes rather drastic, so I took the opportunity to rewrite the...
4 Tech Innovations That Could Change Smartphones
Smartphones have gotten so advanced today that it can almost be hard to tell the difference between the top options. That’s not to say you’d literally mix up an iPhone and its Samsung counterpart — but there aren’t too many defining features that really set one apart...
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 the buffer pool configuration in their production Db2 environment (the overall size of the buffer pool configuration was increased to reduce read I/O activity,...
Db2 12 In-Memory Feature: Fast Index Traversal
Db2 12 is classified as an in-memory data base by Gartner. It is not just a simple in-memory data base but a very smart one. In this paper, we explain one of the most innovative in memory optimizations in Db2 12. Why In-Memory Optimization in Index? The...
Sign up to receive the latest mainframe information
Upcoming Events
Events
-
-
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
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...
Mainframe Jargon Challenge
Every technical field develops its own language, and the mainframe world is no exception. Whether we’re talking about the alphabet soup of multi-letter acronyms or terms that have been part of the platform for decades, mainframe jargon serves as a kind of shorthand...

