Application Behavior When SET CRASH = NOWAIT_TELL - Teradata VantageCloud Lake

Lake - Working with SQL

Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2025-11-21
dita:mapPath
jbe1714339405530.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
jbe1714339405530
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 gets 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.