Alter of Table with Foreign Key Causes Check Pending state (4226198)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Alter of Table with Foreign Key Causes Check Pending state
Description

When doing an alter where a table must be dropped that has Referential Integrity on a child table, the script that is created rebuilds the foreign key, and at the end does a CHECK on the table. However, the check is being done on the PARENT table, and it is the CHILD table that is thrown into Check Pending. The script needs to do a CHECK on the child tables to keep this from happening.
Resolution

WORKAROUND:

None

STATUS:

Waiting for fix in a future version of Toad for DB2 z/os.
Defect ID

TDB-422

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title