IBM Db2 for z/OS – July 2026 Update: Agentic AI, Function Level 509 and a Growing Data Ecosystem

The July 2026 edition of the IBM Db2 for z/OS Customer Newsletter brings a substantial collection of updates. While artificial intelligence remains a major theme, this edition is particularly interesting for Db2 professionals because it combines IBM’s AI strategy with significant enhancements to the Db2 engine itself.

Highlights include the new IBM Z Database Assistant 1.1, Db2 13 Function Level 509, the new AI Optimizer for IBM Z and IBM LinuxONE 3.1, several Data Gate releases, SQL Data Insights Pro enhancements, and a new OMEGAMON AI for Db2 enhancement release.

---

IBM Z Database Assistant – Database Operations Meet Agentic AI

One of the most interesting announcements is IBM Z Database Assistant 1.1, released in June 2026.

IBM describes it as a modern graphical administration environment providing a single view across Db2 for z/OS subsystems and IMSplexes. It combines monitoring, performance analysis and familiar DBA productivity functions such as a command processor, SQL editor and catalog explorer.

More interestingly, IBM adds a natural-language AI interface. Administrators can ask questions such as which workloads consume the most resources, investigate Db2 timeouts for a particular subsystem and connection, or simply determine the function level of a subsystem.

The objective goes beyond adding a chatbot to a DBA interface. IBM is moving toward AI-assisted and eventually more agentic database operations, where monitoring, diagnosis, recommendations and administrative functions become increasingly integrated.

IBM Z Database Assistant documentation:
https://www.ibm.com/docs/en/z-database-assistant/1.1.0?topic=overview

---

Spotlight on Db2 13 for z/OS Function Level 509

For traditional Db2 specialists, Function Level 509 (V13R1M509) is probably the most important technical part of the newsletter. FL509 is enabled by the PTF for APAR PH70028 and introduces seven notable enhancements.

APAR PH70028:
https://www.ibm.com/support/pages/apar/PH70028

Db2 Catalog and Directory Complete Their Move to UTS

FL509 completes the long-running conversion of the remaining Db2 catalog and directory objects to partition-by-growth Universal Table Spaces (PBG UTS).

The transition started several Db2 releases ago. Completing it allows the catalog and directory to benefit consistently from performance, availability and usability capabilities associated with UTS.

IBM documentation:
https://www.ibm.com/docs/en/db2-for-zos/13.0.0?topic=levels-function-level-509#db2z_fl_v13r1m509__e6359

IBM technical blog – Converting Db2 catalog and directory objects to UTS with FL509 in Db2 13:
https://community.ibm.com/community/user/blogs/paul-mcwilliams1/2026/05/06/convert-db2-catalog-directory-objects-uts-fl509

Subnet Wildcard Filtering for RLF

The Resource Limit Facility (RLF) gains support for IP subnet addresses as well as the local IP address 127.0.0.1.

Subnet-based rules can substantially reduce the number of entries required in resource limit tables and simplify workload governance. Local-only rules also make it possible to control workloads originating directly from the Db2 subsystem more precisely.

IBM documentation:
https://www.ibm.com/docs/en/db2-for-zos/13.0.0?topic=levels-function-level-509#db2z_fl_v13r1m509__e30903

IBM technical blog – Subnet-based RLF governance with FL 509 in Db2 13 for z/OS:
https://community.ibm.com/community/user/blogs/gayatri-biswas/2026/05/14/subnet-based-rlf-governance-with-fl-509-in-db2-13

Online TRANSFER OWNERSHIP for Application Objects

The SQL TRANSFER OWNERSHIP statement is extended to application objects including stored procedures, functions and sequences.

Ownership can therefore be changed without dropping and recreating these objects – useful not only operationally, but also for security, regulatory and organizational requirements.

IBM documentation:
https://www.ibm.com/docs/en/db2-for-zos/13.0.0?topic=levels-function-level-509#db2z_fl_v13r1m509__e34902

IBM technical blog – TRANSFER OWNERSHIP for application objects with FL 509 in Db2 13:
https://community.ibm.com/community/user/blogs/paul-mcwilliams1/2026/05/19/transfer-ownership-application-objects-fl509

Utility History Records SHRLEVEL

Db2 utility execution history gains a SHRLEVEL column. This makes it possible to determine retrospectively how utilities were executed and, for example, verify whether SHRLEVEL CHANGE was used.

For operational analysis, auditing and troubleshooting of concurrency issues, this is a small but very useful enhancement.

IBM documentation:
https://www.ibm.com/docs/en/db2-for-zos/13.0.0?topic=levels-function-level-509#db2z_fl_v13r1m509__e36922

IBM technical blog – Tracking utility SHRLEVEL with FL 509 in Db2 13 for z/OS:
https://community.ibm.com/community/user/blogs/kate-wheat1/2026/05/21/fl509shrlevel

More Precise SQL Identification with STMT_HASHID2

New catalog columns introduce STMT_HASHID2, providing more granular identification of SQL statements.

Unlike identification based solely on identical SQL text, STMT_HASHID2 can incorporate additional context such as collection ID, package name and execution attributes. This improves SQL monitoring and diagnostics and also strengthens integration with Db2 AI for z/OS.

IBM documentation:
https://www.ibm.com/docs/en/db2-for-zos/13.0.0?topic=levels-function-level-509#db2z_fl_v13r1m509__e37750

More I/O Information in Real-Time Statistics

Db2 Real-Time Statistics now include object-level synchronous read I/O counters.

Together with existing GETPAGES information, DBAs gain a better picture of actual I/O behavior without requiring detailed tracing. The information can also be consumed by DBA tools and Db2 AI for z/OS.

IBM documentation:
https://www.ibm.com/docs/en/db2-for-zos/13.0.0?topic=levels-function-level-509#db2z_fl_v13r1m509__e38708

IBM technical blog – I/O counts in real-time statistics in Db2 13:
https://community.ibm.com/community/user/blogs/gayatri-biswas/2026/06/08/io-counts-in-real-time-statistics-in-db2-13

Reduced False Page P-Lock Contention

A new lock hash algorithm reduces false page P-lock contention in data sharing environments, particularly for large page sets.

This can improve concurrency, scalability and throughput for high-volume workloads. New page sets automatically benefit from the change, while existing objects can be updated through standard reorganization utilities.

IBM documentation:
https://www.ibm.com/docs/en/db2-for-zos/13.0.0?topic=levels-function-level-509#db2z_fl_v13r1m509__ph69217

Function Level 509 Overview

For an overview of all FL509 enhancements, see Paul McWilliams‘ announcement:

https://community.ibm.com/community/user/blogs/paul-mcwilliams1/2026/04/28/announcing-function-level-509-in-db2-13-for-zos

---

AI Optimizer for IBM Z and IBM LinuxONE 3.1

IBM has renamed and expanded the former AI Optimizer for Z as AI Optimizer for IBM Z and IBM LinuxONE 3.1.

Version 3.1 provides a unified AI inference stack delivered as a pre-integrated LPAR image. It combines model onboarding, serving, monitoring and optimization and includes support for the IBM Spyre Accelerator.

Intelligent routing can distribute inference between local and remote models, while Prometheus and Grafana provide real-time observability.

For Db2 environments, the architectural idea is particularly interesting: bring AI processing closer to trusted enterprise data instead of continuously moving that data to external AI platforms.

IBM announcement:
https://www.ibm.com/docs/en/announcements/ai-optimizer-z-linuxone-new-era-enterprise-ai-inference-optimization

IBM technical blog – Simplified and enhanced: Introducing the rebranded AI Optimizer for IBM Z and IBM LinuxONE:
https://community.ibm.com/community/user/blogs/guanjun-cai1/2026/05/05/simplified-and-enhanced-introducing-the-rebranded

IBM technical blog – IBM AI Optimizer for IBM Z and IBM LinuxONE: A new era of enterprise AI inference optimization:
https://community.ibm.com/community/user/blogs/tushar-vishwakarma/2026/04/24/ai-optimizer

---

New Product Releases – April to June 2026

IBM also lists several important ecosystem releases.

Data Gate for watsonx 1.4

The new version strengthens the integration of IBM Z transactional data with the watsonx.data lakehouse. It adds API-driven table management, Kubernetes- and Helm-based deployment, Prometheus-compatible monitoring and enhanced support for open table formats such as Apache Iceberg.

This provides a more standards-based route for incorporating operational IBM Z data into modern analytics and AI architectures.

Data Gate for z/OS 3.2

Data Gate for z/OS provides secure, high-performance replication of IBM Z transactional data to downstream environments.

Version 3.2 expands its role in hybrid data architectures with secure connectivity, API-based access, remote Db2 support, distributed query processing and data archival capabilities – while avoiding unnecessary impact on core transactional systems.

Data Gate for Confluent 1.1

A particularly interesting new integration is Data Gate for Confluent 1.1.

Using a Debezium-based connector, Db2 for z/OS data can be streamed in near real time into Confluent Platform. Initial JDBC snapshots can be combined with continuous log-based change streaming.

Events can be delivered using Avro or JSON and organized as table-level Kafka topics. As a Kafka Connect plugin, the connector also integrates with Confluent Control Center and Schema Registry.

This creates interesting possibilities for event-driven applications, real-time analytics and AI workloads without having to develop custom replication pipelines.

One important restriction should be noted: according to IBM, the current release supports self-managed Confluent environments only, not Confluent Cloud or non-Confluent Kafka distributions.

Note: The July newsletter does not contain embedded hyperlinks for these three Data Gate release descriptions.

SQL Data Insights Pro 1.1.1

SQL Data Insights Pro continues to mature after its introduction earlier in 2026.

Version 1.1.1 adds:

• extended REST API support,
• a command-line interface (CLI) for automation and integration, and
• an integrated UI log viewer for monitoring and troubleshooting.

Importantly, SQL Data Insights Pro is no longer limited to Db2 for z/OS data. Through Data Virtualization Manager (DVM), it can also work with enterprise data sources including VSAM and IMS.

The newsletter does not contain a separate embedded hyperlink for this release description.

OMEGAMON AI for Db2 Enhancement Release

The latest enhancement release adds complete Performance Database streaming using ODP, including locking and index-split information.

The Enhanced 3270 UI now displays inactive threads, TOM Single SYSPLEX mode improves monitoring efficiency, and batch reports indicate whether Db2 13 transactions use TLS encryption.

APAR PH69153:
https://www.ibm.com/support/pages/apar/PH69153

IBM technical blog:
https://community.ibm.com/community/user/blogs/matthias-tschaffler/2026/03/26/om-ai-db2-q1-ph69153

---

Recent Db2 Blogs

The July newsletter provides an unusually useful collection of recent technical articles. For Db2 professionals, these are worth following because many provide considerably more technical detail than the short descriptions in the newsletter.

Db2 13 and Function Level 509

Announcing Function Level 509 in Db2 13 for z/OS – Paul McWilliams
https://community.ibm.com/community/user/blogs/paul-mcwilliams1/2026/04/28/announcing-function-level-509-in-db2-13-for-zos

I/O counts in real-time statistics in Db2 13 – Gayatri Biswas
https://community.ibm.com/community/user/blogs/gayatri-biswas/2026/06/08/io-counts-in-real-time-statistics-in-db2-13

Tracking utility SHRLEVEL with FL 509 in Db2 13 for z/OS – Kate Wheat
https://community.ibm.com/community/user/blogs/kate-wheat1/2026/05/21/fl509shrlevel

Subnet-based RLF governance with FL 509 in Db2 13 for z/OS – Gayatri Biswas, Ganesh Nagarajan and Tammie Dang
https://community.ibm.com/community/user/blogs/gayatri-biswas/2026/05/14/subnet-based-rlf-governance-with-fl-509-in-db2-13

TRANSFER OWNERSHIP for application objects with FL 509 in Db2 13 – Paul McWilliams
https://community.ibm.com/community/user/blogs/paul-mcwilliams1/2026/05/19/transfer-ownership-application-objects-fl509

Converting Db2 catalog and directory objects to UTS with FL 509 in Db2 13 – Paul McWilliams
https://community.ibm.com/community/user/blogs/paul-mcwilliams1/2026/05/06/convert-db2-catalog-directory-objects-uts-fl509

AI, Data and Modernization

Turning Business Transactions into Business Action: Why Real-Time Data Matters More Than Ever – Nishant Kumar Sinha
https://community.ibm.com/community/user/blogs/nishant-kumar-sinha/2026/06/15/turning-business-transactions-into-business-action

Why Intelligent Database Operations Matter in the AI Era – Nishant Kumar Sinha
https://community.ibm.com/community/user/blogs/nishant-kumar-sinha/2026/06/22/why-intelligent-database-operations-matter-in-the

Simplified and enhanced: Introducing the rebranded AI Optimizer for IBM Z and IBM LinuxONE – Guanjun Cai
https://community.ibm.com/community/user/blogs/guanjun-cai1/2026/05/05/simplified-and-enhanced-introducing-the-rebranded

IBM AI Optimizer for IBM Z and IBM LinuxONE: A new era of enterprise AI inference optimization – Tushar Viswakarma
https://community.ibm.com/community/user/blogs/tushar-vishwakarma/2026/04/24/ai-optimizer

Db2 Tools and Development

Announcing the latest updates to Db2 for z/OS Developer Extension – Ariana Bibiano
https://community.ibm.com/community/user/blogs/ariana-bibiano/2026/06/08/announcing-the-latest-updates-to-db2-for-zos-devel

Enhancing DDF Observability: IFCID 365 Support in IBM Z IntelliMagic Vision – Ashish Padhi
https://community.ibm.com/community/user/blogs/ashish-padhi/2026/06/14/enhancing-ddf-observability-ifcid-365-support

Your Db2 for z/OS Agent Just Got More Flexible – Gandhi Ambalavanan
https://community.ibm.com/community/user/blogs/gandhi-ambalavanan/2026/05/04/gia-db2-for-zos-agent-just-got-more-flexible

APAR PH69153 – The first enhancement release for OMEGAMON AI for Db2 6.1.0 has arrived! – Matthias Tschaffler
https://community.ibm.com/community/user/blogs/matthias-tschaffler/2026/03/26/om-ai-db2-q1-ph69153

Complete recent-blog overview for the Db2 for z/OS community:
https://community.ibm.com/community/user/groups/community-home/recent-community-blogs?communitykey=621c2a2a-01f9-4b57-992f-36ed7432e3bb

---

Education

IBM’s next Db2 for z/OS Master Class takes place in San Jose, California, September 14–18, 2026.

Applications are accepted until August 31, 2026, and the participation fee listed by IBM is $2,950 per participant.

IBM’s 2026 Db2 for z/OS Master Class information:
https://community.ibm.com/community/user/blogs/dorothy-lin/2025/12/18/announcing-the-2026-schedule-for-the-ibm-db2-for-z

---

Upcoming Conferences

Several important Db2 and IBM Z events are scheduled for the remainder of 2026.

SHARE Pittsburgh

August 16–20, 2026 – Pittsburgh, Pennsylvania, USA

Conference information:
https://www.share.org/Events/SHARE-Pittsburgh

Registration:
https://www.share.org/Events/SHARE-Pittsburgh/Registration

IDUG Brazil

August 17–19, 2026 – São Paulo, Brazil

Conference information:
https://www.idug.org/events/idug-brazil-2026

Registration:
https://ti.to/idug/latam-2026-saopaulo

GSE Expo Europe

September 15–17, 2026 – Lisbon, Portugal

Conference information:
https://www.gse-expo-europe.com/

Registration:
https://forms.reg.buzz/gse-expo-europe-2026/gseexpoeurope

IDUG EMEA

September 27–October 1, 2026 – Porto, Portugal

Conference information:
https://www.idug.org/events/idug-emea-2026

Registration:
https://aimgroup.eventsair.com/idug-2026/reg/Site/Register

IDUG North America

October 25–29, 2026 – Atlanta, Georgia, USA

Conference information:
https://www.idug.org/events/idug-na-2026

Registration:
https://www.idug.org/events/idug-na-2026/register

GSE UK

November 2–5, 2026 – Whittlebury Hall, Northamptonshire, UK

Conference information:
https://conferences.gse.org.uk/

---

Summary and Outlook

The July newsletter is particularly interesting because it demonstrates two parallel directions in Db2 development.

On the one hand, Db2 itself continues to evolve through continuous delivery. Function Level 509 contains several very practical improvements for experienced DBAs – from catalog modernization and RLF governance to better SQL identification, richer Real-Time Statistics and improved data sharing scalability.

On the other hand, IBM is rapidly building an AI and data ecosystem around Db2. IBM Z Database Assistant introduces natural-language interaction into database operations, SQL Data Insights Pro brings AI closer to enterprise data, AI Optimizer provides an integrated inference platform, and the various Data Gate products connect Db2 with watsonx, lakehouse architectures and event streaming.

The Data Gate for Confluent release is particularly noteworthy in this context: it illustrates how IBM is opening transactional Db2 data to modern event-driven architectures while preserving Db2 for z/OS as the system of record.

The common theme is becoming increasingly clear:

IBM wants organizations to exploit their Db2 for z/OS data for modern analytics and AI without giving up the performance, governance, availability and security characteristics of IBM Z.