Hello, I could not find any request endtime, starttime on Sybase IQ. Althought ,I have found some requests in the "Ctx" table, i could'nt see any reference to a request duration. juste the timestamp. Does this field exist ?
Regards, Jean-Daniel
Hi, unfortunately this information (starttime, endtime) is not directly available for asemon today. This info exists in the IQ SQL trace but asemon doesn't exploit it. New IQ versions have procedures to read it but there are still problems for asemon to use this. Anyway, update your asemon to the latest version (V3 can directly archive into IQ V16, using RLV store)
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
my version is Asemon Report V2.7.9. Should i upgrade it ? is this field available in a newer version ?
Hi, unfortunately this information (starttime, endtime) is not directly available for asemon today. This info exists in the IQ SQL trace but asemon doesn't exploit it. New IQ versions have procedures to read it but there are still problems for asemon to use this. Anyway, update your asemon to the latest version (V3 can directly archive into IQ V16, using RLV store)