Ask a question
Learn more about TechXchange Dev Days virtual and in-person events here
With the availability of the PTF for APAR PH64907 , you can now activate function level V13R1M507 (FL 507) in your Db2 13 for z/OS environment. Activating FL 507 introduces the following new-function capabilities in your Db2 13 for z/OS environment: Online conversion of...
QMF for TSO/CICS 13.1 special register manager is enhanced to allow APPLCOMPAT as the abbreviated spelling where APPLICATION COMPATIBILITY is used with SET statement. " CURRENT APPLICATION COMPATIBILITY" is still valid and will still be accepted. Users can issue the following 2 statements from...
IBM announced in August 2023 that Db2 12 for z/OS will reach its end of support (EOS) on December 31, 2025, more than nine years after its general availability began in October 2016. The good news is that Db2 13 has already been available for years, with a faster and simplified migration...
IBM SQL Tuning Services provides the ability to analyze and tune the performance of SQL queries that work with Db2 for z/OS data. It can be used on its own as an API or as an integrated component of the Db2 Administration Foundation and Db2 for z/OS Developer Extension graphical user interfaces....
My 2025 was off to a fast start with the IDUG Db2 India conferences in February in the bustling cities of Bangaluru and Pune. This was my first visit to India, and it was a great opportunity to learn about the culture and people and connect to both Db2 customers and the IBM Db2 development group...
By Paul McWilliams and Liyan Zhou. With the PTF for APAR PH64377 in Db2 13 for z/OS, you have the option to use APPLCOMPAT as an abbreviation in various SQL statements, where only the fully spelled-out form of APPLICATION COMPATIBILITY was allowed. This small but useful improvement...
Db2 13 for z/OS has been generally available for several years. Db2 12 for z/OS is going End of Support December 31, 2025. Db2 for z/OS customers must migrate or acquire extended support contracts. Join Anthony Ciabatttoni and John Lyle for a webinar on migrating to Db2 13 for...
Wed April 09, 2025 | 01:00 PM - 02:00 PM ET
A new capability that many DBAs have requested is now available in version 4.34 of the IBM Data Server Driver for JDBC and SQLJ, which is available with Db2 12.1. Before version 4.34 of the IBM Data Server Driver for JDBC and SQLJ, automatic connection checking when an application...
By Huiya Zhang and Jim Pickel In Db2 13 for z/OS, you can apply the PTF for APAR PH62137 to prevent flooding of z/OS console by overwhelming numbers of DSNL030I messages, which has become a significant pain-point for database administrators. This APAR introduces a new DSNL061I message...
By Frances Villafuerte, Shirley Zhou, and Paul McWilliams. Insert throughput and efficiency are among the most critical attributes of OLTP applications in high demand-business environments, and insert algorithm 2 (IAG2) was introduced in Db2 12 to improve the performance of concurrent...