Search

1 to 10 of 133
Sort by

Blog Entry
DSN1COMP now estimates the effectiveness of compressing data with IBM z14 Hardware based Huffman encoding

In Db2 12, with the PTF for APAR PH19242 applied, you can now use the DSN1COMP stand-alone utility to estimate the space savings that you might realize by compressing your data in Db2 for z/OS table spaces with IBM z14 hardware-based Huffman compression . The capability to compress data...


Blog Entry
More detailed location statistics in Db2 12

By Jim Pickel and Paul McWilliams. In Db2 12 with APAR PH16111 applied, you can now use more detailed location statistics to better understand the behavior of your remote applications, how work coming from network connections is changing, and the impact on your Db2 system. Location...


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...

Eric Radzinski's profile image

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...

Paul McWilliams's profile image

Blog Entry
Announcing Db2 AI for z/OS 1.3.0!

by Tim Hogan, Emily Alameida, and Eric Radzinski Db2® AI for z/OS® (“Db2ZAI”) empowers the optimizer in your Db2 for z/OS engine to determine the best-performing query access paths, based on your workload characteristics. In addition, Db2ZAI detects Db2 system performance exceptions...

Emily Alameida's profile image

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
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