Time a SQL statement

[aaron80v]

Hi,

How to time the duration of a SQL statement issued in DB2 command CLP?
Aaron

[Knut Stolze]

aa******@yahoo.com.au wrote:

Hi,

How to time the duration of a SQL statement issued in DB2 command CLP?

Just a few ideas: You can either use the "time" command (may be operating
system specific), a snapshot, or rely on "db2batch" instead of "db2".

--
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany

[Ian]

Knut Stolze wrote:

aa******@yahoo.com.au wrote:

>Hi,

How to time the duration of a SQL statement issued in DB2 command CLP?

Just a few ideas: You can either use the "time" command (may be operating
system specific), a snapshot, or rely on "db2batch" instead of "db2".

And the old standby, "values (current timestamp)" before and after the
SQL statement.

[Phil Sherman]

I've had to do this on many different systems. My preferred solution is
a small REXX routine I wrote that takes the command to be executed as a
parameter and sandwiches it between two "get current time" commands. A
simple calculation gives me the duration. This is doable on every
operating system I've used, from DOS (on a PC) to the largest
mainframes. If REXX isn't available for your system, a script file or
some other supported scripting language will be available and should
provide the facilities you need.

Phil Sherman
aa******@yahoo.com.au wrote:

Hi,

How to time the duration of a SQL statement issued in DB2 command CLP?
Aaron