DB2 UDB Connections

Matt Emery

DB2 UDB Connections
On AIX, when doing a "list application" command the ip address of a
connected client can be found in the "application id" field, in hex format.
When I convert the hex value to decimal I get an ip address that is not in
our network.
Does anyone know the trick for interpreting these hex tcp/ip numbers and
determining who is connected to the database?

Thanks in advance.

Matthew J. Emery
Jackson National Life Insurance Company
Technology Department - Database Administrator
voice: 517-367-3715
fax: 517-394-0986
email: [login to unmask email] <mailto:[login to unmask email]>
pager, alphanumeric one way: 517-232-1617
internet pager: [login to unmask email]
<mailto:[login to unmask email]>

Larry Fisher

Re: DB2 UDB Connections
(in response to Matt Emery)
The IP address is not hex. It is a binary dotted decimal address. 10000000
00001010 00011110 converts to an IP address of 128.10.2.30.

> -----Original Message-----
> From: Emery, Matt [SMTP:[login to unmask email]
> Sent: Wednesday, October 06, 1999 9:40 AM
> To: [login to unmask email]
> Subject: DB2 UDB Connections
>
> On AIX, when doing a "list application" command the ip address of a
> connected client can be found in the "application id" field, in hex
> format. When I convert the hex value to decimal I get an ip address that
> is not in our network.
>
> Does anyone know the trick for interpreting these hex tcp/ip numbers and
> determining who is connected to the database?
>
> Thanks in advance.
>
> Matthew J. Emery
> Jackson National Life Insurance Company
> Technology Department - Database Administrator
> voice: 517-367-3715
> fax: 517-394-0986
> email: [login to unmask email] <mailto:[login to unmask email]>
> pager, alphanumeric one way: 517-232-1617
> internet pager: [login to unmask email]
> <mailto:[login to unmask email]>
>
>

Michael McCarthy

Re: DB2 UDB Connections
(in response to Larry Fisher)
Matt,

When an application is connected via tcpip, the first part of the
application id is the hex representation of the client's ip address. Each two
bytes of the first part of the appl id represents a part of the ip address. The
example below will show how to convert it.

Appl ID ===> AC107C19.A305.991006140921

AC = 172
10 = 16
7C = 124
19 = 25

You're tcpip address is 172.16.124.25.

Hope this helps,

Mike.






"Emery, Matt" <[login to unmask email]> on 10/06/99 09:40:22 AM

Please respond to DB2 Data Base Discussion List <[login to unmask email]>

To: [login to unmask email]
cc: (bcc: Michael McCarthy/DTC)
Subject: [DB2-L] DB2 UDB Connections




On AIX, when doing a "list application" command the ip address of a
connected client can be found in the "application id" field, in hex format.
When I convert the hex value to decimal I get an ip address that is not in
our network.
Does anyone know the trick for interpreting these hex tcp/ip numbers and
determining who is connected to the database?

Thanks in advance.

Matthew J. Emery
Jackson National Life Insurance Company
Technology Department - Database Administrator
voice: 517-367-3715
fax: 517-394-0986
email: [login to unmask email] <mailto:[login to unmask email]>
pager, alphanumeric one way: 517-232-1617
internet pager: [login to unmask email]
<mailto:[login to unmask email]>


Danny Creed

Re: DB2 UDB Connections
(in response to Michael McCarthy)


You have to use the "show detail"
For example:
Auth Id Application Name Appl. Client Application Id Seq# C
lient Client Client Client Host Application Id Seq# Host
DB Name Host
Handle D
B Alias Node Release Codepage
Release
-------- -------------------- ---------- -------------------------------- ---- -
------- -------- -------- ---------- -------------------------------- ---- -----
--------------- --------
YIRTOP1 TER.EXE 153 902E668E.0498.991006142405 0001 D
B2PROD SQL02011 850 xxxxxxxxx.BC39.991006142406 0000 DSN1
DSN05011

The number you have to evaluate is:
902e668e
90=144
2e=46
66=102
8e=142
Thus IP address = 144.46.102.142

Regards
Danny






[login to unmask email] on 10/06/99 08:40:22 AM

Please respond to [login to unmask email]

To: [login to unmask email]
cc: (bcc: Daniel S Creed/HI/CSC)
Subject: DB2 UDB Connections



On AIX, when doing a "list application" command the ip address of a
connected client can be found in the "application id" field, in hex format.
When I convert the hex value to decimal I get an ip address that is not in
our network.
Does anyone know the trick for interpreting these hex tcp/ip numbers and
determining who is connected to the database?

Thanks in advance.

Matthew J. Emery
Jackson National Life Insurance Company
Technology Department - Database Administrator
voice: 517-367-3715
fax: 517-394-0986
email: [login to unmask email] <mailto:[login to unmask email]>
pager, alphanumeric one way: 517-232-1617
internet pager: [login to unmask email]
<mailto:[login to unmask email]>


BREIDENSTINE JOHN L.

Re: DB2 UDB Connections
(in response to Danny Creed)
Matthew J. Emery

It is in hex format (at least on my machine) and crossing it to decimal
works fine. Heres how it works.

HEX Number. AABA5174
AA = 170
BA = 186
51 = 81
74 = 116
Therefore IP # = 170.186.81.116

Regards John B.
Attachments

  • vcard.vcf (<1k)