This section presents four examples of pdconstck.
This example performs integrity checking on all constraints (CST1 and CST2) that have been defined for table T2. The example assumes that table T2 is in check pending status.
T1: CREATE TABLE T1(C1 INT PRIMARY KEY) |
pdconstck -k check -t T2 |
This example performs integrity checking on constraint CST2 defined for table T2. The table definitions are the same as in (1), and the example assumes that table T2 is in check pending status. |
pdconstck -k check -c CST2 |
This example performs integrity checking on all constraints (CST1 and CST2) that have been defined for table T2. The example assumes that table T2 is in non-check pending status.
T1: CREATE TABLE T1(C1 INT PRIMARY KEY) |
pdconstck -k set -t T2 |
This example forcibly releases constraint CST2 for table T2 from check pending status. The table definitions are the same as in (3), and the example assumes that constraint CST2 is in check pending status. |
pdconstck -k release -c CST2 |