473,231 Members | 1,752 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,231 software developers and data experts.

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 2037
"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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

13
by: Yang Li Ke | last post by:
Hi guys, Is it possible to know the internet speed of the visitors with php? Thanx -- Yang
0
by: Jussi Mononen | last post by:
Hi, I'm having problems to successfully execute the test scripts on a Compaq host ( OSF1 tr51bdev V5.1 2650 alpha ). Almost all tests end up with the following error message "PARI: *** ...
30
by: Mike Cox | last post by:
Hi. I recently ran a benchmark against two simple programs, one written in Java and the other in C++. The both accomplish the same thing, outputting "Hello World" on my screen. The C++ program...
5
by: JENS CONSER | last post by:
Hello NG, We have a performance problem in using a client server solution based on MS SQL-Server 2000 through a VPN tunnel (via broadband internet connection). The SQL Server is running on a...
15
by: TJ Walls | last post by:
Hello All, I am baffled ... I am trying to improve the speed of a program that I have written that performs random access within a file. It relies heavily on fseek and is very slow. To test, I...
45
by: charles.lobo | last post by:
Hi, I have recently begun using templates in C++ and have found it to be quite useful. However, hearing stories of code bloat and assorted problems I decided to write a couple of small programs...
3
by: Agnes | last post by:
My client put the SQL server in data center. Their branches (located in different area) run vb.net application via VIA VFP . Now, they complaint that there is Timeout occurs. When I test the...
19
by: llothar | last post by:
I must say i didn't expect this. I just did some measures on FreeBSD 6.2 with gcc 3.4.6 and there is absolutely no significant difference between 32 and 64 bit mode - neither in compilation speed,...
0
by: VivesProcSPL | last post by:
Obviously, one of the original purposes of SQL is to make data query processing easy. The language uses many English-like terms and syntax in an effort to make it easy to learn, particularly for...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.