|
Problem IC84353
|
Status: Closed |
IN DPF ENV., LOADING FROM REMOTE FETCH CURSOR BETWEEN DIFFERENT ENDIAN-BASED PLATFORMS MIGHT CAUSE DATA LOSS |
| product: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problem description: |
When loading data using the CURSOR file type between two
different databases (aka. Load Remote Fetch), if both of
databases are partitioned databases, but on different
endian-based platforms, e.g. one is Linux on x86/x86-64
(little-endian) and the other is AIX on POWER (big-endian), the
data on some partitions might not be loaded into the target
database you currently connect to.
db2move might also have the same problem when using the COPY
action to move data between two different databases. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All platforms *
****************************************************************
* PROBLEM DESCRIPTION: *
* When loading data using the CURSOR file type between two *
* different databases (aka. Load Remote Fetch), if both of *
* databases are partitioned databases, but on different *
* endian-based platforms, e.g. one is Linux on x86/x86-64 *
* (little-endian) and the other is AIX on POWER (big-endian), *
* the *
* data on some partitions might not be loaded into the target *
* database you currently connect to. *
* *
* db2move might also have the same problem when using the COPY *
* action to move data between two different databases. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to db2_v10fp1. *
* *
* Use EXPORT or db2move with the EXPORT action to export data *
* from *
* the source database to data files, then load data from the *
* data *
* files to the target database. *
**************************************************************** |
| Local Fix: |
Use EXPORT or db2move with the EXPORT action to export data from
the source database to data files, then load data from the data
files to the target database. |
| available fix packs: |
DB2 Version 10.1 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows
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
|
| Solution |
The fix will be included in db2_v10fp1. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 13.06.2012
07.11.2012
07.11.2012 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.1
|
 |
| 10.5.0.1
|
|
