home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

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
DB2 Version 10.5 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 9 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 FixList
10.5.0.3 FixList