Re: Monitoring all SQL statements

Posted in 1997

Bill Ennis — 22 Dec 1997 10:53:19 -0500 — source: Informix-list mailing list archive (1991-1998)

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. > > Ricardo Palmeira <palmeira@tce.pe.gov.br> > -- Bill Ennis Voice: 312-474-7516 SSA Fax: 312-474-7460 500 W. Madison email: ennis@ssax.com ennis@accesschicago.net