SQLIDEBUG

Hello all, I searching for a possiblity to monitor the execution-time of the sql-statements. I hear that it should be possible with the "SQLIDEBUG-Environment-Variable". Is there anyone with experiences with this Tool ? and where can I get more information about this ? (available in which ids-version, syntax etc) Or is it possible to hear on the Port which are defined in the sqlhosts Greetings Erik Stahlhut

Check out Jonathan Leffler's sqlcmd package in the IIUG Software Repository. Sqlcmd is a replacement for dbaccess, it has the ability to log and/or time all commands. This package is so useful that Informix recently decided to start distributing it on one of their CDs. Art S. Kagel Erik Stahlhut wrote: > > Hello all, > > I searching for a possiblity to monitor the execution-time of the > sql-statements. I hear that it should be possible with the > "SQLIDEBUG-Environment-Variable". > > Is there anyone with experiences with this Tool ? > and where can I get more information about this ? > (available in which ids-version, syntax etc) > > Or is it possible to hear on the Port which are defined in the sqlhosts > > Greetings > Erik Stahlhut

Hello, thanks a lot for your tip. I´ll try it. Do you have any idea to trace the pollthread and Network-Ports more detailled than it´s possible now with Informix-Tools ?? regards Erik Stahlhut Art S. Kagel schrieb in Nachricht <3918305B.4B1592E2@bloomberg.net>... >Check out Jonathan Leffler's sqlcmd package in the IIUG Software Repository. >Sqlcmd is a replacement for dbaccess, it has the ability to log and/or time >all commands. This package is so useful that Informix recently decided to >start distributing it on one of their CDs. > >Art S. Kagel > >Erik Stahlhut wrote: >> >> Hello all, >> >> I searching for a possiblity to monitor the execution-time of the >> sql-statements. I hear that it should be possible with the >> "SQLIDEBUG-Environment-Variable". >> >> Is there anyone with experiences with this Tool ? >> and where can I get more information about this ? >> (available in which ids-version, syntax etc) >> >> Or is it possible to hear on the Port which are defined in the sqlhosts >> >> Greetings >> Erik Stahlhut