New wlm activity threshold in DB2 helps to catch poorly performing queries

Thought I would call out a few WLM features that shipped in DB2 that might be of interest...

Since DB2 9.5, DB2 has offered the ACTIVITYTOTALTIME threshold to track the amount of "clock time" that an activity spent within DB2; this threshold starts from the time the activity reached DB2 until the time it finished executing and included any time spent waiting in WLM concurrency queues before execution actually started.

This threshold is very useful when you want to track/control the end-user experience in terms of response time from DB2 but it is less effective when you have active concurrency queuing going on and are trying to track badly performing activities. Because this threshold includes time spent queuing not just executing, you can get false positives as you try to capture examples of the target statement's execution.

The new ACTIVITYTOTALRUNTIME threshold introduced in DB2 alleviates this issue by only tracking the total "clock time" actually spent executing.

Recent Stories
How to influence Db2 through RFE Voting: Security

How can I stay current on what fix packs are available for each Db2 release, what Hiper APARs might be out there, and if there are any security vulnerabilities that I should know about?

Things to consider when considering Db2 Native Encryption