The first edition of IBM Db2 13 for z/OS Performance Topics is now available from IBM Redbooks! It provides performance comparisons between Db2 13 and Db2 12, including high-level performance expectations when you migrate to Db2 13. Db2 13 delivers significant innovations that can improve...
By Long Tu with Paul McWilliams. Starting in function level 500 or higher with APAR PH51359 (December 2022), Db2 13 for z/OS supports stacking of certain pending data definition changes (DDL) when you use the new capability in Db2 13 to convert a table in a partition-by-growth (PBG)...
The stability of Db2 for z/OS systems is legendary. That stability is based upon a partnership between Db2 development and the customer, where each party has a responsibility that cannot be wholly mitigated by the other. Haakon Roberts recently described the Db2 for z/OS development side of this...
Does your Db2 system hit its specified MAXDBAT limit regularly? If it does, you might need to evaluate whether your MAXDBAT and CONDBAT settings are configured to allow your Db2 subsystem to run with optimal performance. The MAXDBAT subsystem parameter controls the maximum number of database...
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...
The stability of Db2 for z/OS systems is legendary. That stability is based upon a partnership between Db2 development and the customer, where each party has a responsibility that cannot be wholly mitigated by the other. The focus of this post is to provide insight into Db2 development’s service...
1 Comment - no search term matches found in comments.
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...