|
Problem IC68381
|
Status: Closed |
IMPORT FROM IXF FILES MAY BE SLOWER THAN EXPECTED WHEN THE ROWCOUNT ATTRIBUTE IS SPECIFIED |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* 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 |
| available fix packs: |
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
|
| Solution |
This problem has first been fixed in V9.7 Fix Pack 3 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 04.05.2010
24.09.2010
24.09.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP3
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.3
|
 |
| 9.7.0.3
|
|
