”. Overthinking and trying to predict Db2 performance is a slippery slope, and so rather than “thinking” about Db2 performance why not have the database tell you how it will perform. The key to this is the Db2 accounting trace, and subsequent Db2 accounting reports. The accounting reports are useful
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.
Read about a user experience of writing a first Zowe Desktop App.