Load features for maintaining referential integrity

Although the load utility is typically more efficient than the import utility, it requires a number of features to ensure the referential integrity of the information being loaded:
  • Table locks, which provide concurrency control and prevent uncontrolled data access during a load operation
  • Table states and table space states, which can either control access to data or elicit specific user actions
  • Load exception tables, which ensure that rows of invalid data are not simply deleted without your knowledge