Articles & Content

Archives

Capturing Outlaw Queries with WLM (D14)

Topic: 2009 EU

Subtopic: DB2 for LUW



DATE: 2009-10-7 (17:00 - 18:00)
SPEAKERS: Paul Bird (IBM)

Workload management features, new in IBM DB2 9.5, allow you to detect and isolate undesirable activities 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: Intermediate

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.



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!

Download File
Click to Download

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