session from "::ffff:2"
Answered: red (hollow confidence) — No way was found to resolve host ::ffff:2 beyond syssessions (host comes from sysscblst); suggestions were to check netstat or OS network connections, and asker did not reply.
Advisory only.
Posted in 2020
John Smith asked how to find the host IP address for a session whose hostname showed as ::ffff:2. Andreas Legner and Paul Watson suggested it looked like a malformed IPv6 address. Ramon Rey said hostname comes from sysscblst via syssessions, with no other source in sysmaster, so only network tools would help. Andreas suggested checking netstat -a. Unresolved.
Topics: General Discussion
Hello to All How to find the host that is connected (IP Adress) for a session with hostname = ::ffff:2 ? Thanks ------------------------------ John Smith ------------------------------ #Informix
Looking to be an IPv6 address? ------------------------------ Andreas Legner ------------------------------
But it looks like a badly formed address Cheers Paul > Looking to be an IPv6 address? > > ------------------------------ > Andreas Legner > ------------------------------ > ------------------------------------------- > Original Message: > Sent: Mon November 09, 2020 08:16 AM > From: John Smith > Subject: session from "::ffff:2" > > Hello to All > > How to find the host that is connected (IP Adress) for a session with > hostname = ::ffff:2 ? > > Thanks > > ------------------------------ > John Smith > ------------------------------ > > > Reply to Sender : > https://community.ibm.com/eGroups/PostReply/?GroupId=4147&MID=201547&SenderKey=34569554-10a3-41e8-ad2d-91951079d303&MDATE=757546645%253e&UserKey=29a6c229-a98c-46da-9248-4df042a4a263&sKey=KeyRemoved > > Reply to Discussion : > https://community.ibm.com/eGroups/PostReply/?GroupId=4147&MID=201547&MDATE=757546645%253e&UserKey=29a6c229-a98c-46da-9248-4df042a4a263&sKey=KeyRemoved > > > > You are subscribed to "Informix" as paul@oninit.com . To change your > subscriptions, go to > http://community.ibm.com/community/user/preferences?section=Subscriptions&MDATE=757546645%253e&UserKey=29a6c229-a98c-46da-9248-4df042a4a263&sKey=KeyRemoved. > To unsubscribe from this community discussion, go to > http://community.ibm.com/HigherLogic/eGroups/Unsubscribe.aspx?UserKey=29a6c229-a98c-46da-9248-4df042a4a263&sKey=KeyRemoved&GroupKey=60eb97a2-57c0-4130-9b6d-57174f97d5a8. -- Paul Watson Tel: +1 913-674-0360 Mob: +1 913-387-7529 Web: www.oninit.com Oninit? is a registered trademark of Oninit LLC Failure is not as frightening as regret. If you want to improve, be content to be thought foolish and stupid. What this country needs are more unemployed politicians
Hello John:
Not sure I understand your question. You want the hostname for a session with hostname =
::ffff:2? That seems to be a malformed address. Please clarify.
Nonetheless, you can get the session and host along with other goodies from the syssessions in the sysmaster.
https://www.ibm.com/support/knowledgecenter/SSGU8G_14.1.0/com.ibm.adref.doc/ids_adr_0255.htm
I use this query to get session, host, network times and query:
set isolation to dirty read;
select s.sid as session_id,
t.sqs_dbname db_name,
s.username,
s.hostname,
dbinfo('utc_to_datetime', n.net_open_time) as conn_opened,
dbinfo('utc_to_datetime', n.net_last_read) as last_read,
dbinfo('utc_to_datetime', n.net_last_write) as last_write,c.cbl_stmt as sql_stmt
from syssessions s, sysnetworkio n, syssqlstat t, sysconblock c
where s.sid = n.sid
and s.sid = t.sqs_sessionid
and s.sid = c.cbl_sessionid
and (c.cbl_stmt is not null or c.cbl_stmt not like ' %')
I hope this helps.
R
------------------------------
Ramon Rey
------------------------------
Yes I have the same info on syssessions table; that"s why i'm asking if there is a another way to find the host of this session regards ------------------------------ John Smith ------------------------------
John, Syssessions is a view made off of the join of sysscblst and sysrstcb tables. The user host info comes from the sysscblst table. To my knowledge, there is no other place in the sysmaster that holds the hostname from the connecting session. As for sources outside the database, you could try chasing down network connections, but that would work with current sessions. My 0.02... Cheers! Ramón ------------------------------ Ramon Rey ------------------------------
So just out of couriosity: are you seeing a similar thing in 'netstat -a' ? If so this would indicate that also the OS isn't able to match this numeric thing with a host name... ------------------------------ Andreas Legner ------------------------------