DB2 Server for VSE & VM: Database Services Utility

Return Codes

Although one or more of the following return codes may be encountered during Database Services Utility processing, one final return code is provided at the end of processing (the highest return code found). The following is a list of the return codes:

0

All commands processed successfully.

4

All requested processing completed successfully, and all changes were committed to the database. This return code indicates that an error occurred during Database Services Utility termination; no SQL or Database Services Utility commands need to be reprocessed.

6

One or more errors have occurred in command processing while SET ERRORMODE CONTINUE was in effect.

8

Database Services Utility processing error encountered. From the point of error, no further commands were executed, but subsequent Database Services Utility commands were checked for syntax errors.

If a Database Services Utility SET ERRORMODE OFF command is encountered before the end of the (input) control file is reached, normal Database Services Utility command processing is resumed.

12

Input control card or Control command file-open-error. No commands are processed.

16

Report or Message file-open-error. No commands are processed.

20

Initialization error. Sufficient processor storage was not available for Database Services Utility working storage areas. No commands are processed.

The type of ERRORMODE processing in effect at the time of a command processing error determines the final return code. If both ERRORMODE OFF and ERRORMODE CONTINUE processing are used within one (input) control file (either by default or through a SET ERRORMODE command), one of the following scenarios can exist:

• If an error occurs during ERRORMODE CONTINUE, the final return code is 6.
• If an error occurs during ERRORMODE OFF, the final return code is 8.
• If an error occurs during both ERRORMODE CONTINUE and ERRORMODE OFF, the final return code is 8.