Handling RDBMS Retryable and Restartable Error Codes - MultiLoad

Teradata® MultiLoad Reference

Product
MultiLoad
Release Number
16.20
Published
October 2018
Language
English (United States)
Last Update
2018-10-10
dita:mapPath
lsl1527114222348.ditamap
dita:ditavalPath
Audience_PDF_product_tpt_userguide_include.ditaval
dita:id
B035-2409
lifecycle
previous
Product Category
Teradata Tools and Utilities
  • When the user does not have permission on the SYSLIB.DBSRETRYABLEERRORS view, Teradata MultiLoad displays the DBS “no permission” message and an information message that the internal list of retryable will be used for the job, and set the job's return code to 4 (assuming there are no other errors for the rest of the job).
  • When Teradata MultiLoad 14.10 (or later) runs with a database prior to 14.10, it displays “RDBMS error 3807:Object 'SYSLIB.DBSRETRYABLEERRORS' does not exist” and an information message to the user that “The job will use its internal retryable error codes,” and the job's return code remains unchanged.
  • In the rare instance that zero rows are returned from the SYSLIB.DBSRETRYABLEERRORS view, Teradata MultiLoad displays an information message that zero rows were returned and that the internal list of retryable 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.DBSRETRYABLEERRORS view, Teradata MultiLoad does not display any information about the DBS data-related error view and the job's return code remains unchanged.

Beginning with Teradata Tools and Utilities 14.10, Teradata MultiLoad uses a list of retryable error codes returned by RDBMS

For detailed information regarding the list of retryable errors codes, see Utilities (B035-1022).