CA RC/Migrator for DB2 for Z/OS: Referential integrity checking by the Utility Load Models(LOAD and FLOAD)
search cancel

CA RC/Migrator for DB2 for Z/OS: Referential integrity checking by the Utility Load Models(LOAD and FLOAD)


Article ID: 54641


Updated On:


RC Compare for DB2 for z/OS RC/Migrator for DB2 for z/OS


The %ENFORCE automatic variable has always been present in the RC/Migrator IBM LOAD model.

This is a copy of the MODEL source showing it in the LOAD syntax line.




This variable resolves to a different value depending on the situation that it is faced with for a given table.

A reference to it can be found in the RC/Migrator User Guide, Manage Profile Options, Utility Model Services, Special Use Symbolics

The FAST LOAD(FLOAD) model works differently.



Release: R19, R20
Component: RCM


The IBM LOAD(LOAD) model uses the %ENFORCE variable which normally resolves to "ENFORCE CONSTRAINTS" as it's loading because normally a PARENT table is being loaded or, after the PARENT, a CHILD table will be loaded and during the load the foreign keys on the CHILD are checked.

When a recursive RI relationship(PARENT is a CHILD of itself) is present, the relationships from the table to itself can't be checked till after the records are loaded so the load must use "ENFORCE NO" and then CHECK DATA utilities are executed on the tablespace at the end in order to verify the RI to itself. It might also generate CA FAST CHECK code if the user activates the CA FAST CHECK Model member instead of the IBM Check Data. Fast Check will work if it is available to the user. Where "ENFORCE CONSTRAINTS" has been used during the load, no additional CHECK utility is generated for that specific tablespace as the RI Check has been done already.

The FAST LOAD(FLOAD) model does not use %ENFORCE. Fast Load is able to validate RI with the use of CA FAST CHECK if the customer has purchased it. However the RC/Migrator model FLOAD does not generate the code to ENFORCE CONSTRAINTS. Instead it loads the records, sets the tablespace to Check Pending and uses either the IBM Check Data or CA Fast Check to validate the RI after the load. CA Fast Check can only be used if it's available to the user.

Additional Information

Special Use Symbolics


Referential Integrity Alterations