Before you start
Learn what to expect from this tutorial, and how to get the most out of it.
This tutorial takes a simple approach to implementing WLM. The intent is to make the basic functionality easy to understand.
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
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.
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.