DSNU305I csect-name - TABLE=table-name HAS AN INCOMPLETE TABLE DEFINITION

Explanation

Table 'table-name' does not have an index defined to enforce the uniqueness of its primary key or unique key.

System action

Processing stops. No table in the table space is loaded.

User response

The user can resubmit the LOAD job after performing one of the following:
  • Creating a unique index over the table's primary key
  • Creating a unique index over the table's unique key(s)
  • Dropping the definition of the table's primary key
  • Dropping the definition of the table's unique key(s)

Problem determination

Issue SQL SELECT against the catalog to determine which indexes and relations exist against 'table-name'. Determine whether uniqueness of the primary key or unique key has been guaranteed through omission or through faulty definition of an index.

Severity

8 (error)