|
Problem IC95146
|
Status: Closed |
THE LOAD COMMAND WITH THE REMOTE FETCH OR SOURCEUSEREXIT OPTIONS MIGHT FAIL TO INSERT SOME ROWS INTO A TABLE |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
LOAD utility might fail to insert some rows if one of the
following LOAD options are involved.
- Remote fetch (a load from a cursor where the cursor is
declared using the DATABASE keyword)
- SOURCEUSEREXIT
This is a timing related issue that has been observed when
concurrently running a large number of such LOADs.
This problem exists in the version 9.8 fix pack 3 and more
recent versions of the DB2 product. The 9.7 version of the DB2
product and prior versions are not affected by this issue.
The problem does not exist when target system where we run the
LOAD operation is a partitioned database environment. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All users *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 10.5 Fix Pack 3. *
**************************************************************** |
| Local Fix: |
Currently there is no local fix for this issue. |
| available fix packs: |
DB2 Version 10.5 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
|
| Solution |
Problem was first fixed in DB2 Version 10.5 Fix Pack 3. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 22.08.2013
27.02.2014
07.04.2015 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.5.0.3
|
 |
| 10.5.0.3
|
|
