DB2 - Problembeschreibung
Problem IC83256 | Status: Geschlossen |
Hang on tranEntry latch in sqlpm_write_appl_locks during lock snapshot | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A10 - 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: * * Anybody using federated transaction two phase commit * * transaction and LOCK snapshots. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Version 10.1 Fix Pack 1 * **************************************************************** | |
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') | |
verfügbare FixPacks: | |
DB2 Version 10.1 Fix Pack 1 for Linux, UNIX, and Windows | |
Lösung | |
Problem was first fixed in Version 10.1 Fix Pack 1 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 09.05.2012 31.10.2012 31.10.2012 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.1.0.1 | |
10.5.0.1 |