|
View previous topic :: View next topic
|
| Author |
Message |
kbmkris
Active User
Joined: 24 Jun 2006
Posts: 101
|
|
|
|
hi,
There is a tool called STROBE which is used for performance tuning of our COBOL code. It gives details like the CPU time taken by each statements. I don't have much information about that.
If anyone has idea about the same, can you please share with me. If you have any documents also please share it.
Thanks,
Bala |
|
| Back to top |
|
 |
amrita.chatterjee
New User
Joined: 27 Apr 2006
Posts: 48
Location: Bangalore, India
|
|
|
|
Actually, by using this tool, u can see the CPU time taken by each stem. Actually Strobe use to generate one report, in this report, it use to display the cputime by offset wise.
Attach is one strobe reference doc. |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19243
Location: Inside the Matrix
|
|
|
|
Hello,
You might also "SEARCH" in the forum. There have been muiltiple topics about Strobe. |
|
| Back to top |
|
|
kbmkris
Active User
Joined: 24 Jun 2006
Posts: 101
|
|
|
|
| I want to analyze some of the SQL statements which are present in my program using STROBE. So I need a document on STROBE to get the CPU time taken for each query. Are U having any document for that. |
|
| Back to top |
|
|
kbmkris
Active User
Joined: 24 Jun 2006
Posts: 101
|
|
|
|
| Are u having any document to understanding the reports which are created by STROBE. |
|
| Back to top |
|
|
amrita.chatterjee
New User
Joined: 27 Apr 2006
Posts: 48
Location: Bangalore, India
|
|
|
|
As I already told u, reports will be in simple format. CPU time will be mentioned with the offset value & if u will see the program in listing option of CHNGMAN, then u can find the offset & then u can find out the offset of your sql statement & in the report u can find the CPU time for that offset.
Hope this will help u. |
|
| Back to top |
|
|
kbmkris
Active User
Joined: 24 Jun 2006
Posts: 101
|
|
|
|
| First I will clear you my point. My aim to prove that my query is taking lesser CPU time than the existing logic. hence I Run both Existing and modified program with the same input thru STROBE. Also I already went thro the report which is created by STROBE. I could find that the reports created by STROBE is explaing every thing weth respect to percentage(%). I want to know which is the base parameter it takes to calculate that % value. Also i want to know how to read each report which is created by STROBE. there are lot of factors they were describing it in that report. Mainly i am focusing on How to read the report pertaing to an particular SQL but the document you have given is having only about COBOL ststements nothing about information on CPU time USAGE of SQL statements. Could you please check it and let me know if you have any documents on How to measure the SQL performance on SQL statements |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19243
Location: Inside the Matrix
|
|
|
|
Hello,
You could talk with the people who provide system support for your environment. They may have all of the documentation downloaded where you can see it or make your own copy. If your organization is licensed to use Strobe, all of the material is available from Compuware support.
http://frontline.compuware.com/
As i recall, their documentation is copyright material and may not be posted or linked to from our forum. |
|
| Back to top |
|
|
|
|
