|
Problem IC88359
|
Status: Closed |
DB2LOOK RETURNING INCORRECT VALUES FOR WLM SERVICE CLASSES SYSDEFAULTSYSTEMCLASS AND SYSDEFAULTMAINTENANCECLASS |
| product: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problem description: |
When executing DB2LOOK to extract the DDL for WLM service
classes, the default values are being returned for columns AGENT
PRIORITY, PREFETCH PRIORITY or BUFFERPOOL PRIORITY in the
service classes SYSDEFAULTSYSTEMCLASS and
SYSDEFAULTMAINTENANCECLASS although they had been previously
updated to a numerical value.
Ex:
db2 "select varchar(SERVICECLASSNAME,30) as service_class_name,
AGENTPRIORITY, PREFETCHPRIORITY, BUFFERPOOLPRIORITY from
syscat.serviceclasses"
SERVICE_CLASS_NAME ENABLED AGENTPRIORITY
PREFETCHPRIORITY BUFFERPOOLPRIORITY
------------------------------
------------------------------ -----------------------
-------------------------
SYSDEFAULTSYSTEMCLASS -20
H H
SYSDEFAULTMAINTENANCECLASS -19
H H
DB2LOOK Output:
ALTER SERVICE CLASS "SYSDEFAULTSYSTEMCLASS"
AGENT PRIORITY DEFAULT
PREFETCH PRIORITY DEFAULT OUTBOUND CORRELATOR NONE
BUFFERPOOL PRIORITY DEFAULT
COLLECT REQUEST METRICS NONE
ENABLE;
ALTER SERVICE CLASS "SYSDEFAULTMAINTENANCECLASS"
AGENT PRIORITY DEFAULT
PREFETCH PRIORITY DEFAULT OUTBOUND CORRELATOR NONE
BUFFERPOOL PRIORITY DEFAULT
COLLECT REQUEST METRICS NONE
ENABLE;
This APAR will correct the output of the DB2LOOK command related
to WLM service classes. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 V10 Fix Pack 2 *
**************************************************************** |
| Local Fix: |
Manually update the ALTER DDL statements generated by DB2LOOK
for WLM service classes. |
| available fix packs: |
DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
|
| Solution |
First Fixed in DB2 V10 Fix Pack 2 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 17.11.2012
17.12.2012
17.12.2012 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.2
|
 |
| 10.5.0.2
|
|
