IMPORT REPLACE does not honor the Not Logged Initially clause

The IMPORT command's REPLACE option does not honor the CREATE TABLE statement's 7NOT LOGGED INITIALLY (NLI) clause or the ALTER TABLE statement's ACTIVATE 7NOT LOGGED INITIALLY clause.

If an import with the REPLACE action is performed within the same transaction 7as a CREATE TABLE or ALTER TABLE statement where the NLI clause is invoked, 7the import will not honor the NLI clause. All inserts will be logged.

7

Workaround 1

7

Delete the contents of the table using the DELETE statement, then invoke 7the import with INSERT statement. 7

7

Workaround 2

7

Drop the table and recreate it, then invoke the import with INSERT statement. 7

7

This limitation applies to DB2 UDB Version 7 and DB2 UDB Version 78.