Alternatives to onstat

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,
LVL 1
Mr_OzAsked:
Who is Participating?
 
flutophilusConnect With a Mentor Commented:
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
 
flutophilusCommented:
If it's Informix 5 Turbo, then the equivalent command is tbstat. If it's Standard Engine then there is no equivalent.
0
 
Mr_OzAuthor Commented:
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
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

 
flutophilusCommented:
Not to my knowledge.
0
 
Mr_OzAuthor Commented:
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
 
gsmakCommented:
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
 
Mr_OzAuthor Commented:
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
 
flutophilusCommented:
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
 
Mr_OzAuthor Commented:
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
 
Mr_OzAuthor Commented:
Ok thanks flutophilus, not the answer I was hoping for but an answer nonetheless :)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.