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
Published
October 2021
Language
English (United States)
Last Update
2021-11-02
dita:mapPath
ttt1608578409164.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2418
lifecycle
previous
Product Category
Teradata Tools and Utilities
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.