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

WHEN A SCRIPT RUNS IN TASK CENTRE, EXTRA SLASH ADDED TO LIBPATH CAUSING
INSTANCE ENV SWITCH USING DB2PROFILE TO FAIL

product:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problem description:
A script runs in Task Centre can use db2profile to switch 
instance environment. For example, 
. /home2/db2inst23/sqllib/db2profile 
where db2inst23 can be an instance on a different db2 level. 
The problem is an extra slash is added to env variable LIBPATH 
when the script runs. So it has 
value something like the following : 
/home2/db2ins26/sqllib//lib64:/home2/db2ins26/sqllib/function:/h 
ome2/db2ins26/sqllib/function/unfenced::/home2/db2ins26/sqllib/j 
ava/jdk64/jre/bin/classic:/home2/db2ins26/sqllib/java/jdk64/jre/ 
bin:/home2/db2ins26/sqllib/java/jdk64/jre/lib:/home2/db2ins26/sq 
llib/java/jdk64/lib:/home2/db2ins26/sqllib/java/jdk64/jre/lib/pp 
c64:/home2/db2ins26/sqllib/java/jdk64/jre/bin/j9vm::/home2/db2da 
s/das/lib:/home2/db2das/das/function: 
 
db2profile cannot recognize the extra slash and therefore after 
calling db2profile, the path is still included in LIBPATH: 
$ cat libpath.after 
/home2/db2ins26/sqllib//lib64:/home2/db2ins26/sqllib/function:/h 
ome2/db2ins26/sqllib/function/unfenced:/home2/db2ins26/sqllib/ja 
va/jdk64/jre/bin/classic:/home2/db2ins26/sqllib/java/jdk64/jre/b 
in:/home2/db2ins26/sqllib/java/jdk64/jre/lib:/home2/db2ins26/sql 
lib/java/jdk64/lib:/home2/db2ins26/sqllib/java/jdk64/jre/lib/ppc 
64:/home2/db2ins26/sqllib/java/jdk64/jre/bin/j9vm:/home2/db2das/ 
das/lib:/home2/db2das/das/function:/home2/db2ins23/sqllib/lib64 
 
This is causing the wrong libraries being loaded after the 
instance env switch, ie. libraries from the previous instance 
(db2ins26 in this case) are loaded, instead of 
the libraries from the instance to switch to(db2ins23 in this 
case).
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 10.1 Fix Pack 4                       * 
****************************************************************
Local Fix:
In the script, manually add the correct library path of the 
instance to switch to. For example: export 
LIBPATH=/home2/db2ins23/sqllib/lib64:$LIBPATH
available fix packs:
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows

Solution
First fixed in Version 10.1 Fix Pack 4
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
26.09.2013
02.06.2014
02.06.2014
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
10.1.0.4 FixList