how to get host's ip address of session !

Posted in 2010

Summary

A user on IDS 11.50 (RHEL 5) wanted to identify the IP address of an unknown client machine connected to the server, but 'onstat -g ses' truncated the hostname (js090731) and, with no DNS available, ping returned "unknown host." Suggestions included pinging the name from a Windows box, and correlating 'netstat -a | grep LISTEN' output for the sqlhosts service/port with the session list. The most direct answer came from IBM: query syssessions in the sysmaster database, which shows the full, untruncated hostname.

Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.

Topics: General Discussion

MARS CHEN — Thu, 04 Mar 2010 01:59:25 — source: IIUG Forums & Mailing Lists

Dear All... I've found a strange host in my IDS 11.50.uc6 running in RedHat Enterprise 5, The following showes the host's seesion informiation : id user tty pid hostname 1600 informix JS090731 3612 js090731 I know it is js090731 host connect IDS , my question is how to get the ip address of js090731 in IDS command or shell command without asking for help of network team ?! Any suggestions are welcomed ~~

↪ replying to MARS CHEN

Art Kagel — Thu, 04 Mar 2010 03:11:43 — source: IIUG Forums & Mailing Lists

At the OS prompt enter: ping js090731 The display should show js090731's ip address. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) See you at the 2010 IIUG Informix Conference April 25-28, 2010 Overland Park (Kansas City), KS www.iiug.org/conf Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Wed, Mar 3, 2010 at 8:59 PM, MARS CHEN <mars@jsun.com> wrote: > Dear All... > > I've found a strange host in my IDS 11.50.uc6 running in RedHat Enterprise > 5, > The following showes the host's seesion informiation : > > id user tty pid hostname > 1600 informix JS090731 3612 js090731 > > I know it is js090731 host connect IDS , my question is > how to get the ip address of js090731 in IDS command or shell command > without asking for help of network team ?! > > Any suggestions are welcomed ~~ > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --000e0ce0b10a07abc80480f0f5bd

↪ replying to Art Kagel

MARS CHEN — Thu, 04 Mar 2010 03:24:38 — source: IIUG Forums & Mailing Lists

I've tried it , but it showes : Unknown host JS090731 ping JS090731 Unknown host JS090731. ping js090731 Unknown host js090731. I don't have Domain name server in Linux , so I do ping in Windows , actually I just found this windows , it is :js090731-ix2k0v , because in "onstat -g ses" I can only see js090731 , that is why I can not find it ... May I get longer string of host name in "onstat -g ses" ?

↪ replying to MARS CHEN

Art S. Kagel — Thu, 04 Mar 2010 03:32:14 — source: IIUG Forums & Mailing Lists

Unfortunately no. Art=20 -----Original Message----- From: MARS CHEN <mars@jsun.com> Sent: Wednesday, March 03, 2010 10:24 PM To: ids@iiug.org Subject: Re: how to get host's ip address of session ! [19211] I've tried it , but it showes :=20 Unknown host JS090731=20 ping JS090731=20 Unknown host JS090731.=20 ping js090731=20 Unknown host js090731.=20 I don't have Domain name server in Linux , so I do ping in Windows ,=20 actually I just found this windows , it is :js090731-ix2k0v ,=20 because in "onstat -g ses" I can only see js090731 ,=20 that is why I can not find it ...=20 May I get longer string of host name in "onstat -g ses" ?=20 ***************************************************************************= ****=20 Forum Note: Use "Reply" to post a response in the discussion forum.=20

↪ replying to Art S. Kagel

Flores, Julio — Thu, 04 Mar 2010 04:18:06 — source: IIUG Forums & Mailing Lists

Try with the command: netstat -a|grep LISTEN |grep <service> where <service> is the name or port number defined in the sqlhosts tcp conection. Whit this information, try to cross with the information of the 'onstat -g ses' -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art S. Kagel Sent: miércoles, 03 de marzo de 2010 09:32 p.m. To: ids@iiug.org Subject: RE: how to get host's ip address of session ! [19212] Unfortunately no. Art=20 -----Original Message----- From: MARS CHEN <mars@jsun.com> Sent: Wednesday, March 03, 2010 10:24 PM To: ids@iiug.org Subject: Re: how to get host's ip address of session ! [19211] I've tried it , but it showes :=20 Unknown host JS090731=20 ping JS090731=20 Unknown host JS090731.=20 ping js090731=20 Unknown host js090731.=20 I don't have Domain name server in Linux , so I do ping in Windows ,=20 actually I just found this windows , it is :js090731-ix2k0v ,=20 because in "onstat -g ses" I can only see js090731 ,=20 that is why I can not find it ...=20 May I get longer string of host name in "onstat -g ses" ?=20 ***************************************************************************= ****=20 Forum Note: Use "Reply" to post a response in the discussion forum.=20 ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Art S. Kagel

John Miller iii — Thu, 04 Mar 2010 07:09:56 — source: IIUG Forums & Mailing Lists

In sysmaster if you select from syssessions then you will get the full hostname. John F. Miller III STSM, Support Architect miller3@us.ibm.com 503-578-5645 IBM Informix Dynamic Server (IDS) ids-bounces@iiug.org wrote on 03/03/2010 07:32:14 PM: > Unfortunately no. > > Art=20 > > -----Original Message----- > From: MARS CHEN <mars@jsun.com> > Sent: Wednesday, March 03, 2010 10:24 PM > To: ids@iiug.org > Subject: Re: how to get host's ip address of session ! [19211] > > I've tried it , but it showes :=20 > Unknown host JS090731=20 > > ping JS090731=20 > Unknown host JS090731.=20 > > ping js090731=20 > Unknown host js090731.=20 > > I don't have Domain name server in Linux , so I do ping in Windows ,=20 > actually I just found this windows , it is :js090731-ix2k0v ,=20 > because in "onstat -g ses" I can only see js090731 ,=20 > that is why I can not find it ...=20 > > May I get longer string of host name in "onstat -g ses" ?=20 > > ***************************************************************************= > ****=20 > Forum Note: Use "Reply" to post a response in the discussion forum.=20 > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

Related threads

Glossary

IDS (Informix Dynamic Server)