Welcome to the IBM TechXchange Community, a place to collaborate, share knowledge, & support one another in everyday challenges. Connect with your fellow members through forums, blogs, files, & face-to-face networking.
Join / sign up
By Akiko Hoshikawa, Bart Steegmans, Bituin Vizconde, and Paul McWilliams. We recently received several questions about changes introduced in Db2 12 by APAR PH47163 . It changes the Db2 12 real storage management behavior with the REALSTORAGE MANAGEMENT=AUTO setting, which is the...
By Hugh Smith with Paul McWilliams. You can now request that Db2 for z/OS generates more granular accounting trace records for distributed database (DDF) applications by using the new ACCTG(ALLCOMMIT) of the MODIFY DDF command . When this option is set, Db2 generates an accounting trace...
With the release of Db2 12 for z/OS, Db2 development shifted from our previous three-year release cadence to continuous delivery, where new capabilities are available to customers as soon as possible, with less frequent new releases. Function levels were introduced to enable customers to control...
You are no doubt aware that Db2 development transitioned to continuous delivery of new features and capabilities with the release of Db2 12 in 2016, and Db2 development has continued this approach with the release of Db2 13. The Db2 function levels that enable many new capabilities tend to get a...
In both Db2 12 and Db2 13, the Db2 for z/OS declarations generator (DCLGEN) was recently enhanced by new-function APARs that deliver the following improved support of certain data types. COMP-5 declarations for integer data in COBOL applications With PH42857 in Db2 12 and in Db2...
By Akiko Hoshikawa, Bart Steegmans, Bituin Vizconde, John Campbell, Paul McWilliams. February 2024 update: for the latest recommendations, see Db2 12 real storage management and recommendations after APAR PH47163 . IBM just announced the upcoming release of Db2 13. Among the...
Have you heard a rumor that activating function level 504 prevents you from creating any deprecated objects in your Db2 12 environment, such as “classic” non-UTS segmented or partitioned or table spaces, or new tables in simple table spaces? If you are like many of our customers who still...
Updated April 5, 2022: this entry is updated to reflect that IBM has announced Db2 13 for z/OS . By John Lyle and Paul McWilliams. You can now activate function level 510 (FL 510) in your Db2 12 for z/OS environment, after you apply the PTF for APAR PH33727 . The previous function...
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...
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...