Catching runnig SQLs

Hi I want to catch running SQLs with their memory usage, time it was started and ended alongiwth username ,session id and if possible any information on unix pid. Is their a standard routine , script available for this? how can I do this? Connections are over TCP and shared memory too. Informix 7.31, HP-UX 11x Mukund sending to informix-list

Consider using I-Spy. See http://www-306.ibm.com/software/data/informix/tools/ispy/ From the manual: I-Spy provides the following query monitoring and control features: - Logging SQL statement text and various statistics related to the statement, such as total time of execution, number of rows returned, length of the returned row, and so on - Logging the start and end time of all client connections An Informix activity database records all logged information. You can access the logged information with SQL queries and standard reports. - Adding the EXPLAIN output text to the activity database so that you can see the query plan - Using a rules system to place constraints on individual SQL statements The rules specify actions to be performed based on the total query time, the number of rows returned, or the actual text of the SQL statement. Shevkar, Mukund wrote: > Hi > I want to catch running SQLs with their memory usage, time it was started and ended alongiwth username ,session id and if possible any information on unix pid. Is their a standard routine , script available for this? how can I do this? > Connections are over TCP and shared memory too. > Informix 7.31, HP-UX 11x > > Mukund > > sending to informix-list

On Wed, 11 Aug 2004 10:32:31 +0200, Claus Samuelsen <csa@eye-bee-em.com> wrote: >Consider using I-Spy. > Does I-Spy "listen" shared memory connection2?? >> Hi >> I want to catch running SQLs with their memory usage, time it was started and ended alongiwth username ,session id and if possible any information on unix pid. Is their a standard routine , script available for this? how can I do this? >> Connections are over TCP and shared memory too. >> Informix 7.31, HP-UX 11x >> >> Mukund >> >> sending to informix-list ------------------------------------ Remove spam block (DELETE_) to reply

Nebojsa Sevo wrote: > On Wed, 11 Aug 2004 10:32:31 +0200, Claus Samuelsen <csa@eye-bee-em.com> wrote: > > >>Consider using I-Spy. >> > > Does I-Spy "listen" shared memory connection2?? No, shared memory and stream pipe connections are not supported, so clients must be set up to use a network protocol connection. Also multiplexed connections and connections using XA are not supported. > > >>>Hi >>>I want to catch running SQLs with their memory usage, time it was started and ended alongiwth username ,session id and if possible any information on unix pid. Is their a standard routine , script available for this? how can I do this? >>>Connections are over TCP and shared memory too. >>>Informix 7.31, HP-UX 11x >>> >>>Mukund >>> >>>sending to informix-list > > > ------------------------------------ > Remove spam block (DELETE_) to reply

in regards to I-Spy - can anyone give their two cents worth? kind of expensive -is it worth it? how well does it work? not work? Tom Claus Samuelsen <csa@eye-bee-em.com> wrote in message news:<4119d9a2$0$73936$14726298@news.sunsite.dk>... > Consider using I-Spy. > > See http://www-306.ibm.com/software/data/informix/tools/ispy/ > > From the manual: > > I-Spy provides the following query monitoring and control features: > - Logging SQL statement text and various statistics related to the > statement, such as total time of execution, number of rows returned, > length of the returned row, and so on > - Logging the start and end time of all client connections > An Informix activity database records all logged information. You > can access the logged information with SQL queries and standard > reports. > - Adding the EXPLAIN output text to the activity database so that you > can see the query plan > - Using a rules system to place constraints on individual SQL > statements > > The rules specify actions to be performed based on the total query > time, the number of rows returned, or the actual text of the SQL > statement. > > Shevkar, Mukund wrote: > > > Hi > > I want to catch running SQLs with their memory usage, time it was started and ended alongiwth username ,session id and if possible any information on unix pid. Is their a standard routine , script available for this? how can I do this? > > Connections are over TCP and shared memory too. > > Informix 7.31, HP-UX 11x > > > > Mukund > > > > sending to informix-list

"tomL" <tomcaml@yahoo.com> wrote in message news:3158a6a2.0408111300.13422459@posting.google.com... > in regards to I-Spy - can anyone give their two cents worth? kind of > expensive -is it worth it? > how well does it work? not work? Well I've just looked up the price for you and it's '6,848 per processor (that's about 4 million US dollars given the sad state of your currency I think!) - although Ardenta could knock 5 pounds off for a quick order. Is it worth it? depends how deep and cloying is the shit you're in. We used it once, on a major, multi-million pound development project where volume testing had shown up some performance issues, and it did help highlight some issues. It generates stupendous amounts of data, slowly, so you have to be systematic and organised about exactly what functions you're going to analyse and for how long, with what aim etc ... -- Neil Truby t:01932 724027 Director m:07798 811708 Ardenta Limited e:neil.truby@ardenta.com