Before running LOAD

Certain activities might be required before you run the LOAD utility, depending on your situation.

You cannot run the LOAD utility on the DSNDB01 or DSNDB06 databases, except to add rows to the following catalog tables:

  • SYSSTRINGS
  • MODESELECT
  • LUMODES
  • LULIST
  • USERNAMES
  • LUNAMES
  • LOCATIONS
  • IPNAMES

If you are using LOAD for a partition-by-growth table space, you can load data only at the table space level, not at the partition level.

Preprocessing input data

No sorting of the data rows occurs during LOAD processing. Rows are loaded in the physical sequence in which they are found.

Recommendation: Sort your input records in clustering sequence before loading the data.

You should also:

  • Ensure that no duplicate keys exist for unique indexes.
  • Correct check constraint violations and referential constraint violations in the input data set.
  • 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.

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.

Loading data by using a cursor

Begin general-use programming interface information.

Before you can load data by using a cursor, you need to bind the DSNUT101 package at each location from which you plan to load data. A local package for DSNUT101 is bound by installation job DSNTIJSG when you install or migrate to a new version of DB2® for z/OS®.

The following example statement binds the DSNUT101 package at a remote location: 

BIND PACKAGE(location.DSNUT101) 
         MEMBER(DSNUGSQL) -
         ACTION(REPLACE) ISOLATION(CS) ENCODING(EBCDIC) -
         VALIDATE(BIND) CURRENTDATA(NO) -
         LIBRARY('prefix.SDSNDBRM')

End general-use programming interface information.

Start of change

Running LOAD on a table with a spatial index

You cannot run the LOAD utility to load data into a table on which a spatial index is defined. You need to drop the spatial index, run LOAD on the table, and then create the spatial index again.

End of change