Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see LOADPLUS for DB2 13.1.

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

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

1, 2, 4, 5, 6, 8, 11, 13, 14, 15, 17, 18, 19, 21

RESUME YES

3, 12, 22

RESUME YES PART n REPLACE

9, 20

RESUME YES TABLE tableName REPLACE

RESUME NO

7, 10

Single phase

1, 3, 13, 14, 16, 18, 19, 20, 21, 22

Two phase

1, 2, 4, 5, 6, 7, 8, 9, 10, 11, 15, 17

CSV input

UNLOAD PLUS input

XML input

LOB input

DSNUTILB load

SQLAPPLY load

User exit

Object type

Function

Relevant examples

Partitioned table space

2, 3, 5, 8, 9, 11, 12, 14, 15, 20, 21, 22

Partition-by-growth table space

Segmented table space

1, 4, 6, 7, 13, 16, 17, 18, 19

Multi-table table space

4, 16, 19

Compressed table space

8, 9, 16, 18, 20, 21

Unicode table space

Clustering index, unique

2, 3, 4, 7, 8, 9, 10, 11, 12, 13, 15, 18, 19

Clustering index, non-unique

5, 16, 21

Nonclustering index, unique

6, 15, 16, 18, 21

Nonclustering index, non-unique

2, 3, 4, 5, 8, 9, 11, 14, 15, 18, 19, 20

Partitioning, nonclustering index, non-unique

Index with random ordered keys

ASUSRPRT data set

ASUSRPRT DD DUMMY

Command option

Function

Relevant examples

ACTIVE NO

3, 8

ACTIVE YES

11, 16, 19, 20, 21, 22

ANALYZE PAUSE

AND/OR condition

BLOBF

BMCSTATS YES

2, 11

CCSID

CENTURY

CLOBF

COPYDDN

3, 9

COPY NO

7, 10, 13, 15, 22

COPY YES

1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22

COPYPEND NO

DDTYPE

3, 8, 11, 12, 16, 19, 20, 21, 22

DEFAULTIF

5, 6

DELETEFILES

12, 14, 16, 20

DISCARDDN

3, 9

DISCARDS

7, 10

DSNPAT

11, 12, 21, 22

EBCDIC

ENFORCE CHECK CONSTRAINTS (ENFORCE=CHECK specified in installation options)

ENFORCE CONSTRAINTS

ENUMROWS

10, 12, 14, 19

ERRDDN

3, 9

EXIT

FASTSWITCH

FORMAT BMCUNLOAD

FORMAT CSV

IFALLOC

IFDISCARDS

IGNORE

7, 10

INDDN

3, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22

INDEX UPDATE

INDSN

2, 14

INLINE NO

5, 8, 9, 11, 16, 19, 20

INTO TABLE (multiple)

4, 6, 9, 19

INTO TABLE (one)

1, 2, 3, 5, 7, 8, 10, 11, 12, 13, 14, 15, 17, 18, 20, 21, 22

INTO TABLE REPLACE

LOADDN

3, 9

LOG NO

2, 3, 4, 8, 9, 11, 12, 15

NULLIF

5, 7, 10, 13, 20, 22

ORDER NO

3, 6, 9, 11, 12

ORDER YES

2, 4, 5, 8, 12, 15, 16, 18, 19, 20

PART

2, 9

PART REPLACE

9, 20

POSITION ( start)

1, 5, 6, 7, 10, 22

POSITION (*)

4, 7, 10, 13, 22

PREFORMAT

PRELOAD CONTINUE

1, 2, 4, 5, 6, 7, 8, 9, 10, 11, 15, 17

RECOVERYDDN

3, 9

REDEFINE NO

2, 8, 11

REDEFINE YES

REGISTER ddname

REGISTER NONE

2, 3, 8, 9

REPORT

7, 10

SHRLEVEL CHANGE SQLAPPLY

SHRLEVEL REFERENCE

1, 19

SIZEPCT

SKIPFIELDS YES

7, 10

SKIPIX

SORTDEVT

7, 10

SPACE

SWITCHTIME

TABLE tableName REPLACE

THRESHLD

TRIM

1, 5

UNIQUECHECK NO

9, 20

UNIQUEINTO YES

UNIT

11, 20, 21, 22

UNITCNT

UPDATEDB2STATS

2, 8, 11, 20

VALUE

5, 6

VOLCNT

WHEN condition

4, 5, 7, 10, 15, 16, 19

WHEN TABLE= obid

WORKDDN

3, 9

XBMID

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

Related topic

Command-and-syntax-reference

 

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*