|
Problem IC69540
|
Status: Geschlossen |
CONCURRENT RUNSTATS ON STATISTICAL VIEWS REFERENCING A COMMON TABLE CAN DEADLOCK |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 910 - DB2 |
| Problembeschreibung: |
Runstats on two different statistical view specifying WITH
DISTRIBUTION from two different connections may deadlock if they
reference a common table in their definition |
| Problem-Zusammenfassung: |
Problem Description:
CONCURRENT RUNSTATS ON STATISTICAL VIEWS REFERENCING A COMMON
TABLE CAN DEADLOCK
Problem Summary:
Runstats on two different statistical view specifying WITH
DISTRIBUTION from two different connections may deadlock if they
reference a common table in their definition |
| Local-Fix: |
Retry - or don't run concurrently |
| verfügbare FixPacks: |
DB2 Version 9.1 Fix Pack 10 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12 for Linux, UNIX and Windows
|
| Lösung |
Problem is first fixed in Version 9.1 Fix Pack 10 |
| Workaround |
Retry, or don't perform Runstats concurrently |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 29.06.2010
13.06.2011
13.06.2011 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.1.FP10
|
| Problem behoben lt. FixList in der Version |
| 9.1.0.10
|
 |
