Avoiding L2 Performance PMRs

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. This presentation will walk through a methodology for avoiding these issues.