If you have a 64-bit DB2 server and defined and have
successfully run a 32-bit stored procedure, the
instance may crash the next time the same stored procedure is
executed if this second time the execution of this stored
procedure returns error SQL0444N.
In your db2diag.log, you may see messages like :
2013-10-11-07.25.12.083045+120 E31307G610 LEVEL: Error
(OS)
PID : 11250 TID : 4122990288 PROC :
db2fmp32 (
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
APPID : *LOCAL.db2inst1.130911035007
FUNCTION: DB2 UDB, oper system services, sqloLoadModule,
probe:190
CALLED : OS, -, dlopen
DATA #1 : Library name or path, 40 bytes
/home/db2inst1/sqllib/function/spserver
DATA #2 : shared library load flags, PD_TYPE_LOAD_FLAGS, 4 bytes
256
DATA #3 : String, 72 bytes
libctest.so.1: cannot open shared object file: No such file or
directory
2013-10-11-07.25.12.385466+120 I31918E1318 LEVEL: Severe
PID : 31537 TID : 46987734935872 PROC :
db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
APPHDL : 0-32213 APPID:
*LOCAL.db2inst1.130911035007
AUTHID : DB2INST1
EDUID : 21154 EDUNAME: db2agent (DPWAG) 0
FUNCTION: DB2 UDB, SQO Memory Management, sqlofmblkEx, probe:40
MESSAGE : Attempted to free NULL pointer.
CALLSTCK: (Static functions may not be resolved correctly, as
they are resolved to the nearest symbol)
[0] 0x00002AAAAB827260 pdLog + 0x398
[1] 0x00002AAAAE0FC530 sqlofmblkEx + 0x96E
[2] 0x00002AAAAC7CFE23
_Z42sqler32BitLibraryRemoveFromBucketHashTableP26SQLER_32BIT_LIB
_HASH_TABLEPh + 0xBF
[3] 0x00002AAAAB9A9A6F
_Z24sqlerInvokeFencedRoutineP13sqlerFmpParms + 0x1639
[4] 0x00002AAAABF27835 _Z9sqlricallP8sqlrr_cb + 0xF4D
[5] 0x00002AAAAE131CC4
_Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm + 0x13E
[6] 0x00002AAAABE40056
_Z29sqlrr_process_execute_requestP8sqlrr_cbib + 0x1AA4
[7] 0x00002AAAABE38466
_Z13sqlrr_executeP14db2UCinterfaceP9UCstpInfo + 0x118
[8] 0x00002AAAABA4C921
_Z19sqljs_ddm_excsqlsttP14db2UCinterfaceP13sqljDDMObject + 0x4E7
[9] 0x00002AAAAE0C5435
_Z21sqljsParseRdbAccessedP13sqljsDrdaAsCbP13sqljDDMObjectP14db2U
Cinterface + 0x7D
2013-10-11-07.25.12.762127+120 I34459E526 LEVEL:
Warning
PID : 31537 TID : 46987734935872PROC :
db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
APPHDL : 0-32213 APPID:
*LOCAL.db2inst1.130911035007
AUTHID : DB2INST1 EDUID : 21154
EDUNAME: db2agent (DPWAG) 0
FUNCTION: DB2 UDB, RAS/PD component,
pdEDUIsInDB2KernelOperation, probe:600
DATA #1 : String, 44 bytes
sqloCrashOnCriticalMemoryValidationFailure
DATA #2 : String, 4 bytes
sqlo |
