Examples of LOADPLUS jobs

Each example includes the following information:

A description of the load job
The LOADPLUS job stream
The SYSPRINT from the job

Related topic

Some examples show additional information that might be useful to understand a particular feature or to see the results of the load.

All of these examples have the following common properties:

These examples use a single BMC product load library, assuming that this library contains the following files and libraries:
- LOADPLUS load files
- Common component load files that LOADPLUS requires
- SAS/C transient library (required for statistics processing)
When data sets are allocated in the JCL, these examples use minimal data set space allocations.
The value for the FILECHK installation option is set to WARN. This value prevents the jobs from failing when they encounter temporary data sets.

You can find copies of the JCL for these examples in members AMUEXnn in the HLQ.LLQCNTL installation data set (where nn is the number of the example, HLQ is the high-level qualifier set during installation, and LLQ is the low-level qualifier or prefix set during installation).

For syntax details, see Command-and-syntax-reference. For information about JCL statement requirements, see Building-the-LOADPLUS-job.

Use the following tables to locate an example with a specific load or object type, or one that uses a specific option.

Load type

Function	Relevant examples
REPLACE	Example 1 — LOAD REPLACE of a segmented table space Example 2 — LOAD REPLACE of a partitioned table space Example 4 — LOAD REPLACE of three tables Example 5 — LOAD REPLACE with data conversion Example 6 — LOAD REPLACE with multiple INTO statements Example 8 — LOAD REPLACE with ANALYZE PAUSE Example 11 — LOAD REPLACE with dynamic allocation Example 13 — LOAD REPLACE from CSV input Example 14 — LOAD REPLACE from UNLOAD PLUS data in internal format Example 15 — LOAD REPLACE ignoring indexes Example 17 — Loading into a Unicode table space from EBCDIC input Example 18 — LOAD REPLACE enforcing referential constraints Example 19 — LOAD REPLACE SHRLEVEL REFERENCE using FASTSWITCH Example 21 — Loading LOB and XML data
RESUME YES	Example 3 — Single-phase LOAD RESUME YES of a partitioned table space Example 12 — LOAD RESUME YES SHRLEVEL CHANGE SQLAPPLY of a partitioned table space Example 22 — Running a DSNUTILB load
RESUME YES PART n REPLACE	Example 9 — LOAD RESUME YES replacing individual partitions and updating indexes Example 20 — LOAD RESUME YES copying multiple partitions to a single copy data set
RESUME YES TABLE tableName REPLACE	Example 16 — LOAD RESUME YES replacing individual tables
RESUME NO	Example 7 — LOAD RESUME NO using DISCARDS options and user-defined return codes Example 10 — LOAD RESUME NO of table with check constraints
Single phase	Example 1 — LOAD REPLACE of a segmented table space Example 3 — Single-phase LOAD RESUME YES of a partitioned table space Example 13 — LOAD REPLACE from CSV input Example 14 — LOAD REPLACE from UNLOAD PLUS data in internal format Example 16 — LOAD RESUME YES replacing individual tables Example 18 — LOAD REPLACE enforcing referential constraints Example 19 — LOAD REPLACE SHRLEVEL REFERENCE using FASTSWITCH Example 20 — LOAD RESUME YES copying multiple partitions to a single copy data set Example 21 — Loading LOB and XML data Example 22 — Running a DSNUTILB load
Two phase	Example 1 — LOAD REPLACE of a segmented table space Example 2 — LOAD REPLACE of a partitioned table space Example 4 — LOAD REPLACE of three tables Example 5 — LOAD REPLACE with data conversion Example 6 — LOAD REPLACE with multiple INTO statements Example 7 — LOAD RESUME NO using DISCARDS options and user-defined return codes Example 8 — LOAD REPLACE with ANALYZE PAUSE Example 9 — LOAD RESUME YES replacing individual partitions and updating indexes Example 10 — LOAD RESUME NO of table with check constraints Example 11 — LOAD REPLACE with dynamic allocation Example 15 — LOAD REPLACE ignoring indexes Example 17 — Loading into a Unicode table space from EBCDIC input
CSV input	Example 13 — LOAD REPLACE from CSV input
UNLOAD PLUS input	Example 14 — LOAD REPLACE from UNLOAD PLUS data in internal format
XML input	Example 21 — Loading LOB and XML data
LOB input	Example 21 — Loading LOB and XML data
DSNUTILB load	Example 22 — Running a DSNUTILB load
SQLAPPLY load	Example 12 — LOAD RESUME YES SHRLEVEL CHANGE SQLAPPLY of a partitioned table space
User exit	Example 5 — LOAD REPLACE with data conversion

Object type

Function	Relevant examples
Partitioned table space	Example 2 — LOAD REPLACE of a partitioned table space Example 3 — Single-phase LOAD RESUME YES of a partitioned table space Example 5 — LOAD REPLACE with data conversion Example 8 — LOAD REPLACE with ANALYZE PAUSE Example 9 — LOAD RESUME YES replacing individual partitions and updating indexes Example 11 — LOAD REPLACE with dynamic allocation Example 12 — LOAD RESUME YES SHRLEVEL CHANGE SQLAPPLY of a partitioned table space Example 14 — LOAD REPLACE from UNLOAD PLUS data in internal format Example 15 — LOAD REPLACE ignoring indexes Example 20 — LOAD RESUME YES copying multiple partitions to a single copy data set Example 21 — Loading LOB and XML data Example 22 — Running a DSNUTILB load
Partition-by-growth table space	Example 10 — LOAD RESUME NO of table with check constraints
Segmented table space	Example 1 — LOAD REPLACE of a segmented table space Example 4 — LOAD REPLACE of three tables Example 6 — LOAD REPLACE with multiple INTO statements Example 7 — LOAD RESUME NO using DISCARDS options and user-defined return codes Example 13 — LOAD REPLACE from CSV input Example 16 — LOAD RESUME YES replacing individual tables Example 17 — Loading into a Unicode table space from EBCDIC input Example 18 — LOAD REPLACE enforcing referential constraints Example 19 — LOAD REPLACE SHRLEVEL REFERENCE using FASTSWITCH
Multi-table table space	Example 4 — LOAD REPLACE of three tables Example 16 — LOAD RESUME YES replacing individual tables Example 19 — LOAD REPLACE SHRLEVEL REFERENCE using FASTSWITCH
Compressed table space	Example 8 — LOAD REPLACE with ANALYZE PAUSE Example 9 — LOAD RESUME YES replacing individual partitions and updating indexes Example 16 — LOAD RESUME YES replacing individual tables Example 18 — LOAD REPLACE enforcing referential constraints Example 20 — LOAD RESUME YES copying multiple partitions to a single copy data set Example 21 — Loading LOB and XML data
Unicode table space	Example 17 — Loading into a Unicode table space from EBCDIC input
Clustering index, unique	Example 2 — LOAD REPLACE of a partitioned table space Example 3 — Single-phase LOAD RESUME YES of a partitioned table space Example 4 — LOAD REPLACE of three tables Example 7 — LOAD RESUME NO using DISCARDS options and user-defined return codes Example 8 — LOAD REPLACE with ANALYZE PAUSE Example 9 — LOAD RESUME YES replacing individual partitions and updating indexes Example 10 — LOAD RESUME NO of table with check constraints Example 11 — LOAD REPLACE with dynamic allocation Example 12 — LOAD RESUME YES SHRLEVEL CHANGE SQLAPPLY of a partitioned table space Example 13 — LOAD REPLACE from CSV input Example 15 — LOAD REPLACE ignoring indexes Example 18 — LOAD REPLACE enforcing referential constraints Example 19 — LOAD REPLACE SHRLEVEL REFERENCE using FASTSWITCH
Clustering index, non-unique	Example 5 — LOAD REPLACE with data conversion Example 16 — LOAD RESUME YES replacing individual tables Example 21 — Loading LOB and XML data
Nonclustering index, unique	Example 6 — LOAD REPLACE with multiple INTO statements Example 15 — LOAD REPLACE ignoring indexes Example 16 — LOAD RESUME YES replacing individual tables Example 18 — LOAD REPLACE enforcing referential constraints Example 21 — Loading LOB and XML data
Nonclustering index, non-unique	Example 2 — LOAD REPLACE of a partitioned table space Example 3 — Single-phase LOAD RESUME YES of a partitioned table space Example 4 — LOAD REPLACE of three tables Example 5 — LOAD REPLACE with data conversion Example 8 — LOAD REPLACE with ANALYZE PAUSE Example 9 — LOAD RESUME YES replacing individual partitions and updating indexes Example 11 — LOAD REPLACE with dynamic allocation Example 14 — LOAD REPLACE from UNLOAD PLUS data in internal format Example 15 — LOAD REPLACE ignoring indexes Example 18 — LOAD REPLACE enforcing referential constraints Example 19 — LOAD REPLACE SHRLEVEL REFERENCE using FASTSWITCH Example 20 — LOAD RESUME YES copying multiple partitions to a single copy data set
Partitioning, nonclustering index, non-unique	Example 14 — LOAD REPLACE from UNLOAD PLUS data in internal format
Index with random ordered keys	Example 22 — Running a DSNUTILB load
ASUSRPRT data set	Example 8 — LOAD REPLACE with ANALYZE PAUSE
ASUSRPRT DD DUMMY	Example 11 — LOAD REPLACE with dynamic allocation Example 20 — LOAD RESUME YES copying multiple partitions to a single copy data set

Command option

Function	Relevant examples
ACTIVE NO	Example 3 — Single-phase LOAD RESUME YES of a partitioned table space Example 8 — LOAD REPLACE with ANALYZE PAUSE
ACTIVE YES	Example 11 — LOAD REPLACE with dynamic allocation Example 16 — LOAD RESUME YES replacing individual tables Example 19 — LOAD REPLACE SHRLEVEL REFERENCE using FASTSWITCH Example 20 — LOAD RESUME YES copying multiple partitions to a single copy data set Example 21 — Loading LOB and XML data Example 22 — Running a DSNUTILB load
ANALYZE PAUSE	Example 8 — LOAD REPLACE with ANALYZE PAUSE
AND/OR condition	Example 4 — LOAD REPLACE of three tables
BLOBF	Example 21 — Loading LOB and XML data
BMCSTATS YES	Example 2 — LOAD REPLACE of a partitioned table space Example 11 — LOAD REPLACE with dynamic allocation
CCSID	Example 17 — Loading into a Unicode table space from EBCDIC input Example 21 — Loading LOB and XML data
CENTURY	Example 8 — LOAD REPLACE with ANALYZE PAUSE
CLOBF	Example 21 — Loading LOB and XML data
COPYDDN	Example 3 — Single-phase LOAD RESUME YES of a partitioned table space Example 9 — LOAD RESUME YES replacing individual partitions and updating indexes
COPY NO	Example 7 — LOAD RESUME NO using DISCARDS options and user-defined return codes Example 10 — LOAD RESUME NO of table with check constraints Example 13 — LOAD REPLACE from CSV input Example 15 — LOAD REPLACE ignoring indexes Example 22 — Running a DSNUTILB load
COPY YES	Example 1 — LOAD REPLACE of a segmented table space Example 2 — LOAD REPLACE of a partitioned table space Example 3 — Single-phase LOAD RESUME YES of a partitioned table space Example 4 — LOAD REPLACE of three tables Example 5 — LOAD REPLACE with data conversion Example 6 — LOAD REPLACE with multiple INTO statements Example 7 — LOAD RESUME NO using DISCARDS options and user-defined return codes Example 8 — LOAD REPLACE with ANALYZE PAUSE Example 9 — LOAD RESUME YES replacing individual partitions and updating indexes Example 10 — LOAD RESUME NO of table with check constraints Example 11 — LOAD REPLACE with dynamic allocation Example 12 — LOAD RESUME YES SHRLEVEL CHANGE SQLAPPLY of a partitioned table space Example 13 — LOAD REPLACE from CSV input Example 14 — LOAD REPLACE from UNLOAD PLUS data in internal format Example 15 — LOAD REPLACE ignoring indexes Example 16 — LOAD RESUME YES replacing individual tables Example 17 — Loading into a Unicode table space from EBCDIC input Example 18 — LOAD REPLACE enforcing referential constraints Example 19 — LOAD REPLACE SHRLEVEL REFERENCE using FASTSWITCH Example 20 — LOAD RESUME YES copying multiple partitions to a single copy data set Example 21 — Loading LOB and XML data Example 22 — Running a DSNUTILB load
COPYPEND NO	Example 13 — LOAD REPLACE from CSV input Example 22 — Running a DSNUTILB load
DDTYPE	Example 3 — Single-phase LOAD RESUME YES of a partitioned table space Example 8 — LOAD REPLACE with ANALYZE PAUSE Example 11 — LOAD REPLACE with dynamic allocation Example 12 — LOAD RESUME YES SHRLEVEL CHANGE SQLAPPLY of a partitioned table space Example 16 — LOAD RESUME YES replacing individual tables Example 19 — LOAD REPLACE SHRLEVEL REFERENCE using FASTSWITCH Example 20 — LOAD RESUME YES copying multiple partitions to a single copy data set Example 21 — Loading LOB and XML data Example 22 — Running a DSNUTILB load
DEFAULTIF	Example 5 — LOAD REPLACE with data conversion Example 6 — LOAD REPLACE with multiple INTO statements
DELETEFILES	Example 12 — LOAD RESUME YES SHRLEVEL CHANGE SQLAPPLY of a partitioned table space Example 14 — LOAD REPLACE from UNLOAD PLUS data in internal format Example 16 — LOAD RESUME YES replacing individual tables Example 20 — LOAD RESUME YES copying multiple partitions to a single copy data set
DISCARDDN	Example 3 — Single-phase LOAD RESUME YES of a partitioned table space Example 9 — LOAD RESUME YES replacing individual partitions and updating indexes
DISCARDS	Example 7 — LOAD RESUME NO using DISCARDS options and user-defined return codes Example 10 — LOAD RESUME NO of table with check constraints
DSNPAT	Example 11 — LOAD REPLACE with dynamic allocation Example 12 — LOAD RESUME YES SHRLEVEL CHANGE SQLAPPLY of a partitioned table space Example 21 — Loading LOB and XML data Example 22 — Running a DSNUTILB load
EBCDIC	Example 17 — Loading into a Unicode table space from EBCDIC input Example 21 — Loading LOB and XML data
ENFORCE CHECK CONSTRAINTS (ENFORCE=CHECK specified in installation options)	Example 10 — LOAD RESUME NO of table with check constraints
ENFORCE CONSTRAINTS	Example 18 — LOAD REPLACE enforcing referential constraints
ENUMROWS	Example 10 — LOAD RESUME NO of table with check constraints Example 12 — LOAD RESUME YES SHRLEVEL CHANGE SQLAPPLY of a partitioned table space Example 14 — LOAD REPLACE from UNLOAD PLUS data in internal format Example 19 — LOAD REPLACE SHRLEVEL REFERENCE using FASTSWITCH
ERRDDN	Example 3 — Single-phase LOAD RESUME YES of a partitioned table space Example 9 — LOAD RESUME YES replacing individual partitions and updating indexes
EXIT	Example 5 — LOAD REPLACE with data conversion
FASTSWITCH	Example 19 — LOAD REPLACE SHRLEVEL REFERENCE using FASTSWITCH
FORMAT BMCUNLOAD	Example 14 — LOAD REPLACE from UNLOAD PLUS data in internal format
FORMAT CSV	Example 13 — LOAD REPLACE from CSV input
IFALLOC	Example 11 — LOAD REPLACE with dynamic allocation
IFDISCARDS	Example 7 — LOAD RESUME NO using DISCARDS options and user-defined return codes
IGNORE	Example 7 — LOAD RESUME NO using DISCARDS options and user-defined return codes Example 10 — LOAD RESUME NO of table with check constraints
INDDN	Example 3 — Single-phase LOAD RESUME YES of a partitioned table space Example 9 — LOAD RESUME YES replacing individual partitions and updating indexes Example 10 — LOAD RESUME NO of table with check constraints Example 11 — LOAD REPLACE with dynamic allocation Example 12 — LOAD RESUME YES SHRLEVEL CHANGE SQLAPPLY of a partitioned table space Example 13 — LOAD REPLACE from CSV input Example 14 — LOAD REPLACE from UNLOAD PLUS data in internal format Example 15 — LOAD REPLACE ignoring indexes Example 16 — LOAD RESUME YES replacing individual tables Example 17 — Loading into a Unicode table space from EBCDIC input Example 18 — LOAD REPLACE enforcing referential constraints Example 19 — LOAD REPLACE SHRLEVEL REFERENCE using FASTSWITCH Example 20 — LOAD RESUME YES copying multiple partitions to a single copy data set Example 21 — Loading LOB and XML data Example 22 — Running a DSNUTILB load
INDEX UPDATE	Example 9 — LOAD RESUME YES replacing individual partitions and updating indexes
INDSN	Example 2 — LOAD REPLACE of a partitioned table space Example 14 — LOAD REPLACE from UNLOAD PLUS data in internal format
INLINE NO	Example 5 — LOAD REPLACE with data conversion Example 8 — LOAD REPLACE with ANALYZE PAUSE Example 9 — LOAD RESUME YES replacing individual partitions and updating indexes Example 11 — LOAD REPLACE with dynamic allocation Example 16 — LOAD RESUME YES replacing individual tables Example 19 — LOAD REPLACE SHRLEVEL REFERENCE using FASTSWITCH Example 20 — LOAD RESUME YES copying multiple partitions to a single copy data set
INTO TABLE (multiple)	Example 4 — LOAD REPLACE of three tables Example 6 — LOAD REPLACE with multiple INTO statements Example 9 — LOAD RESUME YES replacing individual partitions and updating indexes Example 19 — LOAD REPLACE SHRLEVEL REFERENCE using FASTSWITCH
INTO TABLE (one)	Example 1 — LOAD REPLACE of a segmented table space Example 2 — LOAD REPLACE of a partitioned table space Example 3 — Single-phase LOAD RESUME YES of a partitioned table space Example 5 — LOAD REPLACE with data conversion Example 7 — LOAD RESUME NO using DISCARDS options and user-defined return codes Example 8 — LOAD REPLACE with ANALYZE PAUSE Example 10 — LOAD RESUME NO of table with check constraints Example 11 — LOAD REPLACE with dynamic allocation Example 12 — LOAD RESUME YES SHRLEVEL CHANGE SQLAPPLY of a partitioned table space Example 13 — LOAD REPLACE from CSV input Example 14 — LOAD REPLACE from UNLOAD PLUS data in internal format Example 15 — LOAD REPLACE ignoring indexes Example 17 — Loading into a Unicode table space from EBCDIC input Example 18 — LOAD REPLACE enforcing referential constraints Example 20 — LOAD RESUME YES copying multiple partitions to a single copy data set Example 21 — Loading LOB and XML data Example 22 — Running a DSNUTILB load
INTO TABLE REPLACE	Example 16 — LOAD RESUME YES replacing individual tables
LOADDN	Example 3 — Single-phase LOAD RESUME YES of a partitioned table space Example 9 — LOAD RESUME YES replacing individual partitions and updating indexes
LOG NO	Example 2 — LOAD REPLACE of a partitioned table space Example 3 — Single-phase LOAD RESUME YES of a partitioned table space Example 4 — LOAD REPLACE of three tables Example 8 — LOAD REPLACE with ANALYZE PAUSE Example 9 — LOAD RESUME YES replacing individual partitions and updating indexes Example 11 — LOAD REPLACE with dynamic allocation Example 12 — LOAD RESUME YES SHRLEVEL CHANGE SQLAPPLY of a partitioned table space Example 15 — LOAD REPLACE ignoring indexes
NULLIF	Example 5 — LOAD REPLACE with data conversion Example 7 — LOAD RESUME NO using DISCARDS options and user-defined return codes Example 10 — LOAD RESUME NO of table with check constraints Example 13 — LOAD REPLACE from CSV input Example 20 — LOAD RESUME YES copying multiple partitions to a single copy data set Example 22 — Running a DSNUTILB load
ORDER NO	Example 3 — Single-phase LOAD RESUME YES of a partitioned table space Example 6 — LOAD REPLACE with multiple INTO statements Example 9 — LOAD RESUME YES replacing individual partitions and updating indexes Example 11 — LOAD REPLACE with dynamic allocation Example 12 — LOAD RESUME YES SHRLEVEL CHANGE SQLAPPLY of a partitioned table space
ORDER YES	Example 2 — LOAD REPLACE of a partitioned table space Example 4 — LOAD REPLACE of three tables Example 5 — LOAD REPLACE with data conversion Example 8 — LOAD REPLACE with ANALYZE PAUSE Example 12 — LOAD RESUME YES SHRLEVEL CHANGE SQLAPPLY of a partitioned table space Example 15 — LOAD REPLACE ignoring indexes Example 16 — LOAD RESUME YES replacing individual tables Example 18 — LOAD REPLACE enforcing referential constraints Example 19 — LOAD REPLACE SHRLEVEL REFERENCE using FASTSWITCH Example 20 — LOAD RESUME YES copying multiple partitions to a single copy data set
PART	Example 2 — LOAD REPLACE of a partitioned table space Example 9 — LOAD RESUME YES replacing individual partitions and updating indexes
PART REPLACE	Example 9 — LOAD RESUME YES replacing individual partitions and updating indexes Example 20 — LOAD RESUME YES copying multiple partitions to a single copy data set
POSITION ( start)	Example 1 — LOAD REPLACE of a segmented table space Example 5 — LOAD REPLACE with data conversion Example 6 — LOAD REPLACE with multiple INTO statements Example 7 — LOAD RESUME NO using DISCARDS options and user-defined return codes Example 10 — LOAD RESUME NO of table with check constraints Example 22 — Running a DSNUTILB load
POSITION (*)	Example 4 — LOAD REPLACE of three tables Example 7 — LOAD RESUME NO using DISCARDS options and user-defined return codes Example 10 — LOAD RESUME NO of table with check constraints Example 13 — LOAD REPLACE from CSV input Example 22 — Running a DSNUTILB load
PREFORMAT	Example 19 — LOAD REPLACE SHRLEVEL REFERENCE using FASTSWITCH
PRELOAD CONTINUE	Example 1 — LOAD REPLACE of a segmented table space Example 2 — LOAD REPLACE of a partitioned table space Example 4 — LOAD REPLACE of three tables Example 5 — LOAD REPLACE with data conversion Example 6 — LOAD REPLACE with multiple INTO statements Example 7 — LOAD RESUME NO using DISCARDS options and user-defined return codes Example 8 — LOAD REPLACE with ANALYZE PAUSE Example 9 — LOAD RESUME YES replacing individual partitions and updating indexes Example 10 — LOAD RESUME NO of table with check constraints Example 11 — LOAD REPLACE with dynamic allocation Example 15 — LOAD REPLACE ignoring indexes Example 17 — Loading into a Unicode table space from EBCDIC input
RECOVERYDDN	Example 3 — Single-phase LOAD RESUME YES of a partitioned table space Example 9 — LOAD RESUME YES replacing individual partitions and updating indexes
REDEFINE NO	Example 2 — LOAD REPLACE of a partitioned table space Example 8 — LOAD REPLACE with ANALYZE PAUSE Example 11 — LOAD REPLACE with dynamic allocation
REDEFINE YES	Example 6 — LOAD REPLACE with multiple INTO statements
REGISTER ddname	Example 5 — LOAD REPLACE with data conversion
REGISTER NONE	Example 2 — LOAD REPLACE of a partitioned table space Example 3 — Single-phase LOAD RESUME YES of a partitioned table space Example 8 — LOAD REPLACE with ANALYZE PAUSE Example 9 — LOAD RESUME YES replacing individual partitions and updating indexes
REPORT	Example 7 — LOAD RESUME NO using DISCARDS options and user-defined return codes Example 10 — LOAD RESUME NO of table with check constraints
SHRLEVEL CHANGE SQLAPPLY	Example 12 — LOAD RESUME YES SHRLEVEL CHANGE SQLAPPLY of a partitioned table space
SHRLEVEL REFERENCE	Example 1 — LOAD REPLACE of a segmented table space Example 19 — LOAD REPLACE SHRLEVEL REFERENCE using FASTSWITCH
SIZEPCT	Example 11 — LOAD REPLACE with dynamic allocation
SKIPFIELDS YES	Example 7 — LOAD RESUME NO using DISCARDS options and user-defined return codes Example 10 — LOAD RESUME NO of table with check constraints
SKIPIX	Example 15 — LOAD REPLACE ignoring indexes
SORTDEVT	Example 7 — LOAD RESUME NO using DISCARDS options and user-defined return codes Example 10 — LOAD RESUME NO of table with check constraints
SPACE	Example 22 — Running a DSNUTILB load
SWITCHTIME	Example 19 — LOAD REPLACE SHRLEVEL REFERENCE using FASTSWITCH
TABLE tableName REPLACE	Example 16 — LOAD RESUME YES replacing individual tables
THRESHLD	Example 11 — LOAD REPLACE with dynamic allocation
TRIM	Example 1 — LOAD REPLACE of a segmented table space Example 5 — LOAD REPLACE with data conversion
UNIQUECHECK NO	Example 9 — LOAD RESUME YES replacing individual partitions and updating indexes Example 20 — LOAD RESUME YES copying multiple partitions to a single copy data set
UNIQUEINTO YES	Example 4 — LOAD REPLACE of three tables
UNIT	Example 11 — LOAD REPLACE with dynamic allocation Example 20 — LOAD RESUME YES copying multiple partitions to a single copy data set Example 21 — Loading LOB and XML data Example 22 — Running a DSNUTILB load
UNITCNT	Example 11 — LOAD REPLACE with dynamic allocation
UPDATEDB2STATS	Example 2 — LOAD REPLACE of a partitioned table space Example 8 — LOAD REPLACE with ANALYZE PAUSE Example 11 — LOAD REPLACE with dynamic allocation Example 20 — LOAD RESUME YES copying multiple partitions to a single copy data set
VALUE	Example 5 — LOAD REPLACE with data conversion Example 6 — LOAD REPLACE with multiple INTO statements
VOLCNT	Example 11 — LOAD REPLACE with dynamic allocation
WHEN condition	Example 4 — LOAD REPLACE of three tables Example 5 — LOAD REPLACE with data conversion Example 7 — LOAD RESUME NO using DISCARDS options and user-defined return codes Example 10 — LOAD RESUME NO of table with check constraints Example 15 — LOAD REPLACE ignoring indexes Example 16 — LOAD RESUME YES replacing individual tables Example 19 — LOAD REPLACE SHRLEVEL REFERENCE using FASTSWITCH
WHEN TABLE= obid	Example 14 — LOAD REPLACE from UNLOAD PLUS data in internal format
WORKDDN	Example 3 — Single-phase LOAD RESUME YES of a partitioned table space Example 9 — LOAD RESUME YES replacing individual partitions and updating indexes
XBMID	Example 18 — LOAD REPLACE enforcing referential constraints

The following topics contain several examples of jobs that were run by using the LOADPLUS product:

Examples of LOADPLUS jobs

On this page