DB2 10.5 for Linux, UNIX, and Windows

Tutorial for DB2 workload management

The exercises in this tutorial were designed to provide you with a hands-on introduction to DB2® workload management. Each exercise highlights one or more of the workload management features available with DB2 workload management.

These exercises provide some guidance for using DB2 workload management features which you can adapt for your own purposes, but you should note that the initial configuration you chose for your own data server may differ and should be based on your specific workload management objectives.

Before you begin

This tutorial is designed to be run against the SAMPLE database and, unless noted otherwise, requires DBADM or WLMADM authority (or SQLADM authority if only the COLLECT ACTIVITY DATA clause is specified). You should also start the instance and activate the SAMPLE database before continuing:

db2start
db2 activate db sample

Some of the command and query statements shown in these exercises are quite long. You can find most of these statements in the text file wlm-tutorial-steps.txt, which you can copy from when working through the exercises. The scripts representing the workloads that are required for the different exercises are also included.

Both wlm-tutorial-steps.txt and the workload scripts can be found here.