Utility to track all SQL

Posted in 1999

Eric Weaver — Tue, 21 Sep 1999 07:23:03 -0400 — source: Informix-list mailing list archive (1991-1998)

Does anyone know of a utility that can simply log every command the engine processes to a file or STDOUT? Basically I'm looking for something like the output of onstat -g sql xxx in a real time mode. I've checked the IIUG site and didn't see anything (but I didn't search that thoroughly). Thanks, Eric Weaver, InteliHealth

↪ replying to Eric Weaver

Yang, Heung-Soon — Wed, 22 Sep 1999 08:48:06 +0900 — source: Informix-list mailing list archive (1991-1998)

After IDS7.24, you can use environment variable 'SQLIDEBUG'. I'm sorry that I can't remember the usage.-_-; Eric Weaver wrote: > Does anyone know of a utility that can simply log every command the engine > processes to a file or STDOUT? Basically I'm looking for something like the > output of onstat -g sql xxx in a real time mode. > > I've checked the IIUG site and didn't see anything (but I didn't search that > thoroughly). > > Thanks, > Eric Weaver, InteliHealth

Related threads

Glossary

onstat