On linux, one can type:
On MSwin I recently found "timethis.exe" which does the same. But when I try the same sequence on windows it seems that the db2 connection can not be used in the "timethis" shell.

I found an ugly bypass, which I only use on my test-servers:
This is an option I do not like to use or propagate.. is there a better way to solve my problem?

I assume you want to see the timings of the statements you are trying to execute. Try doing something like this:

1) place all the statements into a file.
2) insert a select statement that gets the current time between each statement.
3) save the file
4) execute the script using db2 -tvsf <filename> (use the appropriate options depending on your script).

The script file would look like this:
-------------------------
connect to sample;
select current timestamp from sysibm.sysdummy1;
select * from employee;
select current timestamp from sysibm.sysdummy1;
-------------------

Andy

Thanks, but I was more looking for a way to let DB2 "enherit" the connection in a child process. This works on linux and, if I recall well, it used to work on windows while on DB2 V8.
Something changed in V9, it does not behave the same. And the "db2dbdft" approch should be avoided don't you think?

db2dbdft :This variable specifies the database alias name of the database to be used for implicit connects. If an application has no database connection but SQL or XQuery statements are issued, an implicit connect will be made if the DB2DBDFT environment variable has been defined with a default database.
what is meant by : DB2 "enherit" the connection in a child proces

From db2cmd on ms-win:
when you type:then the 2nd will indicate that no connection exists. This makes sence because the the program "timethis" owned the connection and is finished now

But when you type: you will see that the 2nd command will have no connection, and the 3rd does have one. I would expect/desire that the 2nd command would enherit the connection from it's root (db2cmd).

Is there someone on DB2 V8 on windows to confirm that this does work?