Troubleshooting Db2 slowdown

Bharat Goyal, IBM

Download PDF

Have you ever experienced the frustration of a seemingly well-functioning system suddenly slowing down without any apparent changes?

The culprit may lie in the constrained computing resources allocated to Db2.Resolving one issue within Db2 can inadvertently give rise to problems elsewhere, as the limited resources available for database workloads pose a delicate balance. Efficient utilization of resources, such as server memory, is crucial for optimal Db2 performance. This presentation will guide you through the process of troubleshooting performance issues, helping you identify bottlenecks and optimize resource allocation for a smoother Db2 experience. Additionally, we will delve into concurrent query issues, highlighting how to identify the top CPU consumers and providing insights on debugging these challenges effectively.