Application Behavior When SET CRASH = NOWAIT_TELL - Advanced SQL Engine - Teradata Database

SQL Stored Procedures and Embedded SQL

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-28
dita:mapPath
vqj1592443206677.ditamap
dita:ditavalPath
vqj1592443206677.ditaval
dita:id
B035-1148
lifecycle
previous
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.