Termination Return Codes

Teradata Parallel Data Pump Reference

brand
Teradata Tools and Utilities
prodname
Parallel Data Pump
vrm_release
15.00
category
Programming Reference
featnum
B035-3021-034K

Termination Return Codes

When a Teradata TPump job terminates, it returns a completion code to the client system.

Table 21 lists the conventions used.

 

Table 21: Termination Return Codes 

Code

Description

0

Normal completion

4

Warning

8

User error

12

Severe internal error

16

No message destination is available

Note: Teradata TPump continues receiving all Teradata Database warnings. The return code is 4. To avoid ambiguous or conflicting results, always use values greater than 20 when specifying a return code with the LOGOFF command.

Many CLI and Teradata Database errors generate return codes of 12. For Teradata Database errors that can be corrected and resubmitted, Teradata TPump tries up to 16 times to resubmit and, at the end of this process, returns a code of 12. Many CLI and Teradata Database errors generate the return code of 12, except for:

  • Errors on Teradata SQL statements outside of the Teradata TPump task (before the BEGIN LOAD command or after the END LOAD command). Teradata TPump ignores these errors, which display error messages but do not cause early termination, nor generate Teradata TPump return codes.
  • Retry-able errors or errors caused by Teradata Database restarts.