DB2 FOR LUW / DB2FORLUW / A10 - DB2

When the INGEST command specifies both one of the 
implicitlyhiddenxxx options and the exception table clause, it 
gets SQL2918N message, even though the command does not specify 
a column list 
 
Ex: 
create table t1(c1 int,c2 int,c3 TIMESTAMP NOT NULL IMPLICITLY 
HIDDEN GENERATED ALWAYS FOR EACH ROW ON UPDATE AS ROW CHANGE 
TIMESTAMP) 
DB20000I  The SQL command completed successfully. 
 
create table t2 like t1 
DB20000I  The SQL command completed successfully. 
 
create unique index ind1 on t1(c1,c2) 
DB20000I  The SQL command completed successfully. 
 
INGEST FROM FILE test1.del FORMAT DELIMITED by '|' 
IMPLICITLYHIDDENMISSING EXCEPTION TABLE T2 MESSAGES ingest.msg 
RESTART NEW 'm1' INSERT INTO T1 
SQL2901I  The ingest utility completed at timestamp "07/11/2013 
11:52:11.477788". Number of errors: "1". Number of warnings: 
"1".    Message 
file: "ingest.msg". 
 
In ingest.msg: 
 
SQL2918N  Invalid combination of keywords, 
"IMPLICITLYHIDDENMISSING" and 
"<column-list>", specified in the INGEST command.

**************************************************************** 
* USERS AFFECTED:                                              * 
* Users of the ingest utility with the EXCEPTION TABLE         * 
* parameter.                                                   * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Problem Description above.                               * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 10.1 Fix Pack 3.                      * 
****************************************************************

DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
 

First fixed in DB2 Version 10.1 Fix Pack 3.

keiner bekannt / siehe Local-Fix

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

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

15.07.2013
15.11.2013
15.11.2013