DB2 FOR LUW / DB2FORLUW / 970 - DB2

An import using "MODIFIED BY IDENTITYIGNORE" can be slow in 
HP-UX and SOLARIS platform. 
This is due to the misaligned memory access on those platform. 
 
As an example, this symptom may hit with following case. 
 
 (1) Target table has an identity column. 
 
CREATE TABLE TEST.TESTTB  ( 
                  "COL1" BIGINT NOT NULL GENERATED BY DEFAULT AS 
IDENTITY ( 
                    START WITH +1 
                    INCREMENT BY +1 
                    MINVALUE +1 
                    MAXVALUE +9223372036854775807 
                    NO CYCLE 
                    CACHE 20 
                    NO ORDER ) , 
.... 
 
 (2) Import is done with the option "MODIFIED BY 
IDENTITYIGNORE". 
 
$ db2 "import from testdata.ixf of ixf  MODIFIED BY 
IDENTITYIGNORE insert into TEST.TESTTB"

**************************************************************** 
* USERS AFFECTED:                                              * 
* HP-UX, Solaris                                               * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version V9.7 Fix Pack 11.                     * 
****************************************************************

First fixed in Version V9.7 Fix Pack 11

not known / see Local fix

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

16.11.2014
14.10.2015
14.10.2015

9.7.FP11