Ensure These 4 Steps Before You Run DB2 Load

Below four steps you need to make sure before you start the LOAD process.

No sorting of the data rows occurs during LOAD processing. Rows are loaded in the physical sequence in which they are found. Sort your input records in clustering sequence before loading the data.

  1. Ensure that no duplicate keys exist for unique indexes.
  2. Correct check constraint violations and referential constraint violations in the input data set.
  3. Ensure that any input data that is provided for a security label column is a valid security label. Security label columns are defined with the AS SECURITY LABEL clause. These columns are used for multilevel security with row-level granularity.
  4. When loading data into a segmented table space, sort your data by table to ensure that the data is loaded in the best physical organization.

(Ref:IBM)

Related Posts

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.