Preventing Performance Pitfalls in DB2
Project and Program:
Information Management,
Database
Tags:
Proceedings,
2015,
SHARE in Seattle 2015
Root cause analysis of presumed, or actual DB2 performance issues can be quite tricky in today's diverse environments. Everything from CEC capacity, LPAR utilization, real/virtual storage, WLM settings, PARMLIB members, and DB2 parameters can play a part in performance degradation. Wouldn't it be nice if there were some tools (no-charge ones at that) which could quickly guide you in the direction of the root cause? Not just in text format but with graphs and trending lines that can visually depict the bottle neck and help educate management and colleagues. Many man hours have been wasted studying the effects of a system slowdown instead of the cause due to narrow scopes of reference. This presentation will do through tools and methodologies to help you narrow down what is impacting the system so that you can take action, or engage the resources needed to eliminate the issue. Actual customer performance data and scenarios from international customers in the banking, insurance, energy, and retail industry are all shown and discussed. The resolution and measures taken to avoid recreating these scenarios are key takeaways from this discussion.-Adrian Burke-IBM Corporation
Back to Proceedings File Library