DB2 - Problembeschreibung
Problem IT07578 | Status: Geschlossen |
IMPORT WITH "MODIFIED BY IDENTITYIGNORE" OPTION IS SLOWER IN HP-UX AND SOLARIS DUE TO MISALIGNED MEMORY ACCESS | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problembeschreibung: | |
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-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to 'product' version 10.5 Fix Pack 7 * **************************************************************** | |
Local-Fix: | |
Lösung | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 09.03.2015 28.01.2016 28.01.2016 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.5.0.7 |