DB2 FOR LUW / DB2FORLUW / 950 - 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:                                         * 
* Performance of import is slow when importing from IXF        * 
* fileswith the ROWCOUNT option                                * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade the database server to DB2 V9.5 Fixpak 7             * 
****************************************************************

n/a

DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
 DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
 

The problem has first been fixed in V9.7 Fixpak 7

not known / see Local fix

forerunner  : APAR is sysrouted TO one or more of the following: IC68380 IC68381 IC77558 
follow-up : 

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

27.04.2010
15.11.2010
15.11.2010

9.5.,
9.7.