Tracing sql statements

I've used the "onstat -g sql xxx' statement to view the last sql statement issued by a user. Does anyone have a suggestion or know of a way to run a complete trace on a specific user? -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

fprose@my-dejanews.com wrote: > > I've used the "onstat -g sql xxx' statement to view the last sql statement > issued by a user. Does anyone have a suggestion or know of a way to run a > complete trace on a specific user? dbaccess sysmaster - > select * from syssqexplain where sqx_sessionid = xxxx; This view is inconsistent as to what queries it tracks and what it does not. Also it does almost exactly what onstat -g sql does so if you have a very busy multiprocessor system and onstat -g sql hangs or runs forever this query will do the same (a word to the wise). If onstat -g sql works well on your system then this will also. Art S. Kagel