|
Problem IC77613
|
Status: Closed |
DB2LOOK RETURNING INCORRECT VALUES FOR WLM SERVICE CLASSES SYSDEFAULTSYSTEMCLASS AND SYSDEFAULTMAINTENANCECLASS |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - 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 Version 9.7 Fix Pack 7 *
**************************************************************** |
| Local Fix: |
Manually update the ALTER DDL statements generated by DB2LOOK
for WLM service classes. |
| available fix packs: |
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
First fixed in Version 9.7 Fix Pack 7 |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC88359
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 19.07.2011
17.12.2012
17.12.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP7
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.7
|
 |
