Welcome to the IBM 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.
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...
Introduced in Db2 13, SQL Data Insights brought artificial intelligence (AI) functionality to the Db2 for z/OS engine. It provided the capability to run SQL AI query to find valuable insights hidden in your Db2 data and help you make better business decisions. SQL DI prepares AI functions by...
With the availability of the PTF for APAR PH51469 , you can now activate function level V13R1M503 in Db2 13 for z/OS. Function level 503 introduces the following new application capabilities in Db2 13 for z/OS: New default values in existing rows for added ROW CHANGE TIMESTAMP...
Starting in Db2 13 at function level 500, application developers and DBAs have new controls over lock contention situations, with the CURRENT LOCK TIMEOUT special register and DEADLOCK RESOLUTION PRIORITY built-in global variable . Before the availability of these new controls, application...
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...
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...