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

NON-THREADED STORED PROCEDURE COMPILED IN 32 BIT MODE MAY CAUSE INSTANCE
CRASH

product:
DB2 FOR LUW / DB2FORLUW / 980 - DB2
Problem description:
Non-threaded stored procedure compiled in 32 bit mode may cause 
an instance crash. 
db2diag.log has the following entry. 
 
2011-08-01-09.38.30.729525-300 I46180061E1463      LEVEL: Severe 
(OS) 
PID     : 9947                 TID  : 46963672213824PROC : 
db2sysc 0 
INSTANCE: db2inst1             NODE : 000          DB   : xxxxx 
APPHDL  : 0-25429              APPID: 
10.1.2.82.2424.110801111830 
AUTHID  : xxxxxx 
EDUID   : 34964                EDUNAME: db2agent (xxxxx) 0 
FUNCTION: DB2 UDB, SQO Memory Management, 
sqloMemDetachFromSegments, probe:100 
MESSAGE : ZRC=0x820F0002=-2112946174=SQLO_INV_MEM "Invalid 
memory addr" 
          DIA8561C A invalid memory block was encountered. 
CALLED  : OS, -, shmdt                            OSERR: EINVAL 
(22) 
DATA #1 : unsigned integer, 8 bytes 
0 
DATA #2 : unsigned integer, 8 bytes 
1 
DATA #3 : Pointer, 8 bytes 
0x00002ab742bd2000 
CALLSTCK: 
  [0] 0x00002AAAAB7D7E77 pdLogSysRC + 0x2AD 
  [1] 0x00002AAAABD0F509 
/home/db2insp1/sqllib/lib64/libdb2e.so.1 + 0x1242509 
  [2] 0x00002AAAABD0EFC8 
/home/db2insp1/sqllib/lib64/libdb2e.so.1 + 0x1241FC8 
  [3] 0x00002AAAABD0E9B4 sqlofshr + 0x206 
  [4] 0x00002AAAAB86215B 
_Z13sqlccFreeIPCsP18SQLCC_INITSTRUCT_Tcc + 0x371 
  [5] 0x00002AAAAC6BABCC 
/home/db2insp1/sqllib/lib64/libdb2e.so.1 + 0x1BEDBCC 
  [6] 0x00002AAAAC6BAE91 
_Z23sqlerRemoveAllIPCforRowP11sqlerFmpRowb + 0x2BF 
  [7] 0x00002AAAAC6BBA77 
/home/db2insp1/sqllib/lib64/libdb2e.so.1 + 0x1BEEA77 
  [8] 0x00002AAAAC6BB8C3 
/home/db2insp1/sqllib/lib64/libdb2e.so.1 + 0x1BEE8C3 
  [9] 0x00002AAAAC6BC61C 
/home/db2insp1/sqllib/lib64/libdb2e.so.1 + 0x1BEF61C
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 LUW Version 9.8 Fixpack 5                     * 
****************************************************************
Local Fix:
Not available.
Solution
Problem is first fixed in DB2 LUW Version 9.8 Fixpack 5
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

10.04.2012
12.07.2012
12.07.2012
Problem solved at the following versions (IBM BugInfos)
9.8.FP5
Problem solved according to the fixlist(s) of the following version(s)
9.8.0.5 FixList