Referential constraints on tables with multilevel security with row-level granularity

You cannot use referential constraints on a security label column, which is used for multilevel security with row-level granularity. However, you can use referential constraints on other columns in the row.

Db2 does not enforce multilevel security with row-level granularity when it is already enforcing referential constraints. Referential constraints are enforced when the following situations occur:

• An insert operation is applied to a dependent table.
• An update operation is applied to a foreign key of a dependent table, or to the parent key of a parent table.
• A delete operation is applied to a parent table. In addition to all referential constraints being enforced, the Db2 system enforces all delete rules for all dependent rows that are affected by the delete operation. If all referential constraints and delete rules are not satisfied, the delete operation will not succeed.
• The LOAD utility with the ENFORCE CONSTRAINTS option is run on a dependent table.
• The CHECK DATA utility is run.