Articles & Content

Archives

Capturing Outlaw Queries With WLM (D15)

Topic: DB2 for LUW

Subtopic: 2010



DATE: 2010-11-11 (08:30 - 09:30)
SPEAKERS: Paul Bird (IBM)

Workload management features, introduced in IBM DB2 9.5 and enhanced in DB2 9.7, allow you to detect and isolate undesirable behaviours in the database. This session will cover a variety of common scenarios and show how best to address each one using workload management. Particular emphasis will be given to how to determine which recommended technique is applicable for each case.

EXP. LEVEL: Beginner

OBJECTIVES:

Overview of key concepts for WLM in DB2 LUW.

Learn what features WLM offers for detecting and dealing with runaway queries.

Understand how to use WLM to categorize database activities.

Learn how to apply thresholds effectively to automatically stop runaway queries.

Learn how to track down and kill disruptive queries in the wild.



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.