tracing of SQL-Statements

I am looking for a way to trace really each SQL statement an application sends to the database server. Because the source code of the application cannot be changed I have to use means of the DBMS. onstat -g sql sid -r seconds > file records sql statements. The minimum interval is 1 secondso if there are sql statements in between they will not be recorded. Other way: Using auditing shows the point in time of an event, the event category and some other useful informations but it does not show the exact sql statements. Can anybody give me a hint if there is a more useful tool? TIA Reinhard

Informix have a tool that can be used for this purpose, I-SPY. Its principal use is for data warehousing applications, and couldn't really be used in "live" because of its performance overhead, but properly targetted it could be useful. Reinhard Habichtsberg wrote in message <849qal$gtt$2@news06.btx.dtag.de>... >I am looking for a way to trace really each SQL statement >an application sends to the database server. > >Because the source code of the application cannot be changed I have to use >means of the DBMS. > >onstat -g sql sid -r seconds > file records sql statements. The minimuminterval is 1 second >so if there are sql statements in between they will not be recorded. > >Other way: Using auditing shows the point in time of an event, the event category and some >other useful informations but it does not show the exact sql statements. > >Can anybody give me a hint if there is a more useful tool? > >TIA >Reinhard > > > > > > > > > > > > > > > > > >

Neil Truby <ntruby@netcomuk.co.uk> schrieb in im Newsbeitrag: 84a191$2jo$1@taliesin2.netcom.net.uk... > Informix have a tool that can be used for this purpose, I-SPY. Its > principal use is for data warehousing applications, and couldn't really be > used in "live" because of its performance overhead, but properly targetted > it could be useful. Thank you, Neil. Do you know how do purchase the tool. I found a manual at informix web site but no offer to download it. Regards, Reinhard

Contact your Informix account manager. You should be able to get it on evaluation. Reinhard Habichtsberg wrote in message <84ccvl$thm$1@news06.btx.dtag.de>... > >Neil Truby <ntruby@netcomuk.co.uk> schrieb in im Newsbeitrag: 84a191$2jo$1@taliesin2.netcom.net.uk... >> Informix have a tool that can be used for this purpose, I-SPY. Its >> principal use is for data warehousing applications, and couldn't really be >> used in "live" because of its performance overhead, but properly targetted >> it could be useful. > >Thank you, Neil. > >Do you know how do purchase the tool. I found a manual at informix web site >but no offer to download it. > >Regards, >Reinhard > >

Try monitoring tool from Informix ISPY and there are some good also like Platinum DBA Advantage. * Sent from AltaVista http://www.altavista.com Where you can also find related Web Pages, Images, Audios, Videos, News, and Shopping. Smart is Beautiful