DB2 - Problembeschreibung
Problem IC79011 | Status: Geschlossen |
IN DPF ENV., LOADING FROM REMOTE FETCH CURSOR BETWEEN DIFFERENT ENDIAN-BASED PLATFORMS MIGHT CAUSE DATA LOSS | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
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-Zusammenfassung: | |
**************************************************************** * 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. | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows | |
Lösung | |
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-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC84353 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 02.10.2011 05.06.2012 05.06.2012 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP6 | |
Problem behoben lt. FixList in der Version | |
9.7.0.6 |