Error Types - Parallel Data Pump

Teradata® Parallel Data Pump Reference

Product
Parallel Data Pump
Release Number
16.20
Published
September 2019
Language
English (United States)
Last Update
2019-10-11
dita:mapPath
dmq1512702641516.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-3021
lifecycle
previous
Product Category
Teradata Tools and Utilities

Most errors are fatal, resulting in termination of Teradata TPump. The exceptions to this general rule are as follows:

  • User-specified SQL commands fail with no adverse effect. The variable &SYSRC is set, and if the script tests this variable it can stop the job if necessary.
  • Data-related errors in the database can reach the user-specified error limit before terminating the job. Beginning with Teradata Tools and Utilities 14.10, RDBMS returns a list of data-related error codes:
    • When the user does not have permission on the SYSLIB.DBSDATARELATEDERRORS view, TPump displays the DBS “no permission” message and an information message that the internal list of data-related errors will be used for the job, and sets the job's return code to four (assuming there are no other errors for the rest of the job).
    • For any other DBS errors in which the DBS did not restart, TPump displays the DBS error message and an information message that the internal list of data-related errors will be used for the job, and the job's return code remains unchanged.
    • In the rare instance that zero rows are returned from the SYSLIB.DBSDATARELATEDERRORS view, TPump displays an information message that zero rows were returned and that the internal list of data-related errors will be used for the job, and the job's return code remains unchanged.
    • When one or more rows are returned from the SYSLIB.DBSDATARELATEDERRORS view, TPump does not display any information about the DBS data-related error view and the job's return code remains unchanged. For the detailed information regarding the list of data-related errors codes, see Utilities (B035-1102).