search cancel

RCM; Will the Syntax checker flag incomplete table definitions related to Indexes?

book

Article ID: 240101

calendar_today

Updated On:

Products

RC/Migrator for DB2 for z/OS

Issue/Introduction

 If a DB2 table is created with an incomplete definition, for example;

  >> A table has a Unique constraint and there is not a matching Unique Index.

 >> A primary key constraint does not have a matching index.

 Will Syntax checker flag these?

Environment

Release : 20.0

Component : RC/Migrator for DB2 for z/OS

Resolution

The syntax checker does not flag incomplete DDL. The syntax checker is only validating the provided DDL is syntactically correct. 

The Help panel explains:

Incorrect DDL statements or object dependency problems are displayed in the Syntax Checker Report, along with
messages describing the problems.

The Syntax Checker does not put any locks on the DB2 catalog, so you can check a stream for errors without
interrupting any other DB2 process.

The Syntax Checker does not perform DATA TYPE validations on index VALUE clauses or in VIEW text.  It checks DDL
only; it does not check grant statements.

-----------

The syntax checker is not going to determine a Unique constraint does not have a matching index with the correct columns.