DB2 FOR LUW / DB2FORLUW / 980 - DB2

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.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* Import from IXF files with the ROWCOUNT attribute is         * 
* inefficient.                                                 * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade the DB2 Server to V9.8 Fix Pack 4                    * 
****************************************************************

n/a

DB2 Version 9.8 Fix Pack 4 for AIX and Linux
 DB2 Version 9.8 Fix Pack 5 for AIX and Linux
 

This problem was first fixed in V9.8 Fix Pack 4

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

15.07.2011
04.08.2011
04.08.2011

9.8.FP4