16.20 - Changing the Value for Tell-if-delay - Teradata Tools and Utilities

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

prodname
Teradata Tools and Utilities
vrm_release
16.20
created_date
September 2019
category
Programming Reference
featnum
B035-2417-108K

When the value for Tell-if-delay is not appropriate for the application, you should perform the following procedure before calling DBCHCL.

  1. Set Change-options to 'Y'.
  2. Change the value for Tell-if-delay as follows.
    If CLIv2 is to... Then change the value for Tell-if-delay to...
    inform the application of a delay Y
    not inform the application of a delay N

If a restart occurs during a logoff request, CLIv2 reconnects the session and resubmits the logoff request.

Use mnemonics for the codes. Mnemonics are provided in the language definition file for the DBCAREA.

The Tell-if-delay and Wait-during-delay DBCAREA options interact as described in the following table.

Wait-during-delayWait-during-delay
  N Y
Tell-if-delay N Invalid The application is not informed of the delay and waits for the delay to end.
Tell-if-delay Y For delays due to loss of communication with or a restart of the Database, the application is informed that Tell-if-delay was honored with a final return code 286, and the session will be logged off when the Database becomes available (the request may or may not have executed). For delays by Database workload management, the application receives a response indicating the request was not executed rather than be delayed. The application is informed that Tell-if-delay was honored with a preliminary return code 286, and subsequently receives the response when the delay ends and the request is executed.