Solved

Alternatives to onstat

Posted on 2011-03-18
10
742 Views
Last Modified: 2013-12-24
I am working with an old version of informix (5)  and onstat was not yet available in this release.  I need to be able to see the queries that are being run against the database.  

What is an alternative solution that would allow me to see the queries that are being run?

If it requires changing the database detailed instructions on how to add and use this functionality and remove it afterwords would be appreciated.  3rd party software solutions would have to be free.

Thanks,
0
Comment
Question by:Mr_Oz
  • 5
  • 4
10 Comments
 
LVL 5

Expert Comment

by:flutophilus
Comment Utility
If it's Informix 5 Turbo, then the equivalent command is tbstat. If it's Standard Engine then there is no equivalent.
0
 
LVL 1

Author Comment

by:Mr_Oz
Comment Utility
Ok I have tbstats how would I use this to get the query info.

For example I want to see that the query 'select * from blah' was just run against the DB.  Is this possible with tbstats?

Thanks,
0
 
LVL 5

Expert Comment

by:flutophilus
Comment Utility
Not to my knowledge.
0
 
LVL 1

Author Comment

by:Mr_Oz
Comment Utility
I will leave this open a bit longer in case there are any other suggestions to my problem, but thanks for the info flutophilus.

Could this be done somehow by adding a trigger?  My knowledge on this subject is somewhat limited.
0
 

Expert Comment

by:gsmak
Comment Utility
First check if you have  installed  
/usr/informix/bin/onstat

Solution is copy onstat there .

All about  commant onstat or similer  is  here :  

http://www.advancedatatools.com/Articles/Onstat/IDS_utilities.pdf

0
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
LVL 1

Author Comment

by:Mr_Oz
Comment Utility
That is a good article gsmak the problem is the version of informix I have predates onstat.  I do not have onstat available to me to copy to that location.

Thanks
0
 
LVL 5

Expert Comment

by:flutophilus
Comment Utility
You can't use a trigger to see that a query has been run - you can use triggers to capture additions, deletions and updates.

It might help us to help you if you could give us some more background to the problem.

For example why you want to know when queries are made? What tools are being used to perform the queries? What control do you have over how these queries are made?

F.
0
 
LVL 1

Author Comment

by:Mr_Oz
Comment Utility
I have a custom legacy 3rd party application that has no src/support available to it any longer.  I am doing research to figure out if I can utilize the application in some form or if the app will need to be completely  re-written.  Since source is not available I can not be sure how it is utilizing the tables.  What I would like to be able to do is execute the app and as I am running it see how it is interacting with the database.

Thanks,

0
 
LVL 5

Accepted Solution

by:
flutophilus earned 500 total points
Comment Utility
Yes, tricky.  Can't really offer any help I'm afraid, other than guessing what tables are affected when you do something and checking out what's been written/updated using dbaccess.
0
 
LVL 1

Author Closing Comment

by:Mr_Oz
Comment Utility
Ok thanks flutophilus, not the answer I was hoping for but an answer nonetheless :)
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Introduction: I have seen many questions on EE and elsewhere, asking about how to find either gaps in lists of numbers (id field, usually) ranges of values or dates overlapping date ranges combined date ranges I thought it would be a good …
CCModeler offers a way to enter basic information like entities, attributes and relationships and export them as yEd or erviz diagram. It also can import existing Access or SQL Server tables with relationships.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now