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.