Re: informix - tool like SQL server profiler

Mitja wrote: > 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)? > Yes, "onstat -g sql -r 5 >> file" will work. But that's not what I was thinking of. You are running 9.40 so there is the onmode command: onmode -Y session_id 1 This will turn on set explain processing for the named session logging every SQL statement and it's query plan to the session owner's sqexplain.out file. To disable it again: onmode -Y session_id 0 Art S. Kagel