Informix

Expand all | Collapse all

Find who is connected via Prox connection manager

  • 1.  Find who is connected via Prox connection manager

    Posted 18 days ago
    1. A session is rolling back and has held 14 Million lock.
    2. When I check in sysessions for that rstcb, it gives me Connection Manager as "hostname".
    3. Connection manager is in Proxy mode.
    4. The program type is DBeaver.
    5. How do I find the actual host/IP who is running the query from DBeaver --> Proxy Connection Manger --> Database Server ?

    ------------------------------
    Rajat Agrawal
    ------------------------------


  • 2.  RE: Find who is connected via Prox connection manager

    Posted 18 days ago
    With more recent version of CM (I've tested 4.50.FC2) this doens't seem to be the case, i.e. syssessions (or onstat -g ses <sid>) would show original hostname, feprogram and uid/pid rather than CM's for a proxied session.

    In your case (what version?), maybe the CM log file can help?

    ------------------------------
    Andreas Legner
    ------------------------------



  • 3.  RE: Find who is connected via Prox connection manager

    Posted 18 days ago
    Thanks Andreas for your reply. Below are additional facts:

    1.CM version is 4.10 FC4
    2. DB server version is 12.10 FC7
    3. feprogram shows DBeaver (with entire path)
    4. pid shows 0
    5. hostname shows CM server.

    ------------------------------
    Rajat Agrawal
    ------------------------------



  • 4.  RE: Find who is connected via Prox connection manager

    Posted 18 days ago
    Just found 12.10.xC5/4.10.xC5 introduced this change, so you're missing it very narrowly ;-)

    ------------------------------
    Andreas Legner
    ------------------------------



  • 5.  RE: Find who is connected via Prox connection manager

    Posted 18 days ago
    :)

    ------------------------------
    Rajat Agrawal
    ------------------------------