Search

1 to 10 of 135
Sort by

Blog Entry
Migrate data from multi-table deprecated table spaces to UTS in function level 508

By Jennie Chang, Paul McWilliams, and Regina Liu . You can activate function level 508 in Db2 12 for z/OS, after you apply the PTF for APAR PH29392 . Function level 508 introduces the capability to move data from multi-table simple or multi-table segmented (non-UTS)...


Blog Entry
Take a new look at fast index traversal (FTBs) in Db2 12

By Akiko Hoshikawa and Paul McWilliams. The fast index traversal feature of Db2 12 (often called "FTB" for "fast traverse blocks") delivers valuable Db2 transaction performance improvements without the need for application changes. FTBs use a cache-friendly optimized in-memory structure...


Blog Entry
Akiko Hoshikawa named IBM Distinguished Engineer!

<Drum roll please > It is my great pleasure to announce that on September 1, 2020, Akiko Hoshikawa was appointed IBM Distinguished Engineer, Db2 for z/OS and Integrated AI. In her new role, Akiko will continue in her Db2 performance role and expand her leadership to the fusion of...

Mo Townsend's profile image

Blog Entry
Update on the Rebind phase-in capability added in FL 505

By Tammie Dang and Tim Hogan Db2 12 function level 505 introduced a new REBIND phase-in capability for application packages, which enables DBAs to issue REBIND PACKAGE commands successfully when target packages are being concurrently executed. This feature was supported for the PLANMGNT...

Tim Hogan's profile image

Blog Entry
It's time to upgrade to the JDBC driver with JDBC 4.0 support

By Jim Pickel and Judy Tobias. Db2 11 for z/OS and Db2 12 for z/OS APAR PH17211, which was delivered in October, 2019, delivered IBM Data Server Driver for JDBC and SQLJ version 4.26.16, and removed support for the driver that is based on the JDBC 3.0 specification. If you have not already...

JUDITH TOBIAS's profile image

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

Paul McWilliams's profile image

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

Paul McWilliams's profile image

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