Home

Latest versions	fixlist
11.1.0.7
10.5.0.9
10.1.0.6
9.8.0.5
9.7.0.11
9.5.0.10
9.1.0.12

Have problems? - contact us.
Register for free
Contact form

DB2 - Problem description

Problem IC72186	Status: Closed
DB2DIAG.LOG FILLED WITH MESSAGES WHEN FREEING IPC RESOURCES
product:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problem description:
DB2 tries to free an Inter Process Communications resource twice which results in the informational messages below: 2010-07-00-08.56.51.048014-240 I42863825A562 LEVEL: Severe PID : 1233038 TID : 17221 PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 DB : SAMPLE APPHDL : 0-25290 APPID: 192.168.10.1.100928133048 AUTHID : db2user EDUID : 17221 EDUNAME: db2agent (SAMPLE) 0 FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary logging func, probe:0 MESSAGE : IPC Semaphore Set ID DATA #1 : Hexdump, 8 bytes 0x0780000001C2FF6C : FFFF FFFF 0000 0000 ........ 2010-07-00-08.56.51.048241-240 I42864388A562 LEVEL: Severe PID : 1233038 TID : 17221 PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 DB : SAMPLE APPHDL : 0-25290 APPID: 192.168.10.1.100928133048 AUTHID : db2user EDUID : 17221 EDUNAME: db2agent (SAMPLE) 0 FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary logging func, probe:0 MESSAGE : Receive Semaphore ID DATA #1 : Hexdump, 8 bytes 0x0780000001C2FF84 : 0000 0000 0000 0000 ........ 2010-07-00-08.56.51.048482-240 I42864951A439 LEVEL: Severe PID : 1233038 TID : 17221 PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 DB : SAMPLE APPHDL : 0-25290 APPID: 192.168.10.1.100928133048 AUTHID : db2user EDUID : 17221 EDUNAME: db2agent (SAMPLE) 0 FUNCTION: DB2 UDB, common communication, sqlccFreeIPCs, probe:70 RETCODE : ZRC=0xFFFFFFFF=-1 This fix prevents these messages from being falsely returned. One situation when these messages may appear in your db2diag.log is when the DBM CFG parameter KEEPFENCED=NO is set.
Problem Summary:
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See ERROR DESCRIPTION. * **************************************************************** * RECOMMENDATION: * * Apply v9.5 Fixpack 8. * ****************************************************************
Local Fix:

available fix packs:
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
Solution
Problem was first fixed in v9.5 Fixpack 8. At minimum this fix would be applied to the server.
Workaround
not known / see Local fix
Timestamps
Date - problem reported : Date - problem closed : Date - last modified :	25.10.2010 27.06.2011 27.06.2011
Problem solved at the following versions (IBM BugInfos)
9.5.FP8
Problem solved according to the fixlist(s) of the following version(s)
9.5.0.8