DB2 FOR LUW / DB2FORLUW / 970 - DB2

Command "export DB2LIBPATH" is executed from db2profile to point 
to ${jdkpath?}/jre/lib/ppc64 in response to a JDK update on AIX. 
However, this value will override the DB2LIBPATH set at 
instance level. 
 
$ db2set -all 
[e] DB2LIBPATH=/opt/IBM/sqllib/java/jdk64/jre/lib/ppc64 
[i] DB2LIBPATH=/mydirectory/lib 
 
With above entries, /mydirectory/lib will be overriden which 
leads to "library not found" error SQL0444 rc=4 for routines.

**************************************************************** 
* USERS AFFECTED:                                              * 
* all AIX users                                                * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* any value of DB2LIBPATH set via db2set will be ignored.      * 
* This normally results in libraries not being found at        * 
* runtime for stored procedures or other user extensions to    * 
* DB2.                                                         * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to DB2 v9.7 Fixpack 4.                                * 
**************************************************************** 
EXPORT DB2LIBPATH " FROM DB2PROFILE CAUSES LIBPATH BROKEN 
 
Command "export DB2LIBPATH" is executed from db2profile to point 
 
to ${jdkpath?}/jre/lib/ppc64 in response to a JDK update on AIX. 
However, this value will override the DB2LIBPATH set at 
instance level. 
 
$ db2set -all 
[e] DB2LIBPATH=/opt/IBM/sqllib/java/jdk64/jre/lib/ppc64 
[i] DB2LIBPATH=/mydirectory/lib 
 
With above entries, /mydirectory/lib will be overriden which 
leads to "library not found" error SQL0444 rc=4 for routines.

Manually run "export DB2LIBPATH=/mydirectory/lib" and recycle 
instance.

DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

fixed in DB2 v9.7 Fixpack 4.

keiner bekannt / siehe Local-Fix

Vorgänger  : APAR is sysrouted TO one or more of the following: IC78442 IC78530 IC78531 
Nachfolger : 

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

09.11.2010
12.05.2011
08.09.2011

9.7.FP4