SQL Profiler equivalent

idingsdale

New Member
Hi All,

I'm looking after an application running on Progress 10.2B

I'd really like a way to track down where certain frontend fields exist in the database - I've used SQL Profiler with SQL server before for this purpose.

Is there an equivalent for Progress?
 
Are you trying to find what table these fields are in or where they are used or what?
 
I want to find the name of the table and column ideally.

I know I could ask the vendor, but I prefer the tools to be able to do it myself :)

With MS SQL I'd use query profiler, open or update a window in the front end and examine the queries to see whats going on
 
OK, but I'm still not clear what your starting point is. What you have that you are looking at where you want to find the table and column? There are a variety of possible tools, but they fulfill different functions depending on the start point and the desired end.
 
My starting point is a Windows GUI application with a Progress backend. I need to figure out where certain data is coming from
 
There is no direct equivalent.

The closest you might be able to come would be to query the _Connect VST and look at the statement cache fields for the session you want to profile.
 
There is no direct equivalent.

The closest you might be able to come would be to query the _Connect VST and look at the statement cache fields for the session you want to profile.

Thanks Tom,

Could you give me a bit more information about how I would go about that, or point me in the right direction for documentation?
 
Also, I'll ask in here rather than creating another thread!

I fancied having a look at ProTop to do some digging around in the database too, have tried running it from a client (win 7) with

prowin32 dbname -H host -S service -p protop

and from the server (win 2003) itself with

prowin32 [path to db] -p protop

On both, the progress splash screen appears and it crashes straight away. Both have 10.1A and 10.2B installed, have tried both versions with the relevant protop .net versions but it's always the same

Guessing it's something I'm doing wrong? :)
 
10.1A won't work -- the minimum that you need is 10.2A.

10.2B is currently causing me a lot of headaches. The 10.2A r-code will not work with 10.2B so I uploaded a new set of r-code Wednesday that is specific to 10.2B. It works in some cases but not in others :( I have not had time to really dig into what is going on there and unfortunately my schedule is very full over the next month or so so I may not get back to it for a while.
 
I think there is a kbase somewhere. But I don't have a handy link. Basically you need to enable the client statement cache and then query it and display the results ;) Or you can dive into ProTop or PROMON and dig the data out of there.
 
I think there is a kbase somewhere. But I don't have a handy link. Basically you need to enable the client statement cache and then query it and display the results ;) Or you can dive into ProTop or PROMON and dig the data out of there.

promon dbname
R&D
1 (status display)
18 (Client Database-Request Statement Cache ...).
This options available to 10.2a+ users.
 
I think there is a kbase somewhere. But I don't have a handy link. Basically you need to enable the client statement cache and then query it and display the results ;) Or you can dive into ProTop or PROMON and dig the data out of there.

Excellent I'll have a look!

Do you not have source?

Dont think so, even if I did I wouldnt have a clue what to do with it! :) It's not exactly a small app either

promon dbname
R&D
1 (status display)
18 (Client Database-Request Statement Cache ...).
This options available to 10.2a+ users.

I dont have those options :(

My protop looks like:


1. User Control
2. Locking and Waiting Statistics
3. Block Access
4. Record Locking Table
5. Activity
6. Shared Resources
7. Database Status
8. Shut Down Database

R&D. Advanced options
T. 2PC Transactions Control
L. Resolve 2PC Limbo Transactions
C. 2PC Coordinator Information

J. Resolve JTA Transactions

M. Modify Defaults
Q. Quit

Enter your selection: q
 
type "R&D" in main menu to enter Advanced menu for developers

Well that was embarrasing :D

Have got that working (I think!), under "Statement cache information" it lists what I assume are progress files, such as:

ip-window-view xxxxxx.w
dispatch xxxxxx.w

Presumably the next step is to interrogate those files as one of them will contain the relevant query?
 
Back
Top