DB2 Workload Manager (WLM) queries are directed to the db2RegClass.Default subclass and not being split between the other subclasses.

Technote (troubleshooting)


Problem(Abstract)

DB2 Workload Manager (WLM) queries are directed to the db2RegClass.Default subclass and not being split between the db2RegClass.Trivial, db2RegClass.Medium and db2RegClass.Complex subclasses.

Symptom

Sometimes 100% of queries/workload to the db2RegClass.Default subclass and not being split between trivial, medium, and complex subclasses.


In the example below, the wlmstat command shows 100% of the workload going to db2RegClass.Default and none to the db2RegClass.Trivial, db2RegClass.Medium and db2RegClass.Complex subclasses.

CLASS CPU MEM DKIO
Unclassified 0.00 10.51 0.10
Unmanaged 0.00 13.38 0.00
Default 91.30 54.08 0.02
Shared 0.00 1.47 0.00
System 0.40 4.67 0.21
db2DefaultSystem 0.04 0.00 0.00
db2RegClass 8.07 0.01 0.00
db2RegClass.Default 100.00 100.00 -
db2RegClass.Shared 0.00 0.00 -
db2RegClass.Trivial 0.00 0.00 -
db2RegClass.Medium 0.00 0.00 -
db2RegClass.Complex 0.00 0.00 -

db2HiClass 0.00 0.01 0.00
TOTAL 99.81 70.75 0.33



Resolving the problem

To resolve the issue, you will need to set up the /etc/wlm/db2config/rules file as follows:

System - root - - - -
db2HiClass - - - - - _db2HiClass
db2RegClass - - - - - _db2RegClass
db2RegClass - - - - - _db2RegClass.Trivial
db2RegClass - - - - - _db2RegClass.Medium
db2RegClass - - - - - _db2RegClass.Complex
db2DefaultSystem - - - - - _db2DefaultSystem
Default - - - - - -

Next reset the configuration using the following command:
wlmcntrl -u


The workload should now be spread across the subclasses.

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

DB2 for Linux, UNIX and Windows

Software version:

9.7, 10.1

Operating system(s):

AIX, Linux

Software edition:

Advanced Enterprise Server, Enterprise Server

Reference #:

1615532

Modified date:

2012-11-28

Translate my page

Machine Translation

Content navigation