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

DB2VEND PROCESS CAN FAIL TO ATTACH SERVER (DATABASE MEMORY SET) SHARED
MEMORY SEGMENT (SQLO_ADDR_CONFLICT IN DB2DIAG.LOG)

product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problem description:
In some cases the db2vend process might fail to attach server 
shared memory segments that belong 
to the database memory set. Messages like the following will 
appear in the db2diag.log file: 
 
  2013-03-11-11.31.34.862818-240 I89558391A1173       LEVEL: 
Warning (OS) 
  PID     : 2622752              TID : 1              PROC : 
db2vend 
  FUNCTION: DB2 UDB, SQO Memory Management, sqlocshr, probe:210 
  MESSAGE : ZRC=0x850F00C4=-2062614332=SQLO_ADDR_CONFLICT 
            "An address space conflict was detected attaching to 
shared memory." 
  CALLED  : OS, -, shmat 
  OSERR   : EINVAL (22) "Invalid argument" 
  DATA #1 : Memory set handle, PD_TYPE_OSS_MEM_SET_HDL, 48 bytes 
 
This will happen only in a few cases where the db2vend stays 
alive long enough for the database server to grow the database 
memory set with a few additional shared memory segments. The 
problem here is that the db2vend will somehow try to attach 
again a segment it already attached at that given address. Note 
that to differentiate this from a genuine error a 
truss/trace/strace... would show that the db2vend is trying to 
shmat() a segment with segid ID at address ADDR but a pmap would 
already show that same segment with segid ID attached at address 
ADDR. 
 
When that problem occurs, if the db2vend stays alive long enough 
multiple occurrences of this message will appear in the 
db2diag.log.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 FP10                              * 
****************************************************************
Local Fix:
Deactivate/Activate database.
Solution
First Fixed in Version 9.7 FP10
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
26.03.2014
10.11.2014
10.11.2014
Problem solved at the following versions (IBM BugInfos)
9.7.FP10
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.10 FixList