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:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.