Articles & Content
Topic: 2009 EU
Subtopic: DB2 for LUW
DATE: 2009-10-7 (08:30 - 09:30)
SPEAKERS: Alexander Kopac (Home Depot)
Do you as a customer wait 15 seconds for a web application to fail to respond and then move on to the next competitor? Timeouts, Lock Waits, Deadlocks, Lock Escalations & Application & Database "Design Flaws" routinely cause Application Locking & performance snags. Here are real life customer experiences that visit issues such as selecting data types, filtering thru mountains of monitoring parameters/tuning knobs, & viewing various logs. We'll see the "pick of the litter" performance parameters to investigate, see simple techniques for predicting constraint issues, & RI juggernauts. Learn how to spot index/log bottlenecks, "lack of preparation" issues, rollback/commit snags, and look for the "common/unnecessary" application SQL miscodes.
EXP. LEVEL: Beginner
Finding performance bottleneck issues: Locks, Deadlocks, Escalations, Waits & Design Flaws
Looking for potential snags: Triggers, Constraints, and Men's Disease (Fear of Commitment) Oh My!
Lock Reduction techniques & calculating how much lock contention is too much
Tuning Knobs and Parameters in the Toolbag
Tricks & Techniques
This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!Click to Download
NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.