Join / sign up
With the availability of the PTF for APAR PH59534 , you can now activate function level V13R1M505 in Db2 13 for z/OS. Function level 505 introduces the following new features and capabilities in Db2 13. A new token-based authentication that uses the RACF® Identity...
By Tammie Dang and Paul McWilliams With the release of function level 504 in Db2 13 for z/OS, you can now enable autobind phase- in for packages invalidated at statement level granularity . This new capability uses the statement-level dependency and invalidation infrastructure...
1 Comment - no search term matches found in comments.
As Haakon mentioned in his December update from Db2 for z/OS development , we have continued unabated with the delivery of new capabilities to Db2 13 for z/OS since its release in early 2022, with three new function levels and more than 45 standalone PTFs for new-function APARs. In June, I...
Hi everyone - Happy New Year's Eve, and when you read this in 2024, then, Happy New Year! I am working on a niche area of Db2 - i.e. Db2 Stored Procedures (SPs) and, something similar but with a different name, Db2 SQL Procedures (SQLPs) - definitions to follow in subsequent BLOG episodes. ...
4 Comments - no search term matches found in comments.
Starting in Db2 13 at function level 504, and controlled by application compatibility level V13R1M504 or higher, DBAs and application developers who are using a fullselect that contains an invocation of LISTAGG with an ORDER BY clause can now execute them successfully. Prior to this enhancement,...
2 Comments - no search term matches found in comments.
By Paul McWilliams and John Lyle. Starting with the availability of function level 504 in Db2 13 , activating a higher function level now also verifies that a specific set of previously available PTFs for new-function APARs are applied consistently in your Db2 13 environment, including all...
With the availability of the PTF for APAR PH54919 (October 2023), you can now activate function level V13R1M504 in your Db2 13 for z/OS environment to activate the following new capabilities. Minimized impact of invalidated packages with statement-level invalidation Starting in...
SQL Data Insights (SQL DI) is a new feature that is built into the Db2 for z/OS engine. The feature combines deep learning in artificial intelligence (AI) with advanced IBM Z technologies to infuse the Db2 engine with SQL-based semantic queries on user tables and views. To put it simply, SQL DI...
Getting started with IBM Db2 SQL Data Insights.pdf
By Catherine Wu and Guanjun Cai Imagine a world where a database management system does not just simply retrieve and store data. With the integration of advanced AI technology, Db2 for z/OS can now delve deep into your data , exposing unseen...
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...