DB2 - Problembeschreibung
Problem IC80583 | Status: Geschlossen |
Hang on tranEntry latch in sqlpm_write_appl_locks during lock snapshot | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 | |
Problembeschreibung: | |
In a Federated environment that utilizes two-phase commits, the instance can hang with a LOCK snapshot waiting on a tranEntry latch. The lock snapshot's callstack looks like this: sqlpm_write_appl_locks sqm_snap_appl_locks sqm_snap_db_locks sqlmonssagnt sqlmonssbackend sqlesrvr The lock snapshot is waiting for the tranEntry latch and holding the dblatch, m_appServLatch and masterAppLatch. At the same time a federated server has been defined to use two-phase commit and a federated agent is attempting to establish an XA transaction by calling sqlqg_FMP_FedStart. The agent's stack looks like this: msgrcv sqlorqueInternal sqlorque2 sqloTQMRequestMLN sqlccipcconnr sqlccconnr sqljcCommConnect sqljcCmnMgrInit sqljrCreateTransport sqljrAssociateTransport sqljrInternalConnect sqljrFindBestAddressAndConnect sqljrDrdaArAuthenticate sqlexAppAuthenticate sqljrDrdaArConnect sqleUCdrdaARinit sqleUCappConnect sqlxaConnect DRDA_Connection::xa_open FencedServer::connect FencedServer::connect_current_user sqlqgConnect sqlqg_FMP_FedStart <------------------- sqlqgRouter sqlqg_fedstp_hook sqlqgDyload sqlriFedInvokerTrusted sqlriFedInvokeInvoker sqlqg_Call_FMP_Thread sqlqgFedStart sqlqgOpen sqlri_djx_rta sqlriNljnPiped sqlriSectInvoke sqlrr_process_execute_request sqlrr_execute sqljs_ddm_excsqlstt sqljsParseRdbAccessed sqljsParse sqljsSqlam : The Federated agent is holding the tranEntry latch when it calls sqlqgConnect to establish the XA connection and is waiting for an agent to be provided by the IPC connection manager. The IPC connection manager is hung waiting for the m_appServerLatch being held by the snapshot agent. SQLO_SLATCH_CAS::getConflictComplex SQLO_SLATCH_CAS::getConflict sqlo_latch sqeAppServices::CreateAppl sqeAgentServices::RequestAgent sqlccipcconnmgr_child sqloEDUEntry | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * DB2 version 9.5fp9 and prior * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 V 95fp10 * **************************************************************** | |
Local-Fix: | |
This hang can be avoided if the federated transaction does not require two phase commit. Two phase commit can be disabled as follows: alter server <server name> options (set DB2_TWO_PHASE_COMMIT 'N') | |
Lösung | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC81011 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 23.12.2011 27.08.2012 27.08.2012 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.5.FP10 | |
Problem behoben lt. FixList in der Version | |
9.5.0.10 |