home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
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
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC84086 Status: Geschlossen

DB2 MAY HANG DUE TO LATCH ON SQLO_LT_SQLE_FEDFMP_APP_CB__FMPAPPL ATCH AFTER
-1131 AND -1042 ERRORS.

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
DB2 might experience a hung in which an agent is holding 
SQLO_LT_SQLE_FEDFMP_APP_CB__FMPAPPLATCH latch.  It can happen 
that other agents waiting on this latch will be holding crucial 
latches (example SQLO_LT_sqeLocalDatabase__dblatch or 
SQLO_LT_SQLP_TENTRY__tranEntryLatch) for database functioning, 
halting the whole system. 
 
The db2diag.log might show errors like: 
 
sqleFedFMPManager::disconnect, probe:30 
RETCODE : ZRC=0xFFFFFB95=-1131 
 
and 
 
sqleFedFMPManager::returnFmpToPool, probe:30 
RETCODE : ZRC=0xFFFFFBEE=-1042 
 
 
 
 
The following is an example of stacks of holder and waiter when 
this problem happens: 
 
EDU name     : db2agntdp (DW      ) 0 
EDU ID       : 348 
<LatchInformation> 
Holding Latch type: (SQLO_LT_SQLE_FEDFMP_APP_CB__fmpAppLatch) - 
Address: (0x200dfc4a8), Line: 481, File: sqle_fed_fmp.C 
HoldCount: 2 
</LatchInformation> 
0x00002AAAABF43973 sqloWaitEDUWaitPost + 0x0195 
  (/db2home/db2inst1/sqllib/lib64/libdb2e.so.1) 
0x00002AAAABB58298 _ZN8sqeAgent14WaitAgentEventEPji + 0x0012 
  (/db2home/db2inst1/sqllib/lib64/libdb2e.so.1) 
0x00002AAAABB7576B 
_ZN16sqeAgentServices14GetNextRequestEPjP8sqeAgent + 0x034d 
  (/db2home/db2inst1/sqllib/lib64/libdb2e.so.1) 
0x00002AAAABB556DD _ZN8sqeAgent6RunEDUEv + 0x0443 
  (/db2home/db2inst1/sqllib/lib64/libdb2e.so.1) 
0x00002AAAAC2249C0 _ZN9sqzEDUObj9EDUDriverEv + 0x00a6 
  (/db2home/db2inst1/sqllib/lib64/libdb2e.so.1) 
0x00002AAAAC224917 _Z10sqlzRunEDUPcj + 0x0009 
 
 
EDU name     : db2agent (DW) 0 
EDU ID       : 313 
 
<LatchInformation> 
 
Waiting on latch type: (SQLO_LT_SQLE_FEDFMP_APP_CB__fmpAppLatch) 
- Address: (0x200dfc4a8), Line: 481, File: sqle_fed_fmp.C 
 
Holding Latch type: (SQLO_LT_SQLP_TENTRY__tranEntryLatch) - 
Address: (0x2aaad4138268), Line: 748, File: 
/view/db2_v97fp4_linuxamd64_s110330/vbs/engn/include/sqlpi_inlin 
es.h HoldCount: 1 
Holding Latch type: (SQLO_LT_SQLP_SAVEPOINTS__spLatch) - 
Address: (0x2aaad4137d40), Line: 851, File: 
/view/db2_v97fp4_linuxamd64_s110330/vbs/engn/include/sqlpi_inlin 
es.h HoldCount: 1 
</LatchInformation> 
0x00002AAAAC8F27E5 
_ZN17sqleFedFMPManager14getFmpAppLatchEP18sqle_FedFMP_app_cbj + 
0x0063 
  (/db2home/db2inst1/sqllib/lib64/libdb2e.so.1) 
0x00002AAAAC8F24DB 
_ZN17sqleFedFMPManager14validateFedFmpEP18sqle_FedFMP_app_cbbP14 
sqlqg_Fmp_InfoP13sqlerFmpParmsP14sqlerFmpHandlePi + 0x006b 
  (/db2home/db2inst1/sqllib/lib64/libdb2e.so.1) 
0x00002AAAAC8F2027 
_ZN17sqleFedFMPManager14getFmpFromPoolEP13sqlerFmpParmsP14sqlqg_ 
Fmp_InfoP14sqlerFmpHandle + 0x0081 
  (/db2home/db2inst1/sqllib/lib64/libdb2e.so.1) 
 
 
A trace when the issue occurs might show the following: 
 
 
17170      | | | | sqlerFedInvokeFencedRoutine entry [eduid 7457 
eduname db2agent] 
17172       | | | | | sqleFedFMPManager::getFmpFromPool entry 
[eduid 7457 eduname db2agent] 
17174       | | | | | | sqleFedFMPManager::validateFedFmp entry 
[eduid 7457 eduname db2agent] 
17176       | | | | | | | sqleFedFMPManager::getFmpAppLatch 
entry [eduid 7457 eduname db2agent] 
17179       | | | | | | | sqleFedFMPManager::getFmpAppLatch exit 
17180       | | | | | | sqleFedFMPManager::validateFedFmp data 
[probe 1] 
17183       | | | | | | | sqleFedFMPManager::addLogRecord entry 
[eduid 7457 eduname db2agent] 
17185       | | | | | | | sqleFedFMPManager::addLogRecord exit 
17187       | | | | | | sqleFedFMPManager::validateFedFmp exit 
[rc = 1] 
17189       | | | | | sqleFedFMPManager::getFmpFromPool exit 
17191       | | | | | sqlerSendFmpStart entry [eduid 7457 
eduname db2agent] 
17227       | | | | | | sqlerRtnWriteFencedArgData entry [eduid 
7457 eduname db2agent] 
17232       | | | | | | sqlerRtnWriteFencedArgData exit 
17238       | | | | | sqlerSendFmpStart data [probe 42] 
17243       | | | | | sqlerSendFmpStart exit 
17247       | | | | | sqeAgent::AgentBreathingPoint entry [eduid 
7457 eduname db2agent] 
17249       | | | | | | sqeAgent::QueryInterrupt entry [eduid 
7457 eduname db2agent] 
17253       | | | | | | sqeAgent::QueryInterrupt data [probe 70] 
17255       | | | | | | sqeAgent::QueryInterrupt exit 
17257       | | | | | sqeAgent::AgentBreathingPoint exit [rc = 
1] 
17259       | | | | | sqlerInterruptFmp entry [eduid 7457 
eduname db2agent] 
17261       | | | | | | sqlerInterruptThreadedFmp entry [eduid 
7457 eduname db2agent] 
17264       | | | | | | | sqlerMasterThreadReq entry [eduid 7457 
eduname db2agent] 
17268       | | | | | | | sqlerMasterThreadReq exit [rc = 
0xFFFFFBEE = -1042] 
17270       | | | | | | sqlerInterruptThreadedFmp error [probe 
10] [ ZRC = 0xFFFFFBEE = -1042] 
17272       | | | | | | sqlerInterruptThreadedFmp exit [rc = 
0xFFFFFBEE = -1042] 
17274       | | | | | sqlerInterruptFmp exit [rc = 0xFFFFFBEE = 
-1042] 
17276       | | | | sqlerFedInvokeFencedRoutine error [probe 70] 
17281       | | | | sqlerFedInvokeFencedRoutine exit [rc = 
0xFFFFFBEE = -1042] 
17284       | | | sqlriFedInvokeInvoker exit [rc = 0x8012006D = 
-2146303891 = SQLR_CA_BUILT] 
 
 
Note that this might look similar to APAR IC83795, but with the 
fix for IC83795 this problem can still occur. 
 
This APAR only applies to Federated environments.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 and Fix Pack 7                    * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

Lösung
Problem was first fixed in DB2 Version 9.7 and Fix Pack 7
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
12.06.2012
20.10.2012
20.10.2012
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.
Problem behoben lt. FixList in der Version
9.7.0.7 FixList