My Oracle Support Banner

Siebel Tools Connected to a DB2 Database Adds Clause NOT LOGGED INITIALLY to CREATE TABLE DDL Command, Causing Error SQL0628N, When The Table is Replicated via DB2 Functionalities (Doc ID 2857420.1)

Last updated on MARCH 24, 2022

Applies to:

Siebel Tools - Version 15.5 [IP2015] and later
Information in this document applies to any platform.

Symptoms


Siebel Tools accessing DB2 DB adds clause NOT LOGGED INITIALLY to CREATE TABLE commands. This clause may cause errors while replicating Siebel DB2 tables using IBM DB2 replication functionalities. The DB2 HADR replication behavior was not internally reproduced while handling this issue.


The reported error in this case is the following:

[IBM][CLI Driver][DB2/AIX64] SQL0628N Multiple or conflicting keywords involving the "NOT LOGGED INITIALLY" clause are present. SQLSTATE=42613



Below the steps to see how Siebel Tools creates CREATE TABLE commands while connected to DB2:

  1. Open Siebel Tools (Read Using Siebel Tools for detailed information).
  2. Create a new table (Go to Object Explorer > Table > Go to the panel on right > Right click on the mouse > Choose New Objects Wizard > Table).
  3. Add all columns and indexes definitions to the table.
  4. Click Apply/DDL button > Generate DDL.
  5. Enter the necessary database related parameters and click on GENERATE DDL button.
  6. Verify the file created and NOT LOGGED INITIALLY clause will be present in the table creation command.


     

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.