DB2 FOR LUW / DB2FORLUW / A10 - DB2

Ingest can perform poorly when the INGEST command omits the 
field list and specifies a target table that has a lot of 
user-defined data types (UDTs).  For example, ingesting 100K 
rows into a 300-column table that has 75 columns whose type is a 
UDT took 32 times as long as import (16 minutes vs. 30 seconds).

**************************************************************** 
* USERS AFFECTED:                                              * 
* Ingest users using UDTs on DB2 V10.1 Fixpack 2 or lower.     * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 for LUW Version 10.1 Fixpack 3 or higher.     * 
****************************************************************

There are two possible work arounds: 
 
(1) Define an explicit field list on the INGEST command.  For 
example: 
 
INGEST FROM FILE my_file.del FORMAT DELIMITED 
( 
   $field1 INTEGER EXTERNAL, 
   $field2DECIMAL(5,2) EXTERNAL, 
   ... 
   $fieldn CHAR(10) 
) 
    INSERT INTO my_table_with_many_udts; 
 
(2) Modify the table to use built-in types instead of 
user-defined types.

DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
 

First fixed in DB2 for LUW Version 10.1 Fixpack 3.

not known / see Local fix

forerunner  : APAR is sysrouted TO one or more of the following: IC97541 
follow-up : 

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

16.09.2013
07.10.2013
07.10.2013