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 IC68854 Status: Closed

DB2LOOK GIVE INCORRECT OUTPUT WHICH WILL RESULT IN SYNTAX ERROR

product:
DB2 FOR LUW / DB2FORLUW / 910 - DB2
Problem description:
If I use SYSPROC.SET_ROUTINE_OPTS function during the creation 
of your user definede routines, db2look will incorrectly output 
an extra "S" to the "ROUTINE" of "SET_ROUTINE_OPTS": 
 
 
Per example, db2look will output: 
 
CALL SYSPROC.SET_ROUTINES_OPTS('ISOLATION UR DATETIME ISO'); 
 
Where it should be : 
CALL SYSPROC.SET_ROUTINE_OPTS('ISOLATION UR DATETIME ISO');
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All version 9.1 and 9.5                                      * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See error description above                                  * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* this issue is fixed in version 9.5 FP7 and all version 9.7.  * 
****************************************************************
Local Fix:
Update the db2look output manually.
Solution
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
26.05.2010
31.05.2010
31.05.2010
Problem solved at the following versions (IBM BugInfos)
9.5.FP7,
9.7.
Problem solved according to the fixlist(s) of the following version(s)