Welcome to the IBM TechXchange 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.
Join / sign up
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...
By Gayathiri Chandran and Emily Alameida. With APAR PH54863 , Db2 13 now allows database administrators (DBAs) with DBADM authority on databases to drop a view and select from a view without always requiring system level authority. This function is available in V13R1M100 or higher....
By John Lyle and Paul McWilliams. After you apply the PTF for APAR PH50072 (available since June 2023), you can issue a DISPLAY GROUP command with the DETAIL keyword to quickly get a report about the readiness of your Db2 for z/OS subsystems and data sharing groups for migration to Db2...
With the release of Db2 12 for z/OS, Db2 development shifted from our previous three-year release cadence to continuous delivery, where new capabilities are available to customers as soon as possible, with less frequent new releases. Function levels were introduced to enable customers to control...
You are no doubt aware that Db2 development transitioned to continuous delivery of new features and capabilities with the release of Db2 12 in 2016, and Db2 development has continued this approach with the release of Db2 13. The Db2 function levels that enable many new capabilities tend to get a...
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...