Articles & Content


DB2 LUW - Diagnosing & Curing? Lock, Wait & Performance Bottlenecks (D05)

Topic: 2011 EMEA

Subtopic: DB2 for LUW

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.

Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.