RE: Interpretation of onstat -g ses, hostname column
Colin,
You surprise me. I thought that us old wizened practitioners could
still remember our hex conversions. Immediately I saw the numbers in
hex I was converting them into decimal.
And Mike,
I thought you would have known better as well. It's all part of the
development plot to make it look a lot more complicated than it is.
BTW All,
If you follow the max number of extents calculation in the performance
guide you no longer have to do the hex conversion. Oncheck gives the
address in decial separated by a colon, but nobody has told the tech
writers of the change. And who else has spotted the other deliberate
error in that procedure?
Regards
Malcolm
-----Original Message-----
From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org]
On Behalf Of Colin Bull
Sent: 02 November 2004 16:52
To: informix-list@iiug.org
Subject: RE: Interpretation of onstat -g ses, hostname column
Mike Reetz wrote
> Sometimes the hostname is the DNS entry (i.e. human readable). Other
> times, when the connecting computer does not have a DNS entry, the
> value is in hex (??). How can that be changed back to an IP address?
>
> Example:
>
> 3 values for hostname from onstat -g ses:
>
> a010a1e
> a010d22
> a0e0213
>
> From netstat -a connections via sqlexec with only IP addresses:
>
> 10.1.13.34
> 10.1.10.30
> 10.14.2.19
>
> How can I map from the onstat output to the one of the IPs in
> the netstat list?
You should convert the onstat output to dotted hex pairs from the right,
so a010a1e becomes a.01.0a.1e.
Put 1e in Windows calculater in hex mode, and then click the dec button
and it gives 30. If you want the rest a =10, 01=1, a-10. So altogether
that is 10.1.10.30
Colin Bull
________________________________________________________________________
This email has been scanned for all known viruses by the MessageLabs
Email Security System.
________________________________________________________________________
sending to informix-list
sending to informix-list
sending to informix-list