The onpladm utility when referential constraints are on tables

The onpladm utility unloads and loads an entire database by creating individual table unload and load jobs. If the load mode is express, the default load mode, the onpladm utility disables referential constraints during load jobs. If database tables have constraints on them, problems can occur. For example, if one table has a referential constraint to another table and that table is not yet loaded, a violation that prevents a table from loading can occur.

If tables have constraints, you can manually disable the constraints after the load job is complete.

Copyright© 2018 HCL Technologies Limited