Recovery Flags - Call-Level Interface Version 2

Teradata® Call-Level Interface Version 2 Reference for Workstation-Attached Systems - 20.00

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Call-Level Interface Version 2
Release Number
20.00
Published
January 2024
Language
English (United States)
Last Update
2024-05-14
dita:mapPath
bmn1691484839905.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
fvz1470444150352
Product Category
Teradata Tools and Utilities
From DBCHCL, the method of recovery is controlled by two options flags:
  1. Recovery flag, which determines whether MTDP should be allowed to try to automatically reconnect the session
  2. Report option, which determines if the crash should be reported to the application

If a crash occurs for a transaction with a recovery flag set to N, MTDP is not allowed to reconnect automatically and an error message is returned to the application, regardless of the setting of the report option.

If the recovery option is set to Y, an automatic recovery will only be attempted if the report flag is set to N, or the session state flag maintained in the SCB indicates the session was already crashed and the report flag is Y.

If the session was not crashed, the recovery flag was Y and the report flag was Y, an error message is returned to the application. The application would normally turn the report flag off and redrive the transaction to reconnect the session.

Any time MTDP returns an error indicating the session crashed, the state flag of the associated SCB is set to reflect that the session is no longer connected to the database.