Re: SQL Tracing tools?

onstat -g sql does it to some extent. Some of the GUI tools such as ServerStudio have modules that will extract the data slightly more conveniently, but last time I nlook they give you nothing not available from command-line utilities. For heavy-duty query analysis, in a dev environment with at least 50 Terabytes of data storage, I-SPY can be revealing. -- Neil Truby t:01932 724027 Director m:07798 811708 Ardenta Limited e:neil.truby@ardenta.com "Abdullah Kauchali" <abdullah.kauchali@someplace.com> wrote in message news:cnicmc$spp$1@ctb-nnrp2.saix.net... > What do informix users use to profile (log) SQL statements hitting the > database server? (In MS lala-land, we have the almighty Profiler Tool. > Works well.) > > Any help or suggestions greatly appreciated. > > Kind regards > > Abdullah >

Hi Neil, Thanks for the prompt response! Much appreciated. > For heavy-duty query analysis, in a dev environment with at least 50 > Terabytes of data storage, I-SPY can be revealing. Is IIUG site have a downloadable version of I-SPY? (Just been reading about it ... seems that is the official tool.)

No. Your IBM Business Partner should, if he's worth his salt, be able to get you an eval copy. -- Neil Truby t:01932 724027 Director m:07798 811708 Ardenta Limited e:neil.truby@ardenta.com "Abdullah Kauchali" <abdullah.kauchali@someplace.com> wrote in message news:cnidj0$mm$1@ctb-nnrp2.saix.net... > Hi Neil, > > Thanks for the prompt response! Much appreciated. > >> For heavy-duty query analysis, in a dev environment with at least 50 >> Terabytes of data storage, I-SPY can be revealing. > > Is IIUG site have a downloadable version of I-SPY? (Just been reading > about it ... seems that is the official tool.) >