|
Problem IC79011
|
Status: Closed |
IN DPF ENV., LOADING FROM REMOTE FETCH CURSOR BETWEEN DIFFERENT ENDIAN-BASED PLATFORMS MIGHT CAUSE DATA LOSS |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - 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 *
****************************************************************
* 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 may not be loaded into the target *
* *
* database you currently connect to. *
* *
* *
* *
* db2move may also have the same problem when using the COPY *
* *
* action to move data between two different databases. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 V97fp6 *
**************************************************************** |
| 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 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
The fix will be included in DB2 V97fp6 |
| Workaround |
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. |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC84353
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 02.10.2011
05.06.2012
05.06.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP6
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.6
|
 |
