SQLTRACING

Hi all, IDS 11.10.FC3 on Solaris 10 I want to trace the SQLs run by the user "vikas" using the SQL Admin API execute function task("set sql tracing on", 10,"2k","low","user"); What should be the correct execute funtion systax so that i get only sqls executed by user "vikas" and not others? Should this be done using the session Id? EXECUTE FUNCTION task("set sql user tracing on", 10886); I'm not setting the onconfig parameter SQLTRACING but doing it from the sysadmin database. When i try the above options i get all the users sqls info with "user" option in "onstat -g his" and syssqltrace in sysmaster. When done with session id i get the other SQLs from the schedular I just want to trace and see only the SQLs executed by user "vikas" in "onstat -g his" or "syssqltrace". Pls suggest the right way to do this Regards Vikas

Hi Vikas, This is featured in the system administrators guide (chapter 20), however, EXECUTE FUNCTION admin/task( "set sql tracing user add" , "vikas"); See also ″set sql tracing user clear″ ″set sql tracing user list″ ″set sql tracing user remove″ , ″user_name″ Regards Mark > To: ids@iiug.org > From: vikas.hivarkar@gmail.com > Subject: SQLTRACING [17134] > Date: Tue, 22 Sep 2009 08:18:15 -0400 > > Hi all, > > IDS 11.10.FC3 on Solaris 10 > > I want to trace the SQLs run by the user "vikas" using the SQL Admin API > > execute function task("set sql tracing on", 10,"2k","low","user");> > What should be the correct execute funtion systax so that i get only sqls > executed by user "vikas" and not others? > > Should this be done using the session Id? > > EXECUTE FUNCTION task("set sql user tracing on", 10886);> > I'm not setting the onconfig parameter SQLTRACING but doing it from the > sysadmin database. > > When i try the above options i get all the users sqls info with "user" option > in "onstat -g his" and syssqltrace in sysmaster. > > When done with session id i get the other SQLs from the schedular > > I just want to trace and see only the SQLs executed by user "vikas" in "onstat > -g his" or "syssqltrace". > > Pls suggest the right way to do this > > Regards > Vikas > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > _________________________________________________________________ More than messages–check out the rest of the Windows Live™. http://www.microsoft.com/windows/windowslive/