Search

1 to 10 of 129
Sort by

Blog Entry
Monitoring and controlling connections and threads with Db2ZAI 1.3.0

By Eric Radzinski The latest release of IBM Db2 AI for z/OS, Db2ZAI 1.3.0, which is generally available as of June 19th, comes equipped with an entirely new feature called Distributed Connection Control that's designed to ease the burden of ensuring that distributed applications are consuming...


Blog Entry
Function level 507 now availabile in Db2 12!

By Paul McWilliams and Jennie Chang. Db2 12 for z/OS introduced continuous delivery of new capabilities in function levels that you activate when you are ready to use the new capabilities. After you apply the the PTF for APAR PH24371 , you can now activate function level 507 Function...


Blog Entry
Introducing IBM Db2 for z/OS Data Gate

By Samantha Buhler, Daniel Martin , and Mike Wendel IBM Db2 for z/OS Data Gate (Db2 Data Gate) offers a new approach to access and get value from Db2 for z/OS data with little or no impact on the core transaction processing on IBM Z. Db2 Data Gate extracts, loads and synchronizes mission...

Mike Wendel's profile image

Blog Entry
The latest updates to Insert Algorithm 2

By Frances Villafuerte. Insert algorithm 2 (IAG2), which alleviates the contention that's often observed in highly concurrent insert applications, is one of the key performance features of Db2 12. This feature is available in Db2 12 function level 500 or higher and is applicable to universal...


Blog Entry
Access path reuse for autobinds in Db2 12

By Randy Nakagawa, Eric Radzinski, and Paul McWilliams. In Db2 12 with APAR PH15896 , Db2 now attempts to reuse the existing access paths from the current package copy for automatic rebinds, reducing the risk of performance adverse effects to subsequent executions of the package. ...

Paul McWilliams's profile image

Blog Entry
Improved reliability and contention relief for online migration to Db2 12

By John Lyle, Chris Leung, and Jennie Chang. With the End of Support (EOS) for Db2 11 for z/OS approaching on March 31st, 2021, migrating to Db2 12 will soon be an essential step to take if you haven't done so already. New instrumentation is now available in Db2 11 and Db2 12 to identify...

Jennie Chang's profile image

Blog Entry
Db2 Client Success update: new encryption requirements for uploading data to IBM Support

By Shu Li Kragness and Paul McWilliams. We've written previously about how secure protocols are now required for exchanging data with IBM Support, and more changes are coming soon. The following changes to the anonymous FTP server and the FTPS (FTP over TLS) server encryption settings...

Paul McWilliams's profile image

Blog Entry
Db2 11 for z/OS End of Service date change

With 6 months remaining until Db2 11 for z/OS end of service (EOS), while most clients are working with Db2 12, completion of production migrations is slower than originally anticipated. As a result, we have announced an extension of the EOS for Db2 11 for z/OS from September 30, 2020 to March...

Mo Townsend's profile image

Blog Entry
New instructional videos available on the Db2 Analytics Accelerator Demos page

Visit the Db2 Analytics Accelerator Demos page . This is a great to learn more about the product with: New product videos, including: Overview of HA load sample capability HA load sample hints, tips and best practices Installation and setup of the HA Load Sample Introduction...

Pat Zakhar's profile image

Blog Entry
More granular statistics trace data in Db2 12

By Sharon Roeder and Paul McWilliams. In Db2 12 after you apply APAR PH18658 , you can now collect more granular data for certain key Db2 statistics traces. Before now, these traces were always collected at a fixed one-minute interval. With today's faster processors, monitoring at a more...

Paul McWilliams's profile image