Application Behavior When SET CRASH = NOWAIT_TELL - 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 and SET CRASH = NOWAIT_TELL for the following environments:
  • Non-resetting node
  • Workstation-attached client
  • Mainframe-attached client

is explained as follows:

The application immediately disconnects the session and the application receives one of the following CLI error codes:

Code Description
Error 219 (EM_DBC_CRASH_B) Server connection lost (network or server problem).
Error 220 (EM_DBC_CRASH_A)

An implicit CLI DISCONNECT request is issued to release any CLI resources tied to the crashed request and session. Any outstanding cursor and dynamic statement resources tied to the crashed session are also released.