DB2 FOR LUW / DB2FORLUW / 970 - DB2

Event monitor application might hang with the following 
symptoms: 
 
1. User unable to force off Event monitor application  (might 
have some locks on user tables which cause contention) 
2. Coordinator agent is on Pending RemoteRequest state. 
 
Stack of Coordinator agent might show the following: 
 
 sqloWaitEDUWaitPost 
 sqkfChannel::WaitRecvReady 
 sqkfChannel::ReceiveBuffer 
 sqkdBdsBufferTable::dequeueBuffer 
 sqkdBdsBufferTable::getNextBuffer 
 address: 0x00002AAAACAC07D2 ; dladdress: 
 address: 0x00002AAAACAC05E9 ; dladdress: 
 address: 0x00002AAAACAC0B84 ; dladdress: 
 sqlkdReceiveReply 
 sqleReceiveAndMergeReplies 
 sqlkdInterrupt 
 sqleDssStopUsing 
 sqeApplication::ForwardStopRequest 
 sqeApplication::AppStopUsing 
 address: 0x00002AAAABB73AE3 ; dladdress: 
 address: 0x00002AAAABB73982 ; dladdress: 
 sqleIndCoordProcessRequest 
 
 
3. Active subagents on other partitions will show the following 
stack: 
 
  sqloWaitEDUWaitPost 
  sqmEvmonWaiter::waitForEvmon 
  sqm_evmon_mgr::start_evmon 
  sqlm_bds_start_monitor_hdl 
  sqleSubRequestRouter 
  sqleProcessSubRequest 
  sqeAgent::RunEDU 
  sqzEDUObj::EDUDriver 
  sqlzRunEDU 
  sqloEDUEntry 
 
4. db2diag.log will have entries like the following: 
 
FUNCTION: DB2 UDB, base sys utilities, 
sqeAgentServices::RequestAgentForAppl, probe:6 
MESSAGE : Error processing app entry... SQLCODE = 
DATA #1 : Hexdump, 4 bytes 
0x00002AAAC2FF2248 : 48FC FFFF 
H... 
 
and 
 
FUNCTION: DB2 UDB, database monitor, sqmEvmonWriter::startMeUp, 
probe:71 
MESSAGE : ZRC=0x800D0003=-2146631677=SQLM_ACT_INTRP 
          "Event monitor activation interrupted" 
          DIA8003C The interrupt  has been received. 
DATA #1 : String, 16 bytes

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Ugprade to  DB2 Version 9.7 Fix Pack 10.                     * 
****************************************************************

Database has to be restarted to clear out the Event monitor 
application.

Problem was first fixed in DB2 Version 9.7 Fix Pack 10.

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

21.03.2014
10.11.2014
10.11.2014

9.7.FP10