Handling RDBMS Retryable and Restartable Error Codes | Teradata FastLoad - 17.10 - Handling RDBMS Retryable and Restartable Error Codes - FastLoad

Teradata® FastLoad Reference

Product
FastLoad
Release Number
17.10
Published
June 2021
Last Update
2021-07-01
Content Type
Programming Reference
Publication ID
B035-2411-061K
Language
English (United States)
Beginning with Teradata Tools and Utilities 14.10, RDBMS returns a list of retryable error codes:
  • When the user does not have permission on the SYSLIB.DBSRETRYABLEERRORS view, Teradata FastLoad displays the database “no permission” message and an information message that the internal list of retryable will be used for the job, and sets the job's return code to 4 (assuming there are no other errors for the rest of the job).
  • When Teradata FastLoad 14.10 (or later) runs with Teradata Database version prior to 14.10, Teradata FastLoad displays “RDBMS error 3807: Object 'SYSLIB.DBSRETRYABLEERRORS' does not exist” and “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, FastLoad 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, FastLoad does not display any information about the database data-related error view, and the job's return code remains unchanged.

For more information regarding the list of retryable errors codes, see Teradata Vantage™ - Database Utilities, B035-1102.