Adding the NOT LOGGED INITIALLY Parameter to DB2 CREATE TABLE Commands

For DB2 databases, you can optionally add the NOT LOGGED INITIALLY clause to CREATE TABLE statements in DDL files to speed up table creation by suspending logging during the operation.

Specifically for DB2 databases, you can include the NOT LOGGED INITIALLY clause to create table commands in your ddl files. This parameter is intended to make the table’s creation faster as logging of the CREATE TABLE command is suspended while the table is created. A new system preference is added to let you add or exclude this parameter.

System Preference Name	Value	Description
NotLoggedInitiallyClause	TRUE (Default) FALSE	When set to TRUE, the NOT LOGGED INITIALLY parameter will be added to the CREATE TABLE command. TRUE is the default. When set to FALSE the NOT LOGGED INITIALLY parameter will not be added to the CREATE TABLE command.