00E7009B

Explanation

An invalid operation has been attempted on an incomplete table that was created in a previous release of Db2. The table definition is incomplete due to a missing unique index on a primary key or unique key.

The following DDL operations are not allowed:
  • ALTER TABLE
  • CREATE INDEX
  • DROP INDEX

System action

Db2 does not process the operation.

Operator response

Notify the system programmer.

System programmer response

In order to perform the operation on the object, you must use the release of Db2 in which the table was created.

Problem determination

Db2 does not perform the requested operation, and issues SQLCODE -904. For more information, refer to SQL codes.