By Akiko Hoshikawa, Bart Steegmans, Bituin Vizconde, John Campbell, Paul McWilliams. IBM just announced the upcoming release of Db2 13. Among the many enhancements in the new release, Db2 13 improves real storage management and eliminates the need of setting the system parameter REALSTORAGE...
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...
Db2® 12 for z/OS introduces continuous delivery of new capabilities in a single service stream. With continuous delivery, many APARs in Db2 12 deliver deactivated functional code to support future function levels. However, some APAR introduce their enhancements immediately, regardless of the...
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...
#Db2ZAI #Db2z12
Optimizing the performance of database systems and applications is time consuming and costly. Database administrators can spend as much as 25 to 30 percent of their time managing application performance and tuning SQL queries. Welcome to Db2 AI for z/OS Db2 AI for z/OS uses IBM Machine...
Starting in Db2 12, new capabilities and enhancements are continuously delivered in a single maintenance stream as the code becomes ready. You can activate the new capabilities in a data sharing group or Db2 subsystem after a function level is delivered. A function level corresponds to a...