IDUG EMEA 2024

Dive into the fundamentals of Db2 performance tuning and see firsthand how tuning not only addresses bottlenecks but can optimize application performance. In this beginner-friendly session, we’ll introduce the basics of Db2 performance tuning and then walk together through various advanced, yet easily understandable, optimization techniques. We’ll also explore the essentials of Db2's index navigation, the value of getpages and I/Os, and the importance that statistics, filters, and predicates have on determining the optimal access path for efficient queries. Leave with a firm grasp on the ways to identify and resolve performance issues, leading to faster query responses and more efficient resource utilization. Even better, leave as a Db2 performance expert, with practical ways to enhance the speed, reliability, and user experience of your applications.
The objectives cover a wide spectrum, starting with understanding how Db2 navigates an index and tablespace, and the performance attributes associated with various access paths. Readers will explore the impact of clustered and unclustered indexes on performance and comprehend the significance of getpages (logical reads) and I/Os (physical reads) in influencing system efficiency.
Moreover, this session elucidates the role of statistics, filter factors, and predicates in determining the optimal access path for queries, providing valuable insights into the decision-making process. Furthermore, it introduces potential solutions to common performance issues, equipping beginners with the foundational knowledge and problem-solving skills essential for embarking on the journey of Db2 performance optimization.