468,765 Members | 1,296 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,765 developers. It's quick & easy.

speed test tools

DB2 gurus, I'm pretty new in DB2, or database field. Now I wanna some tools
which can measure the speed SQL stmt. be excuted. Is there any one in the
DB2 software bundle?

Thanks!
Nov 12 '05 #1
2 1915
"Hardy" <yh********@hotmail.com> wrote in message
news:ca***********@mail.cn99.com...
DB2 gurus, I'm pretty new in DB2, or database field. Now I wanna some tools which can measure the speed SQL stmt. be excuted. Is there any one in the
DB2 software bundle?

Thanks!

Look at the db2batch program described in the Command Reference manual. This
will give information about actual time for an SQL statement to execute.

If you want a theoretical estimate of the "relative" time, you can use the
DB2 Explain function. This can be executed as a command or using the Visual
Explain Tool in the Command Center. The explain show the access path (such
as using a particular index) that the query will use, in addition to giving
a timeron estimate. A timeron is not an elapsed time estimate, but a
relative number useful when comparing different scenarios.
Nov 12 '05 #2
oh,that's good~ thank you, Mark:)

"Mark A" <no****@switchboard.net> дʼ
news:w_*****************@news.uswest.net...
"Hardy" <yh********@hotmail.com> wrote in message
news:ca***********@mail.cn99.com...
DB2 gurus, I'm pretty new in DB2, or database field. Now I wanna some tools
which can measure the speed SQL stmt. be excuted. Is there any one in the DB2 software bundle?

Thanks!

Look at the db2batch program described in the Command Reference manual.

This will give information about actual time for an SQL statement to execute.

If you want a theoretical estimate of the "relative" time, you can use the
DB2 Explain function. This can be executed as a command or using the Visual Explain Tool in the Command Center. The explain show the access path (such
as using a particular index) that the query will use, in addition to giving a timeron estimate. A timeron is not an elapsed time estimate, but a
relative number useful when comparing different scenarios.

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

13 posts views Thread by Yang Li Ke | last post: by
reply views Thread by Jussi Mononen | last post: by
30 posts views Thread by Mike Cox | last post: by
5 posts views Thread by JENS CONSER | last post: by
15 posts views Thread by TJ Walls | last post: by
45 posts views Thread by charles.lobo | last post: by
3 posts views Thread by Agnes | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.