SHARE in Seattle

16303: Preventing Performance Pitfalls in DB2

Monday, March 2, 2015: 4:30 PM-5:30 PM
Cedar (Level 2) (Sheraton Seattle)
Speaker: Adrian Burke(IBM Corporation)
Handouts
  • Avoiding Performance Pitfalls in DB2 (1.2 MB)
  • 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.

    Tracks: DB2 and Performance/Capacity Planning
    Share |




    See more of Project: Database
    See more of Program: Information Management