|
Problem IC68381
|
Status: Geschlossen |
IMPORT FROM IXF FILES MAY BE SLOWER THAN EXPECTED WHEN THE ROWCOUNT ATTRIBUTE IS SPECIFIED |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
When importing data from an IXF file and the ROWCOUNT <n>
attribute is specified, if the file contains more than <n> rows,
the import process will still need to read through the remainder
of the rows.
This is done in order to process the index information which is
stored at the end of the IXF file.
However, this reading and skipping of records that are not
required, happens in an inefficient way, which can lead to the
import being much slower than expected. ( e.g. slower than
importing all rows ).
This apar fixes this inefficiency.
Note, the SKIPCOUNT and RESTARTCOUNT IMPORT options also have
this problem. |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* Import from IXF file using the ROWCOUNT attribute, may be *
* many times slower than expected. *
****************************************************************
* RECOMMENDATION: *
* Upgrade the database server to DB2 V9.7 Fix Pack 3 *
**************************************************************** |
| Local-Fix: |
n/a |
| verfügbare FixPacks: |
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
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
|
| Lösung |
This problem has first been fixed in V9.7 Fix Pack 3 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 04.05.2010
24.09.2010
24.09.2010 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.7.FP3
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.3
|
 |
| 9.7.0.3
|
|
