|
Problem IC69540
|
Status: Closed |
CONCURRENT RUNSTATS ON STATISTICAL VIEWS REFERENCING A COMMON TABLE CAN DEADLOCK |
| product: |
DB2 FOR LUW / DB2FORLUW / 910 - DB2 |
| Problem description: |
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 Summary: |
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 |
| available fix packs: |
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
|
| Solution |
Problem is first fixed in Version 9.1 Fix Pack 10 |
| Workaround |
Retry, or don't perform Runstats concurrently |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 29.06.2010
13.06.2011
13.06.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.1.FP10
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.1.0.10
|
 |
