With the availability of APAR PH65562 , you can now use two new options, REFPF and VPCLOSET, of the -ALTER BUFFERPOOL command to help you manage cross invalidation of buffer pool pages for specific buffer pools, especially in Db2 data sharing groups. This repeated invalidation, which occurs...
By Long Tu and Paul McWilliams. With the availability of function level V13R1M507 (FL 507) in Db2 13 for z/OS, database administrators (DBAs) can use an online change—with no application outages—to convert the data partitioning scheme of an existing table in a partition-by-range (PBR)...
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...