Articles & Content

Archives

C13 - What are you waiting for?

Topic: DB2 for LUW

Subtopic: 2014



Often we suspect a query is waiting on something because it has a long execution time, but a small CPU time. Is it a lockwait, is it a long compilation time, is it waiting on I/O or something else? It is impossible to resolve the underlying condition until you understand what is wrong. I will show you how to determine what it was waiting on. This presentation will give high level information on time-spent elements. A deep dive into lockwait analysis will be done using various diagnostic tools. Some tools that will be covered are MONREPORT, MON_GET_PKG_CACHE_STMT, MON_LOCKWAITS and the locking event monitor (and queries to read that data). Usage of several configuration parameters including mon_lockwait, mon_lw_thresh, mon_deadlock, mon_locktimeout, locktimeout and maxlocks will be discussed.



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.