informix - tool like SQL server profiler
Mitja asked for an Informix tool like SQL Server Profiler to capture running SQL. Art S. Kagel said IDS 9.40 and 10.00 have such a feature and other versions need tools such as I-Spy or Server Studio JE. Another poster suggested onstat -g stm. Mitja, on Linux and 9.40, asked whether onstat -g sql or stm can run continuously. No answer was given.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hello! Does anybody know is there any tool for informix like Microsoft SQL profiler? I would like to catch currently running sql statements.
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
Try:
onstat -g stm
On Unix, redirect output to a file, if you wish.
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)?