Re: real-time monitoring of SQL commands?

From: Matthew Cornell <cornell@cs.umass.edu> > >I'm running IDS.2000 9.20.UC1 on RH6.2. While my Java program is running >I'd >like a utility that lets me monitor the full/exact SQL commands that it >issues. Is there such a beast? I know of onstat -g sql -r 1, but it only >lists the *type* of command, not the whole thing. Plus, it can miss >commands >that come quickly. onperf didn't seem to have much. I haven't tried the >new >tool that requires a web server (jeez!) Thanks in advance. Informix-SPY. _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com.

connect to sysmaster and check the syssqlstats table savio Obnoxio The Clown wrote: > From: Matthew Cornell <cornell@cs.umass.edu> > > > >I'm running IDS.2000 9.20.UC1 on RH6.2. While my Java program is running > >I'd > >like a utility that lets me monitor the full/exact SQL commands that it > >issues. Is there such a beast? I know of onstat -g sql -r 1, but it only > >lists the *type* of command, not the whole thing. Plus, it can miss > >commands > >that come quickly. onperf didn't seem to have much. I haven't tried the > >new > >tool that requires a web server (jeez!) Thanks in advance. > > Informix-SPY. > _________________________________________________________________________ > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. > > Share information about yourself, create your own public profile at > http://profiles.msn.com.

connect to sysmaster and check the syssqlstats table savio Obnoxio The Clown wrote: > From: Matthew Cornell <cornell@cs.umass.edu> > > > >I'm running IDS.2000 9.20.UC1 on RH6.2. While my Java program is running > >I'd > >like a utility that lets me monitor the full/exact SQL commands that it > >issues. Is there such a beast? I know of onstat -g sql -r 1, but it only > >lists the *type* of command, not the whole thing. Plus, it can miss > >commands > >that come quickly. onperf didn't seem to have much. I haven't tried the > >new > >tool that requires a web server (jeez!) Thanks in advance. > > Informix-SPY. > _________________________________________________________________________ > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. > > Share information about yourself, create your own public profile at > http://profiles.msn.com.

connect to sysmaster and check the syssqlstats table savio Obnoxio The Clown wrote: > From: Matthew Cornell <cornell@cs.umass.edu> > > > >I'm running IDS.2000 9.20.UC1 on RH6.2. While my Java program is running > >I'd > >like a utility that lets me monitor the full/exact SQL commands that it > >issues. Is there such a beast? I know of onstat -g sql -r 1, but it only > >lists the *type* of command, not the whole thing. Plus, it can miss > >commands > >that come quickly. onperf didn't seem to have much. I haven't tried the > >new > >tool that requires a web server (jeez!) Thanks in advance. > > Informix-SPY. > _________________________________________________________________________ > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. > > Share information about yourself, create your own public profile at > http://profiles.msn.com.