Utility products for DB2 return codes

The following return codes indicate the completion status of a Utility products for DB2 job:

Note

LOADPLUS, REORG PLUS, and UNLOAD PLUS provide options that you can use to specify a user-defined return code for specific situations. For more information about these options, see the reference manual for the utility that you are running.

Code

Description

0

With the following exceptions, the utility executed successfully with no warnings or errors.

LOADPLUS issues an error message (E) but ends with return code 0 when any of the following conditions occur:

  • LOADPLUS discards records during the load job.
  • You specify FORMAT BMCUNLOAD and the input file contains only verification records that do not match any of the tables being loaded. In this case, LOADPLUS does not load any records.

4

The utility executed successfully but warnings were issued. For example, some of the conditions for which LOADPLUS generates return code 4 are:

  • when setting COPY pending or CHECK pending
  • when setting REBUILD pending for a skipped index

The utility also generates a return code 4 when processing is incomplete. For example, a pause after a specific phase (such as when you specify ANALYZE PAUSE) causes incomplete execution.

8

Utility execution failed.

12

Utility execution failed.

16

Utility execution failed.

other

Utility execution stopped, and you used a command option to override the default return code.

 

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