DB2 FOR LUW / DB2FORLUW / 970 - DB2

If you have a 64-bit DB2 server and you have defined and 
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 when the stored 
procedure fails with error SQL0444N : 
 
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

**************************************************************** 
* USERS AFFECTED:                                              * 
* 32-bit stored procedures on a DB2 LUW 64-bit server          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 9.7 FP10 or later                             * 
****************************************************************

N/A

The problem was first fixed in DB2 9.7 FP10

not known / see Local fix

forerunner  : APAR is sysrouted TO one or more of the following: IC98258 IC98289 
follow-up : 

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

18.10.2013
22.12.2014
22.12.2014

9.7.FP10