Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Alternatives to onstat

Posted on 2011-03-18
10
Medium Priority
?
765 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 4
10 Comments
 
LVL 5

Expert Comment

by:flutophilus
ID: 35165699
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
ID: 35166118
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
ID: 35166941
Not to my knowledge.
0
Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

 
LVL 1

Author Comment

by:Mr_Oz
ID: 35167506
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
ID: 35171989
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
 
LVL 1

Author Comment

by:Mr_Oz
ID: 35180160
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
ID: 35180297
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
ID: 35180500
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 2000 total points
ID: 35180985
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
ID: 35181050
Ok thanks flutophilus, not the answer I was hoping for but an answer nonetheless :)
0

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently, Microsoft released a best-practice guide for securing Active Directory. It's a whopping 300+ pages long. Those of us tasked with securing our company’s databases and systems would, ideally, have time to devote to learning the ins and outs…
This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

670 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