Re: Monitoring all SQL statements

Bill Ennis wrote: > > Yes, you can issue the SQL set explain on within the session you > wish to capture and the sql will be logged in a file named sqexplain.out > on the server machine. If you are running the queriues local to > the server the file will be in the current directory. If you are > running from a client machine check your home directory on the > server. > > -Bill > > > > Is there a way on Informix to monitor all SQL statements done by a > > specific session. I'd like to catch them all to optimize those > > statements. > > Another way would be to: SELECT sqx_sqlstatement FROM sysmaster:syssqexplain assuming you're running on 7.x. John Carlson WH Smith, Inc.