17.10 - Recovery Flags - Call-Level Interface Version 2

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

Product
Call-Level Interface Version 2
Release Number
17.10
Release Date
October 2021
Content Type
Programming Reference
Publication ID
B035-2418-061K
Language
English (United States)
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.