home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC68203 Status: Geschlossen

IMPORT FROM IXF FILES MAY BE SLOWER THAN EXPECTED WHEN THE ROWCOUNT
ATTRIBUTE IS SPECIFIED

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

Lösung
The problem has first been fixed in V9.7 Fixpak 7
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC68380 IC68381 IC77558 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
27.04.2010
15.11.2010
15.11.2010
Problem behoben ab folgender Versionen (IBM BugInfos)
9.5.,
9.7.
Problem behoben lt. FixList in der Version
9.1.0.7 FixList
9.5.0.7 FixList