Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Art S. Kagel — — source: Usenet: comp.databases.informix
Dave Thacker wrote:
Get Jonathan Leffler's sqlcmd package. It has a benchmark mode (enabled
with the -B commandline option or with the command 'benchmark on;' from the
SQL command prompt. It will time each SQL command without including the
overhead of isql/dbaccess/sqlcmd startup and connection overhead that using
timex would include. Sqlcmd is available for download from the IIUG
Software Repository.
Art S. Kagel
> Platform: AIX V5.3, IDS 9.40FC6, ISQL 7.32
>
> Logged in as: informix
> export LIBPATH=$INFORMIXDIR/lib:$INFORMIXDIR/lib/esql:
> $INFORMIXDIR/lib/tools
>
> I'm attempting to use timex and isql to time queries from the command
> line. isql < my myquery.sql runs ok, but if I do this:
>
> 0> timex isql
> exec(): 0509-036 Cannot load program isql because of the following
> errors:
> 0509-150 Dependent module libifsql.so could not be loaded.
> 0509-022 Cannot load module libifsql.so.
> 0509-026 System error: A file or directory in the path name does
> not exist.
>
> real 0.00
> user 0.00
> sys 0.00
>
> Hmmm. not good. timex must need something for it's environment.
> libifsql.so is actually located in $INFORMIXDIR/lib/esql. What should I
> change to get this to work?
>
> TIA DT
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.