DB2 FOR LUW / DB2FORLUW / 950 - DB2

LOAD may abend instance in  sqlulirr() when  a VARCHAR(32671) or 
VARCHAR(32672) column is exported to an IXF file, and then load 
it into a LONG VARCHAR column with the stack similar to 
following 
 
        sqloEDUCodeTrapHandler 
        __pthread_cleanup_upto 
        sqlulirr 
        sqluGetAndFormatRecords 
        sqluldat 
        sqloEDUEntry 
 
 
This does not affect shorter VARCHARs, or other file types than 
IXF, or other permutations (VARCHAR --> VARCHAR, LONG VARCHAR 
--> LONG VARCHAR, LONG VARCHAR --> VARCHAR. 
 
IF  DB2 LUW EXPORT is used to generate IXF file against DB2 for 
z/OS server, any LONG VARCHAR column will be saved was 
VARCHAR(32672) in the IXF File, making it susceptible to this 
problem.

**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 9.5 Fixpak 9                                  * 
****************************************************************

Use DEL format for loading data

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

First fixed in DB2 9.5 Fixpak 9

not known / see Local fix

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

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

01.09.2011
23.05.2012
23.05.2012

9.0.,
9.5.