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 UNLOAD PLUS for DB2 13.1.

Examples of UNLOAD PLUS jobs

Each example includes the following information:

  • A description of the unload job
  • The UNLOAD PLUS 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 unload job.

All of these examples have the following common properties:

  • These examples use a single BMC product load library, assuming that this library contains the UNLOAD PLUS load files and the common component load files that UNLOAD PLUS requires.
  • The examples use minimal data set space allocations in the JCL.

You can find copies of the JCL for these examples in members ADUXMnn (where nn is the example number) in the HLQ.LLQCNTL installation data set (where HLQ is the high-level qualifier specified during installation and LLQ is the low-level qualifier or prefix set during installation). The HLQ.LLQCNTL data set also includes the member ADUXM00 that contains the following elements:

  • DDL for the table spaces
  • Sample data to load into the table spaces
  • Load jobs to load the data

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

Use the following table to locate an example of a specific unload type or option:

Functions

Relevant examples

Unload features

Change overpunch values during unload

Convert data during unload

2, 17, 18

Translate data during unload

Create a new field during unload

Use multiple SELECT statements

3, 4, 8, 9, 11, 13

Unload from prior image copy

Unload an entire table space

Use a DDLIN file

Unload to a CSV file

Unload to Unicode format

Unload selected columns

2, 4, 8, 13, 15

Unload selected partitions

5, 6, 10

Unload selected rows

4, 5, 6, 7, 13, 14

Use a subselect to unload selected rows

Use a join to unload selected rows

Use columnar functions during unload

Unload using DB2 dynamic SQL

13, 14, 15

Handle an abnormal termination

Specify a nonstandard null indicator

Unload zoned decimal data

Use high-speed data migration with LOADPLUS

Unload XML data

Unload LOB data

Write to referenced files

Object types

Nonpartitioned table space

3, 8, 9, 11, 13, 14, 15, 17, 18

Partitioned table space

1, 2, 4, 5, 6, 7, 9, 10, 12, 16, 19

DSN1COPY

Full image copy

Incremental image copy

Command options

ACTIVE NO

10, 12, 13, 14, 17, 18

ACTIVE YES

ANALYZE DB2STATS

AUTOTAG

CNTLCARDS

3, 5, 7, 8, 13, 15, 17, 18, 19

CNTLDDN

CONSISTENT YES

CURRENTDEGREE

DATEFMT

DELETEFILES

DIR

DIRECT NO

13, 14, 15

DIRECT YES

DSNAME

7, 9, 15, 16, 19

DSNTYPE

ENUMROWS

ESTROWS

FILTERPART

FORMAT

12, 15, 17, 19

FIXEDVARCHAR

2, 17

IF NULL VALUE or IF predicate VALUE

IMAGECOPY

6, 10

INCREMENTAL

INFILE

5, 6, 10, 11

INTERVAL

INTO

1, 2, 3, 8, 15, 16, 17,19

LIMIT

2, 4

NULLCHAR

NULLTYPE

OBID

5, 11

ON FAILURE

ORDER YES

2, 3, 19

ORDER BY

6, 9

OUTPUT

7, 9, 15, 16, 19

PART

5, 6, 10

RECORDID

RETCODE

SELECT

All examples except 18

SHRLEVEL CHANGE

SORTDEVT

SPACE

15, 16, 19

SUBSETS

TABLESPACE

TSFMT

UNLOADDN

8, 10, 12, 13, 14, 16, 17, 18

UNICODE

UNIT

15, 16, 19

WHERE clause

4, 5, 6, 7, 14

XBMID

ZONEDDECOVP

The following topics present several examples of jobs for the UNLOAD PLUS product:

Related topics

Running-UNLOAD-PLUS-jobs

Tuning-UNLOAD-PLUS-jobs

Building-the-UNLOAD-PLUS-job

 

 

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