With the availability of the PTF for APAR PH4789 , you can now activate Db2 13 function level V13R1M502 (FL 502) in your existing DB2 13 environments, and you can now also install Db2 13 at FL 502. No new catalog update is required for the activation of function level 502. Function level...
By Frances Villafuerte with Long Tu, Regina Liu, and Paul McWilliams. Db2 13 introduces the capability to convert tables in partition-by-growth (PBG) tables spaces to partition-by-range (PBR) with a pending definition change, and little to no impact on your applications. This new capability...
Db2 13 introduces page sampling for inline statistics by Koshy John and Kate Wheat When gathering statistics, Db2 can use page sampling or row sampling. Page sampling is typically faster in both elapsed time and CPU time. The RUNSTATS utility has had the ability to do page sampling since...
Db2 13 continues and evolves the migration and continuous delivery approaches that were first introduced in Db2 12, where function levels (FLs) control the introduction of new capabilities. Db2 13 starts with three function levels at migration: FL 100, FL 500, and FL 501, instead of the two...
By Tran Lam, Akiko Hoshikawa, Haakon Roberts, Jim Pickel, Gayathiri Chandran, and Paul McWilliams In a continuation of the simplification effort for Db2 subsystem parameters (ZPARMs) in Db2 12 , Db2 13 introduces changes the default settings for various subsystem parameters (zPARMs) to...
Db2 13 for z/OS improves insert performance for partition-by-growth (PBG) table spaces by introducing a new cross-partition search algorithm. PBG table spaces were designed to solve the 64G size limitation of segmented table spaces. Db2 manages PBG table spaces automatically as data grows, by...
As announced, the general availability of Db2 13 for z/OS was May 31, 2022, and I’m excited to announce that the online product documentation for Db2 13 for z/OS was available available at the same time! As with every Db2 release, there a lot of content, but here are some good places to...
1 Comment - no search term matches found in comments.
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...
I’m excited to share that today IBM announced a new version of Db2 for z/OS — the first in over five years — along with a new release of Db2 AI for z/OS and updates to Db2 Tools for z/OS , which not only work with the latest Db2 version but add value all their own. Db2...
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...