DB2 - Problem description
Problem IC95667 | 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 / A50 - 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.5 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 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows | |
Solution | |
First fixed in Version 10.5 Fix Pack 4 | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 02.09.2013 08.09.2014 08.09.2014 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) | |
10.5.0.4 |