Oninit cdi / Archive
Talk to an expert →

Re: real-time monitoring of SQL commands?

Posted in 2000

Summary

Reply thread to the question on real-time monitoring of SQL commands. Obnoxio The Clown answered Informix-SPY, and Savio Pereira repeated three times to connect to sysmaster and check the syssqlstats table. No further discussion.

Auto-generated by Claude from the posts below — may be imperfect; read the full thread.

Topics: Java & JDBC Development

Obnoxio The Clown — — source: Informix-list mailing list archive (1991-1998)

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.

↪ replying to Obnoxio The Clown
Savio Pereira — — source: Informix-list mailing list archive (1991-1998)

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.

↪ replying to Obnoxio The Clown
Savio Pereira — — source: Informix-list mailing list archive (1991-1998)

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.

↪ replying to Obnoxio The Clown
Savio Pereira — — source: Informix-list mailing list archive (1991-1998)

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.

Related threads

Glossary