DB2 - Problembeschreibung
Problem IC96535 | Status: Geschlossen |
POTENTIAL HANG ON TRANENTRY LATCH IN SQLPM_WRITE_APPL_LOCKS DURING LOCK SNAPSHOT | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problembeschreibung: | |
When a federated server utilizing two-phase-commit starts up it will hold the tranEntry latch. If the federated query involves connecting back into the same database then it will start an agent that will try to get the dblatch. Since snapshot processing first gets the dblatch and then tries to get the tranEntry latch, it is possible for a hang to occur if a LOCK snapshot is processing when such federated query processing is running. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * Anybody using federated transaction two phase commit * * transaction and LOCK snapshots * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 LUW v10.5 Fixpack 4 or Later. * **************************************************************** | |
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 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows | |
Lösung | |
First Fixed in DB2 LUW v10.5 Fixpack 4. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 01.10.2013 17.09.2014 17.09.2014 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.5.0.4 |