Since the beginning, I/O has been one of the main determining factors for overall performance. I/O can easily surpass all other considerations, particularly if an SQL statement asks for a very large result or a missing index causes the scan of a very large table.
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.
From existing concepts that we were scared to test ourselves, to new technology that is finding its place into our daily jobs, we have you covered so you'll be able to learn about the Db2 in a consistent and smarter way. Check out our monthly content and stay tuned to our Premium Content updates.