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.
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

Before you can load data by using a cursor, you need to bind the DSNUT111 package at each location from which you plan to load data. A local package for DSNUT111 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 DSNUT111 package at a remote location:
BIND PACKAGE(location.DSNUT111)
MEMBER(DSNUGSQL) -
ACTION(ADD) ISOLATION(CS) ENCODING(EBCDIC) -
VALIDATE(BIND) CURRENTDATA(NO) -
LIBRARY('prefix.SDSNDBRM')
You can
improve the performance of cross-loading from a remote Db2 for z/OS
Db2 11 subsystem in new-function mode to a
local Db2 for z/OS
Db2 11 subsystem in new-function mode by
binding the DSNUTIL and DSNUT111 packages
again on the local and remote subsystems with the DBPROTOCOL(DRDACBF) option after you have
converted to new-function mode.
The following example statements bind the DSNUTIL and
DSNUT111 packages on the local subsystem,
and bind the DSNUT111 package on the remote
subsystem:

BIND PACKAGE(DSNUTIL) MEMBER(DSNUGSQL) -
ACTION(ADD) ISOLATION(CS) ENCODING(EBCDIC) -
VALIDATE(BIND) CURRENTDATA(NO) -
DBPROTOCOL(DRDACBF) -
LIBRARY('prefix.SDSNDBRM')
BIND PACKAGE(DSNUT111) MEMBER(DSNUGSQL) -
ACTION(ADD) ISOLATION(CS) ENCODING(EBCDIC) -
VALIDATE(BIND) CURRENTDATA(NO) -
DBPROTOCOL(DRDACBF) -
LIBRARY('prefix.SDSNDBRM')
BIND PACKAGE(location.DSNUT111) MEMBER(DSNUGSQL) -
ACTION(ADD) ISOLATION(CS) ENCODING(EBCDIC) -
VALIDATE(BIND) CURRENTDATA(NO) -
DBPROTOCOL(DRDACBF) -
LIBRARY('prefix.SDSNDBRM')

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.