Create sqexplain for all Sessions

Posted in 1999

Topics: Performance & Tuning, Server Administration

Pfeiffer IT — Tue, 12 Jan 1999 08:48:39 +0100 — source: Informix-list mailing list archive (1991-1998)

I have read about an ONCONFIG-Parameter which would make sqexlains for all Sessions. How can i use this Parameter ISQLDEBUG and how it works. Is there another way to collect sql-information about all running sql-sessions.

↪ replying to Pfeiffer IT

James Richardson — Tue, 12 Jan 1999 16:39:55 -0000 — source: Informix-list mailing list archive (1991-1998)

Pfeiffer IT wrote in message <77euto$4ob$1@fleetstreet.Austria.EU.net>... >I have read about an ONCONFIG-Parameter which would make sqexlains for all >Sessions. >How can i use this Parameter ISQLDEBUG and how it works. > >Is there another way to collect sql-information about all running >sql-sessions. > > The parameter you mention does not do what you think it does. The environment variable you need to set is SQLEXPLAIN. Set this to "ON", and you will have a file sqexplain.out in the cwd of your program at the time the statement is issued. (csh) setenv SQLEXPLAIN ON This will run for all sessions run from your shell. If you want to find out about the SQL that is being run for all sessions, there was a thing about that here a few days ago. (check the SMI tables) James

Glossary

onconfig