Find who is connected via Prox connection manager
Rajat Agrawal asked how to find the real client host behind a session through a proxy-mode Connection Manager, where sysessions showed the CM's hostname, pid 0 and DBeaver as program (CM 4.10 FC4, server 12.10 FC7). Andreas Legner said newer CM versions show the original host and later found the change arrived in 12.10.xC5/4.10.xC5, so Rajat just missed it.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
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 ------------------------------ #Informix
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
------------------------------
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 ------------------------------
Just found 12.10.xC5/4.10.xC5 introduced this change, so you're missing it very narrowly ;-) ------------------------------ Andreas Legner ------------------------------
:) ------------------------------ Rajat Agrawal ------------------------------