DB2 - Problem description
Problem IC96561 | Status: Closed |
WLM CONFIG WIZARD RETURNS WLM51018E AND INCORRECT OBJECT IDS ARE ADDED TO SYSIBM.SYSHISTOGRAMTEMPLATEUSE AFTER MIGRATING TO V10 | |
product: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problem description: | |
When upgrading from v97 to v10, WLM Configuration Wizard fails to start with error WLM51018E. The error is a result of DB2 adding incorrect object IDs in SYSIBM.SYSHISTOGRAMTEMPLATEUSE: db2 "EXPORT TO SAMPLE_HISTOGRAMTEMPLATEUSE.txt OF DEL MODIFIED BY NOCHARDEL SELECT * FROM "SYSCAT"."HISTOGRAMTEMPLATEUSE" ORDER BY TEMPLATEID" SAMPLE_HISTOGRAMTEMPLATEUSE.txt: SYSDEFAULTHISTOGRAM,1,U,b,3080198,,,,, SYSDEFAULTHISTOGRAM,1,U,b,3014662,,,,, SYSDEFAULTHISTOGRAM,1,U,b,2949126,,,,, SYSDEFAULTHISTOGRAM,1,U,b,2883590,,,,, SYSDEFAULTHISTOGRAM,1,U,b,2818054,,,,, SYSDEFAULTHISTOGRAM,1,U,b,2752518,,,,, SYSDEFAULTHISTOGRAM,1,U,b,2686982,,,,, SYSDEFAULTHISTOGRAM,1,U,b,2555910,,,,, SYSDEFAULTHISTOGRAM,1,U,b,2424838,,,,, etc. "b" means service class In these entries the name of the Service Class is empty and the object ID, 3080198 for example, is a very high number. An example of an expected entry is: SYSDEFAULTHISTOGRAM,1,R,b,41,SYSDEFAULTSUBCLASS,TOAD_SESSION,,, | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to 10.5.0.3 * **************************************************************** | |
Local Fix: | |
N/A | |
available fix packs: | |
DB2 Version 10.5 Fix Pack 3 for Linux, UNIX, and Windows | |
Solution | |
Problem Fixed In 10.5.0.3 | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 02.10.2013 10.03.2014 10.03.2014 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) | |
10.5.0.3 | |
10.5.0.3 |