DB2 - Problem description
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 | |
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 |