DB2 FOR LUW / DB2FORLUW / 970 - DB2

A table originally contains a generated column, a LOB column and 
some other columns, then data in this table is exported to an 
IXF file. When recreating this table, the LOB column is missed 
(other columns unchanged) for some reason so that subsequent 
IMPORT from the IXF file traps with SIGSEGV (signal #11). The 
stack trace looks like the following: 
 
-------Frame------ ------Function + Offset------ 
0x090000004E919EB8 shiftDescInfo__13sqluCImpTableFPUcPi + 0x244 
0x090000004EACD180 
ShiftSqldaForDefaults__13sqluCImpTableFP7sqluecb + 0x24 
0x090000004E362D50 
sqluimpm__FPiP7sqluecbP5sqlcaUcPPUcP13SQLO_MEM_POOLN31P12db2Impo 
rtOut 
+ 0x3A18 
0x090000004E758420 
sqluimpt__FPcT1P15sqlu_media_listP7sqldcolP6sqllobT1P7sqlcharT1i 
P11db2ImportInP12db2ImportOutPiT3PvP5sqlca 
+ 0x8B8 
0x090000004E7577A4 db2Import + 0x5C4 
0x0000000100039028 clpbp_exe_sqluimpt__Fv + 0x1C8 
0x0000000100001794 clp_bp_con__Fv + 0x634 
0x0000000100000B24 main + 0x224 
 
Impact: 
IMPORT traps and the connection is terminated so that a user has 
to reconnect to the database to do other operations.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See ERROR DESCRIPTION.                                       * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to v9.7 Fixpack 6                                    * 
****************************************************************

Use correct DDL to recreate the target table and try IMPORT 
again.

DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

First fixed in v9.7 Fixpack 6.  At minimum this fix should be 
applied to the server.

See LOCAL FIX.

Vorgänger  : APAR is sysrouted TO one or more of the following: IC84390 
Nachfolger : 

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

18.08.2011
04.06.2012
04.06.2012

9.7.FP6