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

A 32-BIT CLI APPLICATION RUNNING WITH DB2 64-BIT ON AIX FAILS WITH ILLEGAL
INSTRUCTION ERROR

product:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problem description:
A 32-bit CLI application running with DB2 64-bit on AIX fails 
with illegal instruction error when attempting to connect to the 
database. 
 
db2diag.log might contain below errors: 
 
2013-02-21-22.47.51.957528-300 I14746C1399          LEVEL: Error 
PID     : 17432734             TID : 1              PROC : t_97 
INSTANCE: db2inst              NODE : 000 
HOSTNAME: hostname1 
EDUID   : 1 
FUNCTION: DB2 Common, OSSe, OSSHLibrary::load, probe:80 
MESSAGE : ECF=0x90000076=-1879048074=ECF_LIB_CANNOT_LOAD 
          Cannot load the specified library 
DATA #1 : Hex integer, 4 bytes 
0x00000009 
DATA #2 : String, 39 bytes 
/opt/ibm/db2/v10/lib32/libdb2clixml4c.a 
CALLSTCK: (Static functions may not be resolved correctly, as 
they are resolved to the nearest symbol) 
  [0] 0xD21FA5CC oss_log__FP9OSSLogFacUiT2UlT2N34lPPc + 0xEC 
  [1] 0xD21FA498 ossLog + 0xB8 
  [2] 0xD21FD098 load__11OSSHLibraryFPCcUl + 0x2F8 
  [3] 0xD64ACE04 CLI_coLoadXml4cLib + 0x3A4 
  [4] 0xD648F138 loadXml__9rccConfigFP5sqlcaPc + 0x2D8 
  [5] 0xD6493758 
getAltSrvrFromCache__10rccDBEntryFP7rccListP5sqlca + 0x1D8 
  [6] 0xD6491FC8 
getEffectiveAlternateSrvList__10rccDBEntryFPcPbPP7rccListP5sqlca 
+ 0x508 
  [7] 0xD5FA99CC sqleUCappConnect + 0x4A6C 
  [8] 0xD6552FAC 
CLI_sqlConnect__FP15CLI_CONNECTINFOP5sqlcaP19CLI_ERRORHEADERINFO 
+ 0xD8C 
  [9] 0xD6704BD0 
SQLConnect2__FP15CLI_CONNECTINFOPUcsT2T3T2T3T2T3Uc + 0x6F0 
  [10] 0xD66F55A8 
SQLDriverConnect2__FP15CLI_CONNECTINFOPvPUcsT3T4PsUsUcT9P19CLI_E 
RRORHEADERINFO + 0x1AC8 
  [11] 0xD67097B0 SQLDriverConnect + 0x410 
  [12] 0x10000934 main + 0x274 
  [13] 0x10000190 __start + 0x68 
 
2013-02-21-22.47.51.958368-300 I16146C1428          LEVEL: Error 
PID     : 17432734             TID : 1              PROC : t_97 
INSTANCE: db2inst              NODE : 000 
HOSTNAME: hostname1 
EDUID   : 1 
FUNCTION: DB2 Common, OSSe, OSSHLibrary::load, probe:90 
MESSAGE : ECF=0x90000076=-1879048074=ECF_LIB_CANNOT_LOAD 
          Cannot load the specified library 
DATA #1 : String, 109 bytes 
Could not load module 
/opt/ibm/db2/v10/lib32/libdb2clixml4c.a(shr.o). 
System error: No such file or directory 
CALLSTCK: (Static functions may not be resolved correctly, as 
they are resolved to the nearest symbol) 
  [0] 0xD21FA5CC oss_log__FP9OSSLogFacUiT2UlT2N34lPPc + 0xEC 
  [1] 0xD21FA498 ossLog + 0xB8 
  [2] 0xD21FD0E0 load__11OSSHLibraryFPCcUl + 0x340 
  [3] 0xD64ACE04 CLI_coLoadXml4cLib + 0x3A4 
  [4] 0xD648F138 loadXml__9rccConfigFP5sqlcaPc + 0x2D8 
  [5] 0xD6493758 
getAltSrvrFromCache__10rccDBEntryFP7rccListP5sqlca + 0x1D8 
  [6] 0xD6491FC8 
getEffectiveAlternateSrvList__10rccDBEntryFPcPbPP7rccListP5sqlca 
+ 0x508 
  [7] 0xD5FA99CC sqleUCappConnect + 0x4A6C 
  [8] 0xD6552FAC 
CLI_sqlConnect__FP15CLI_CONNECTINFOP5sqlcaP19CLI_ERRORHEADERINFO 
+ 0xD8C 
  [9] 0xD6704BD0 
SQLConnect2__FP15CLI_CONNECTINFOPUcsT2T3T2T3T2T3Uc + 0x6F0 
  [10] 0xD66F55A8 
SQLDriverConnect2__FP15CLI_CONNECTINFOPvPUcsT3T4PsUsUcT9P19CLI_E 
RRORHEADERINFO + 0x1AC8 
  [11] 0xD67097B0 SQLDriverConnect + 0x410 
  [12] 0x10000934 main + 0x274 
  [13] 0x10000190 __start + 0x68 
 
 
Note: This issue happens only with 32-bit CLI applications using 
DB2 64-bit on AIX
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* CLI application users on AIX OS                              * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 V10.1 FP 3 or higher.                         * 
****************************************************************
Local Fix:
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 V10.1 FP3
Workaround
not known / see Local fix
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC95532 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
02.05.2013
17.10.2013
17.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