There are numerous enhancements to SQL in DB2 12 for z/OS. There is also a significant amount of SQL performance enhancements in DB2 12 for z/OS which contribute to the “out of the box” savings realized when migrating from DB2 11 for z/OS. The IDUG team explored some of the most significant new SQL
Often times there can 4,5,6 different ways to write an SQL query and get the same results back. What makes one better than any of the others, and is there any ones that are always better, or always worse? Sometimes rewriting 1 predicate in an SQL statement can cause optimization to change. This pres
This week we are featuring a presentaiton given at the IDUG EMEA conference in Dublin. Jacek and Michal discuss the importance of paying attention to SQL code in a higly complex and active environment.
There has been quite a bit of attention paid to the access path stability features of DB2 for z/OS since they first appeared in DB2 9. Enhancements have followed in each subsequent release. This article will discuss these features.
A good developer should have a reasonable knowledge about the technology he or she is using in the application. Of course it is not possible to know deeply every single detail these days, but is usually useful to understand at least the main principles and to know where to find more details.