17.10 - Overview - 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)
This section explains how timestamps are used to measure various CLIv2 processing times. The time taken to process a request and its response, from the perspective of the client, may be obtained by setting the following fields:
  • DBCAREA field 'ret_time' to 'Y'
  • DBCAREA field 'dbciTSP' to the desired precision

Timestamps are returned in Time1 and Time5. Time1-status and Time5-status values indicate validity of these timestamps. Each Time field is four bytes long and contains an unsigned binary timestamp.

The difference between two timestamps represents the time taken for processing. Time1 is set when CLI sends a request to the database. Depending on the precision requested by the application, Time1 stores the timestamp in seconds, milliseconds, or microseconds.