”. 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, 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.