Application Behavior When SET CRASH = WAIT_NOTELL - Teradata Vantage - Analytics Database

SQL Stored Procedures and Embedded SQL

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2023-10-30
dita:mapPath
frc1628111662093.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
rjx1472253414573
lifecycle
latest
Product Category
Teradata Vantageā„¢
The behavior of embedded SQL applications when a node resets, SET CRASH = WAIT_NOTELL, and the application is running on any of the following environments is explained following the list:
  • Non-resetting node
  • Workstation-attached client
  • Mainframe-attached client

The application reconnects its session and returns one of the following error codes from the database; the embedded SQL application takes action appropriate to the error condition:

Code Description
Error 2825 No record of the last request found after Teradata Database restart.
Error 2826 Request completed but all output was lost due to Teradata Database restart.
Error 2828 Request was rolled back during Teradata Database recovery.
Error 3120 Request aborted because of a Teradata Database recovery.