|
Problem IC69148
|
Status: Closed |
Load with COPY YES option into a Range Partitioned table may trap in rare timing scenarios. |
| product: |
DB2 FOR LUW / DB2FORLUW / 910 - DB2 |
| Problem description: |
When the target table is a (non-MDC) Range Partitioned table,
and Load is invoked with the COPY YES option, in rare timing
scenarios it's possible for the Load to trap (likely with
sqluTransformMergeRequestio or sqluTransformMergeFSCRRequest in
the stack), or it's possible for the Load to panic with a
BADPAGE error (likely with similar functions in the stack). The
exact stack that is generate may differ, but will involve the
Load 'db2lbm' or 'db2lrid' edus.
This is caused by a rare timing scenario where both the db2lbm
and db2lrid EDUs are manipulating the same Load data-page
concurrently.
The problem is more likely to occur when the number of ranges is
very large. |
| Problem Summary: |
Load with COPY YES option into a Range Partitioned table may
trap in rare timing scenarios. |
| Local Fix: |
No Local Fix. |
| 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 |
Fixed in Db2 v91 FP10 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 10.06.2010
14.06.2011
14.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
|
 |
