tracing of SQL-Statements
Reinhard Habichtsberg wanted to trace every SQL statement an application sends, without changing its code. onstat -g sql with -r has a 1 second minimum interval and auditing does not show statement text. Neil Truby suggested Informix's I-SPY tool, noting its overhead and that it is available on evaluation via the account manager. Another poster also named I-SPY and Platinum DBA Advantage.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
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
Related threads
- Posting from the Informix-list
- Migrating from IDS 9.40.UC6 to 11.50.UC3
- Ip for a network session
- questions onstat -g