DB2 FOR LUW / DB2FORLUW / 970 - DB2

In db2diag.log, we see the following : 
 
2015-06-19-09.31.48.642672+480 I392122183A333     LEVEL: Severe 
PID     : 9766086              TID  : 1800        PROC : db2fmp 
(C) 0 
INSTANCE: db2inst1            NODE : 000 
EDUID   : 1800                 EDUNAME: db2fmp (C) 0 
FUNCTION: DB2 UDB, routine_infrastructure, sqlerFedFmpListener, 
probe:20 
RETCODE : ZRC=0xFFFFFB95=-1131 
 
2015-06-19-09.31.49.026970+480 I392122517A465     LEVEL: Warning 
PID     : 9766086              TID  : 1800        PROC : db2fmp 
(C) 0 
INSTANCE: db2inst1             NODE : 000 
EDUID   : 1800                 EDUNAME: db2fmp (C) 0 
FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary 
logging func, probe:0 
MESSAGE : Thread of db2fmp terminated with nonzero rc 
DATA #1 : Hexdump, 4 bytes 
0x000000011114458C : FFFF FB95 
.... 
 
In a rare scenario, where a IPC error is raised at the right 
place, an agent that is attempting to execute an external 
threadsafe  stored procedure/udf could hang while waiting for 
the FMP thread to respond, but the FMP thread is already 
terminated. The hang is on the particular agent, but it could be 
more severe in the case of federated FMP, as the agent could be 
holding on to some latches.

**************************************************************** 
* USERS AFFECTED:                                              * 
* Version below V9.7 FixPack 12                                * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 V9.7 FP12                                     * 
****************************************************************

A workaround for this is to use 
db2fmpterm to kill the particular FMP, which will trigger sysc 
to do cleanup and wake up the hanging agent.

Fixed in DB2 V9.7 FP12

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

28.07.2015
10.02.2016
10.02.2016

9.7.FP12