In this article, Peter Vanroose shares his story on porting a COBOL application to Db2 Stored Procedures, including his approach and lessons learned in the process.
In this article, inspired from his presentation in IDUG EMEA 2019, Pawel Hryb talks on possibilities and strategies when doing complex SQL tuning in Db2 for z/OS: Where to begin, how to dissect a complex query, sources of information to try and how to proceed when you need a deeper investigation.
In this article, Brian Laube shows how we can solve a real-life performance problem by copying access path information from one environment to another one and then using it as an optimization hint.
In this article, we learn from a war story on how some misconceptions around Real Memory in z/OS and Db2 Buffer Pools can severely affect your environment, and how a few checks and simple calculations can give us a better picture.
Anomaly Detection is a hot topic these days, but you don't need to do coding to start with this. In this article, we'll do Anomaly Detection using only SQL statements new to Db2.