Informix

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
------------------------------

Original Message:
Sent: Thu April 01, 2021 06:31 AM
From: Rajat Agrawal
Subject: Find who is connected via Prox connection manager

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

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
------------------------------

Original Message:
Sent: Thu April 01, 2021 06:50 AM
From: Andreas Legner
Subject: Find who is connected via Prox connection manager

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

Original Message:
Sent: Thu April 01, 2021 06:31 AM
From: Rajat Agrawal
Subject: Find who is connected via Prox connection manager

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

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

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

Original Message:
Sent: Thu April 01, 2021 07:22 AM
From: Rajat Agrawal
Subject: Find who is connected via Prox connection manager

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

Original Message:
Sent: Thu April 01, 2021 06:50 AM
From: Andreas Legner
Subject: Find who is connected via Prox connection manager

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

Original Message:
Sent: Thu April 01, 2021 06:31 AM
From: Rajat Agrawal
Subject: Find who is connected via Prox connection manager

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

:)

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

Original Message:
Sent: Thu April 01, 2021 08:18 AM
From: Andreas Legner
Subject: Find who is connected via Prox connection manager

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

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

Original Message:
Sent: Thu April 01, 2021 07:22 AM
From: Rajat Agrawal
Subject: Find who is connected via Prox connection manager

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

Original Message:
Sent: Thu April 01, 2021 06:50 AM
From: Andreas Legner
Subject: Find who is connected via Prox connection manager

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

Original Message:
Sent: Thu April 01, 2021 06:31 AM
From: Rajat Agrawal
Subject: Find who is connected via Prox connection manager

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