Performance Measurement - Call-Level Interface Version 2

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

Product
Call-Level Interface Version 2
Release Number
15.00
Language
English (United States)
Last Update
2018-09-28
dita:id
B035-2417
lifecycle
previous
Product Category
Teradata Tools and Utilities

Performance Measurement

The Return‑time and Timing‑precision options can be used to determine the amount of time needed to process a request and its response from the perspective of the client. If Return‑time requests such timing, up to five timestamps are returned in Time1 through Time5. The determination of which timestamps are returned and to which points in the processing they apply are platform‑dependent. The returned Time1‑status through Time5‑status values indicate which Time values are valid. Each Time is four bytes long and contains an unsigned binary timestamp.

On mainframe‑connected systems:

  • Time1 is set when TDP accepts a request from CLIv2
  • Time2 is set when a request is passed to the Teradata Database
  • Time3 is set when the response is received from the server
  • Time4 is set when the response leaves TDP
  • Time5 is set when the response is placed into the CLIv2 response buffer.
  • The difference between two timestamps represents the elapsed time between the two points in processing. The precision for the timestamps is indicated by Timing‑precision. On mainframe‑connected systems, timestamps are formed by manipulating the IBM standard Time‑of‑Day (TOD) clock as indicated by the following Assembler code:

    STCK area
    LM R0,R1,area
    SR R15,R15
    IC R15,DBCITSP
    SRDL R0,12(R15)
    ST R1,DBCTIMEn

    Time1‑status through Time5‑status each contain a single EBCDIC character that indicates of the status of the corresponding Time. The status values are:

  • 'V' if the timestamp is valid
  • 'O' if the timestamp overflowed four-bytes
  • A ‘space’ or ‘binary zero’ if the timestamp is not valid