Re: Capturing SQL

You can access this information by making : 1.- onstat -u To get the session conection id 2.- With the sessionid you can trace SQL tasks by doing onstat -g sql sessioid EX: onstat -u |grep myuser ---Supposing that sessionid is 123 onstat -g sql 123 -r 1 Regards Javier Randy Reiter wrote: > Refer to the Zero Impact Sql Monitor and Zero Impact Service Level Monitor > at www.sqlpower.com, > > Scales to thousands of users with no required impact upon the database > server, > > caf wrote in message <7gpie9$g53$1@nnrp1.dejanews.com>... > >Hi, > > > >Does anyone know of an easy way to capture SQL that is run against the > >database. I'm in a Baan/Informix environment and would like to see what > sort > >of SQL is being produced, for curiosity, and also it would allow me to > script > >them to run load tests ... > > > >OS: HP-UX 11 > >DB: Informix 7.30FC6-1 > > > >-- > >All thought welcome, > > > >caf > >com.yahoo@caf0013 > > > >-----------== Posted via Deja News, The Discussion Network ==---------- > >http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own