Oninit cdi / Archive
Talk to an expert →

informix - tool like SQL server profiler

Posted in 2005

Topics: General Discussion

Mitja — — source: Usenet: comp.databases.informix

Hello! Does anybody know is there any tool for informix like Microsoft SQL profiler? I would like to catch currently running sql statements.

↪ replying to Mitja
Art S. Kagel — — source: Usenet: comp.databases.informix

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

↪ replying to Mitja
hariog@yahoo.com — — source: Usenet: comp.databases.informix

Try: onstat -g stm On Unix, redirect output to a file, if you wish.

↪ replying to Art S. Kagel
Mitja — — source: Usenet: comp.databases.informix

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)?

Related threads