Informix

Informix

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only

  • 1.  Monitor Informix with Splunk

    Posted Tue February 11, 2020 10:29 AM
    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


  • 2.  RE: Monitor Informix with Splunk

    Posted Tue February 11, 2020 10:37 AM
    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


    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.






    Original Message


Related Content