|
Problem IT07578
|
Status: Closed |
IMPORT WITH "MODIFIED BY IDENTITYIGNORE" OPTION IS SLOWER IN HP-UX AND SOLARIS DUE TO MISALIGNED MEMORY ACCESS |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
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" |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to 'product' version 10.5 Fix Pack 7 *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 09.03.2015
28.01.2016
28.01.2016 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.5.0.7
|
 |
