|
Problem IC90039
|
Status: Geschlossen |
DEADLATCH DURING MEMBER CRASH RECOVERY IN A DB2 PURESCALE ENVIRONMENT |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problembeschreibung: |
During crash recovery of a member in a DB2 pureScale cluster,
there is a small timing window that can result in a deadlatch
between the member and an agent running RUNSTATS on another
member in the cluster. If the deadlatch happens it causes the
crash recovery to hang. The related stacks would show as
follows:
Stack 1:
sqlbFixPage
sqliRefreshInfoPage
sqliIP_CreatePage
sqliIP_FixPage
sqliHardenJITS
sqldHardenJitsForAllIndexes
sqlrLocalRunstats
Stack 2:
sqldLatchIndexes
sqldInitIndexValidityLotch
sqldAllocEmptyTCB
...
sqlpParallelRecovery |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* DB2 pureScale Environments *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 version 10.1.0.3. *
**************************************************************** |
| Local-Fix: |
Use the FORCE APPLICATION command to force the application
performing RUNSTATS off the system. This will allow member
crash recovery to complete. |
| verfügbare FixPacks: |
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
|
| Lösung |
The problem is first fixed in DB2 version 10.1.0.3. |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 05.02.2013
27.09.2013
27.09.2013 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
| 10.1.0.3
|
 |
| 10.1.0.3
|
|
