Monitor Informix with Splunk
Posted in 2020
Topics: Storage & Space Management, Stored Procedures & SPL
Hi
without onstat how can I get monitor informix with other tools like splunk?
e.g. I want to get current queries that run on informix, or usage of dbspaces.
on which table these info store?
Thanks,
------------------------------
mmm mmmm
------------------------------
#Informix
All of this information, almost everything else that onstat reports, and more are presented in the System Management Interface database "sysmaster".
You can get some information about individual tables from the notes in the file $INFORMIXDIR/etc/sysmaster.sql. Also take a look at the technical presentations that Lester Knutsen posts on his YouTube channel which you can get to most easily on his web site
www.advancedatatools.com/tech-info/past-webcasts/
and
https://advancedatatools.com/tech-info/tech-sysmaster/
Art
Art S. Kagel, President and Principal Consultant
ASK Database Management
www.askdbmgt.com
Blog:
http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.