Level: Intermediate Burt L. Vialpando (burt.vialpando@us.ibm.com), Certified I/T Specialist - DB2 Migrations, IBM
Vikram S. Khatri (vikram@zinox.com), Certified Consulting I/T Specialist, IBM
13 Aug 2009
This tutorial provides a series of exercises using IBM® DB2® Workload
Manager (WLM).
By following these exercises, you should become familiar with the DB2 WLM feature and
start to see the immediate value you can obtain from its use.
For those new to WLM, the tutorial serves as an easy starting point for you to begin using
WLM right out of the box.
For experienced WLM users, the tutorial gives you a hands-on introduction to new WLM
functions introduced in DB2 9.7.
Before you start
Learn what to expect from this tutorial, and how to get the most out of it.
About this tutorial
This tutorial takes a simple approach to implementing WLM.
The intent is to make the basic functionality easy to understand.
Objectives
This tutorial teaches you how to:
- Understand the DB2 WLM objects and their relationships
- Use the new DB2 9.7 BUFFERPOOL PRIORITY in a service class definition
- Use the new DB2 9.7 connection attribute wildcards in a workload definition
- Use the new DB2 9.7 ADDRESS connection attribute in a workload definition
- Use a threshold with the new DB2 9.7 CPUTIME metric
- Use a service subclass threshold to do new DB2 9.7 service subclass remapping (also known as priority aging)
- Use a new DB2 9.7 WLM sample script to build a tiered service class environment
- Use a WLM procedure to set client information
- Use WLM functions to monitor your environment — short term
- Use WLM event monitors to monitor your environment — long term
- Understand remapping metrics
Prerequisites
The tutorial is intended to be used by Data Base Administrators
(DBAs) who are experienced using DB2 but may be new to the topic of using the
DB2 WLM functions.
System requirements
To perform the WLM exercises, you need to have
access to DB2 Enterprise Edition for Linux®, UNIX®, and
Windows® (DB2 ESE) Version 9.7.
See the Resources section for a link you can use
to download a free trial version of IBM DB2 for Linux, UNIX, and Windows.
The trial version includes DB2 ESE.
The exercises are described and shown in a
Windows environment.
This is done simply for ease of use purposes;
you can apply the same concepts using a Linux or UNIX system.
The exercises use the files contained in the WLMLab.zip download file included with this
tutorial.
Download WLMLab.zip from the download section and extract
the files onto your Windows C:\ drive.
| 
