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 IC92293 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 / A10 - 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 Problem Description above.                               * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 10.1 Fix Pack 3.                      * 
****************************************************************
Local Fix:
N/A
available fix packs:
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 Version 10.1 Fix Pack 3.
Workaround
not known / see Local fix
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC96561 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
14.05.2013
08.10.2013
08.10.2013
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
10.1.0.3 FixList
10.1.0.3 FixList