I’ve spent the last 17 years teaching SQL Performance & Tuning on DB2 for z/OS. I’ve been trying to get SQL developers to think about the predicates they write from DB2’s perspective instead of what makes sense to humans.
Many of us are familiar with the ability to call a DB2 for z/OS service via REST API and z/OS Connect. While this seams highly attractive, many DB2 professionals are a bit uncomfortable with including an additional product, z/OS Connect, in the mix. In addition to that, the DB2 Adaptor for z/OS Con
DB2 Analytics Accelerator V5.1 is available now.
Version 5.1 of DB2 Analytics Accelerator opens up a new dimension of analytical processing by introducing accelerator-only tables and in-database analytics.
The concepts in this article were incorporated into the DB2 Native SQL stored procedures from my own experience in using the log4net utility with several C# applications. My logging examples consist of 3 basic components, and an example on how to add the logging to a DB2 Native SP.
We continue our series on DB2 for z/OS Application Development in this post by Emil Kotrc.