Re: informix - tool like SQL server profiler
Check the manuals, but basically onstat -- (double minus) will list all
possible commands. onstat -r 'n' is repeat command every 'n' seconds so
onstat -r 5 -g sql will list the sql for all processes every 5 seconds
Regards
Colin
There are 10 types of people in the world, those that understand binary and
those that don't
>From: Mitja <mitja.udovc@ztm.si>
>Reply-To: Mitja <mitja.udovc@ztm.si>
>To: informix-list@iiug.org
>Subject: Re: informix - tool like SQL server profiler
>Date: Thu, 15 Sep 2005 07:29:59 +0200
>
>Art S. Kagel wrote:
> > Mitja wrote:
> >
> >> Hello!
> >>
> >> Does anybody know is there any tool for informix like Microsoft SQL
> >> profiler?
> >>
> >> I would like to catch currently running sql statements.
> >
> >
> > Version and platform would be nice. IDS 9.40 and 10.00 have that
> > feature, for others there are separately available tools:
> >
> > IBM/Informix I-Spy
> > Server Studio JE
> > etc.
> >
> > Art S. Kagel
> >
>Platform is linux and version is 9.40
>
>onstat -g sql, onstat -g stm ...>
>Is it possible to run these statements in continous mode (which means
>that this onstat is running and messages are printed while application
>is running)?
sending to informix-list