By Ping Wang and Lingyun Wang With the enhancement provided in PH64099, available in both data sharing and non-data sharing systems on Db2 13 function level 500 or higher, Db2 for z/OS now supports utilizing the compression dictionary data set (CDDS) to store expansion dictionaries for...
By David Kuang and Ariana Bibiano. Starting in function level 507 of Db2 13 for z/OS, Db2 for z/OS database administrators (DBAs) can specify greater than 64 GB primary and secondary allocation quantities in the CREATE TABLESPACE and ALTER TABLESPACE statements. The primary space allocation...
First of all my recommendation is check and follow IBM's site process and second check or attend all the great presentations about this subject. But now, that been said, I will write down what I would recommend to a colleague still running in Db2 V12. It is never too soon to...
At the recent IDUG North America 2025 conference in Atlanta, I had the opportunity to present on how we’re leveraging GenAI to close the widening skills gap in the Db2 for z/OS world. We had a spirited discussion on how GenAI differs from traditional AI, and more notably, about what AI...
By Wei Li and Paul McWilliams Starting in Db2 13 for z/OS at function level 507 , Db2 application developers who run their applications at APPLCOMPAT level V13R1M507 or higher can now issue SELECT statements that reference both a temporal table and an archive-enabled table , if the...
Db2 Log Analysis Tool provides comprehensive log-based solutions on reporting, auditing , recovery and replication. Now there is an additional way of presenting and analyzing the log data in analytics dashboards. This blog looks at a new feature of stream ...
By Dawson Williams and Paul McWilliams. Starting in function level 507 of Db2 13 for z/OS (available with the PTF for APAR PH64907 ), Db2 for z/OS database administrators (DBAs) can rely on the LASTUSED column in the SYSIBM.SYSPLAN catalog table to determine when application plans were...
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...