Sergio:
Of the "time" columns in syssqltrace, the sql_begintxtime is the internal transaction "time" and not related to a clock time or eleased time.
The colunm sql_finishtime contains the UNIX Epoch in seconds which you can convert to a time with dbinfo('utc_to_datetime', sql_finishtime).
The columns sql_runtime , sql_lockwttime, sql_totaltime , sql_avgtime, sql_maxtime contain fractional elapsed seconds for the query for run time, lock wait time, average run time (when a query has multiple executions), and maximum runtime (when a query has multiple executions) respectively.
------------------------------
Art S. Kagel, President and Principal Consultant
ASK Database Management Corp.
www.askdbmgt.com------------------------------
Original Message:
Sent: Thu January 14, 2021 09:07 AM
From: Sergio Peres
Subject: syssqltrace time fields
Hi,
Over syssqltrace table there are some fields about time execution and others, how can I get this values in seconds?
Thanks for any help.
Best regards,
SP
------------------------------
Sergio Peres
AIRC
Coimbra
------------------------------
#Informix