[ids]Cumulative query time

Posted in 2003

Rob Ferguson — Thu, 16 Jan 2003 17:45:21 — source: IIUG Forums & Mailing Lists

Hi all, I need to identify long running queries against IDS7.31.UD4 (Solaris 8). These queries are coming from BroadVision, so an Informix session doesn't correspond 1:1 with user sessions (connection pooling). I had intended to use sysmaster:syssqexplain.sqx_cumtime as a metric, but this seems to always be 0.00 Can someone explain how to identify how long (elapsed time, system time, whatever) a query has run for? Or how to ensure sqx_cumtime is incremented Thanks in advance, Rob

↪ replying to Rob Ferguson

Rob Ferguson — Thu, 16 Jan 2003 22:06:25 — source: IIUG Forums & Mailing Lists

Unfortunately, the problem is on a production server, and there's insufficient time to seek approval for deployment of a new component (isn't life great?). I wouldn't mind learning about ISPY though! Sounds like it may be useful in future! Cheers Rob -----Original Message----- From: RICK FAHEY [mailto:rlfahey@west.com] Sent: 16 January 2003 21:26 To: ids@iiug.org Subject: Re: Cumulative query time [17] [19] Have you looked into ISPY?