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
Expand all | Collapse all

InformixHQ: In Performance/Sessions section: filter by "NOT informix"

  • 1.  InformixHQ: In Performance/Sessions section: filter by "NOT informix"

    Posted Tue November 04, 2025 04:49 PM

    In the aforementioned section of InformixHQ I can look for sessions owned by user "joe". I can do the same with onstat -g ses | grep joe. But in that same grep command I can also say: onstat -g ses | grep -v informix if I want to see all but informix sessions.

    What is the syntax for negating a username - like informix - in InformixHQ?  I wanted see all sessions but those of informix.

    Thanks, on behalf of myself and my colleague, who is as befuddled as I am over this. ;-)



    ------------------------------
    +-----------------------------------------------------------+
    | I am pleased to report that I had no problems today. |
    | I had only issues, opportunities, challenges and valuable |
    | learning experiences. |
    +------------------------------------------ Jacob S --------+
    ------------------------------


  • 2.  RE: InformixHQ: In Performance/Sessions section: filter by "NOT informix"

    Posted Thu November 06, 2025 08:36 AM

    Hi Jacob,

    the "Search" option offered by those reports apparently isn't the same as a full fledged filter option, ideally by column ...

    I quickly drafted an internal story to implement some useful filtering, but it shouldn't hurt to also have an AHA item (feature request) where you, and others, could specify what kind of functionality you'd like to see there.

    HTH,
     Andreas



    ------------------------------
    Andreas Legner
    Informix Dev
    HCL Software
    ------------------------------



  • 3.  RE: InformixHQ: In Performance/Sessions section: filter by "NOT informix"

    Posted Thu November 06, 2025 10:03 AM

    Thanks for posting the URL for the feature request facility.  AHA?  As I commented in the FR I just submitted, I don't say AHA! until I hit on a solution. ;-) 

    [INFX-I-688] 

    Better search facility for filters in Informix-HQ. Like a negation NOT operator.



    ------------------------------
    +-----------------------------------------------------------+
    | I am pleased to report that I had no problems today. |
    | I had only issues, opportunities, challenges and valuable |
    | learning experiences. |
    +------------------------------------------ Jacob S --------+
    ------------------------------