Hello folks,

After a successfull Migration from DB2 9.5 to 9.7 i get the following error in my db2diag. System AIX 6. This error comes up every 3 minutes which is really annoying.

2011-10-25-16.00.32.836217+120 I1200258A553 LEVEL: Error
PID : 1175638 TID : 30585 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : EONL1
APPHDL : 0-8 APPID: *LOCAL.DB2.111025134232
AUTHID : DB2INST1
EDUID : 30585 EDUNAME: db2stmm (EONL1) 0
FUNCTION: DB2 UDB, Self tuning memory manager, stmmAttachToShm, probe:2781
MESSAGE : ECF=0x90000001=-1879048191=ECF_ACCESS_DENIED
Access denied
DATA #1 : String, 39 bytes
STMM unable to attach to shared memory.

Can anybody help? Thanks in advance.

DB_N00b

Not sure why this error is logged, but you can try setting the following registry variable and then restarting the instance:

DB2STMM=GLOBAL_BENEFIT_SEGMENT_COMPATIBLE:YES

I tried that ... and error still comes up :-(

2011-10-26-08.49.08.988895+120 I59127A553 LEVEL: Error
PID : 1310856 TID : 30585 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : EONL1
APPHDL : 0-8 APPID: *LOCAL.DB2.111026064608
AUTHID : DB2INST1
EDUID : 30585 EDUNAME: db2stmm (EONL1) 0
FUNCTION: DB2 UDB, Self tuning memory manager, stmmAttachToShm, probe:2781
MESSAGE : ECF=0x90000001=-1879048191=ECF_ACCESS_DENIED
Access denied
DATA #1 : String, 39 bytes
STMM unable to attach to shared memory.

I think there are some changes/fixes going into v9.7 FP5 that changes permissions on the segment. Don't know the details.

I'd suggest opening a pmr.

I´ve already opened a PMR and IBM is looking for the problem.

Thank you alot for your help.

IBM recommended to install Fixpack and I have done so. Problem is fixed now.

I have two groups of db2 instances, a DB2 9.5 FP4 and a DB2 9.7 FP5 residing on a same host. The DB2 9.7 group was migrated from 9.5. All instances were working fine before 9.7 migration. After 9.7 migration, the 9.7 instances are fine, but 9.5 instance are getting :
2012-04-18-14.52.50.506729-240 I870056A559 LEVEL: Error
PID : 33816614 TID : 5929 PROC : db2sysc 0
INSTANCE: db2reld4 NODE : 000 DB : WRELD4DB
APPHDL : 0-20 APPID: *LOCAL.DB2.120418173122
AUTHID : LCUSER
EDUID : 5929 EDUNAME: db2stmm (WRELD4DB) 0
FUNCTION: DB2 UDB, Self tuning memory manager, stmmAttachToShm, probe:2687
MESSAGE : ECF=0x90000001=-1879048191=ECF_ACCESS_DENIED
Access denied
DATA #1 : String, 39 bytes
STMM unable to attach to shared memory.

Can anybody help? Thanks in advance.

tt