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.
For the past 30 years, our focus as DB2 for z/OS database administrators has been on the support of COBOL programs with static queries that were relatively easy to control as they were identical throughout the business logic. Static SQL provided persisted access paths in the database s
Optimizing columnar access