As a Db2 consultant and regular blogger I often receive questions about technical things, but also on strategy and industry trends. I try to help but I always make it clear when answering that I cannot predict the future, only make educated guesses… …
A user-defined function, or UDF for short, enables you to customize Db2 to your shop’s requirements. It is a very powerful feature that can be used to add procedural functionality, coded by the user, to Db2. The UDF, once coded and…
One of the constant struggles with Db2 development, and indeed developing for any relational DBMS, is designing and creating appropriate indexes. Perhaps the most important thing you can do to assure optimal application performance when accessing data …
If you work with Db2 then you need to know about the IBM zIIP specialty processor. This is true whether you are a DBA or a developer... and, let's face it, if you work on a mainframe in any capacity, you'll want to know at least something about zIIPs. With that in...
Did you know that Db2 provides a method to change the way a program or SQL statement acquires locks? That way is known as the isolation level and it can be set to specify the locking behavior for a transaction or statement. Standard SQL defines four isolation levels...
It has been close to a year since Db2 13 for z/OS has been generally available. It was announced in April 2022 and delivered for GA on May 31, 2022. As you think about migrating from Db2 12 to Db2 13, it is inevitable that you will consider the new functionality and...
Performance is a critical aspect of any database management system, and IBM Db2 is no exception. As organizations deal with ever-increasing data volumes and complex workloads, it is crucial that Db2 environments are fine-tuned to ensure optimal performance,...
Db2 12 for z/OS has been available now for close to 7 years, which is a “forever” in the world of enterprise software. But more than a year ago now IBM delivered a brand new release of Db2, Version 13! Db2 13 for z/OS was announced on April 5, 2022 and was delivered...
Last time we covered Db2 12 for z/OS Function Levels and how that was the basis for Db2v13. Another synergy with the z Systems hardware is that Db2 13 for z/OS takes advantage of the new IBM Z Telum processor for AI workloads. And AI capabilities are one of the big...
Last time we looked at AI and Db2; today let’s look more closely at Db2v13 improvements in Application Support. There are always changes and features delivered with each new version of Db2 that impact application developers, and Db2 13 for z/OS is no different. The...
