Handling RDBMS Retryable and Restartable Error Codes - FastExport

Teradata® FastExport Reference - 20.00

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
FastExport
Release Number
20.00
Published
October 2023
ft:locale
en-US
ft:lastEdition
2024-03-18
dita:mapPath
jaa1691573250507.ditamap
dita:ditavalPath
gel1618411995444.ditaval
dita:id
rto1478610027076
Product Category
Teradata Tools and Utilities

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 FastExport displays the database “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 FastExport 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 FastExport 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 FastExport does not display any information about the database data-related error view and the job's return code remains unchanged.

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