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
DB2 10.5 for Linux, UNIX, and Windows