How to check the client ip address

wongpcl · #1 (**permalink**) 02-25-05, 04:45

Hi,

We're using DB2 V8 on AIX platform. Some DB2 windows clients connect to this DB2 Server through TCP/IP.

I heard that I can check the ip address of the DB2 client from the LIST APPLICATION output, but not sure how to check it.

Here is an example of the LIST APPLICATION output, then what is the ip address of the client?

DB2ICA java 112 GA1A3F8C.A79D.05D2B4181012 TESTDB 1

Thanks and regards,

grofaty · #2 (**permalink**) 02-25-05, 04:57

Group two by two and convert from hexa to decimal:
GA1A3F8C
GA=?????? G - is little bit strange. Hexa numbers are from 1 to F. G isn't good?
1A=26
A3=163
8C=140

sathyaram_s · #3 (**permalink**) 02-25-05, 05:05

in v8, you can do
db2 "select INBOUND_COMM_ADDRESS from table(SNAPSHOT_APPL('',-1)) as x"

Marcus_A · #4 (**permalink**) 02-25-05, 12:28

Quote:

Originally Posted by grofaty

Group two by two and convert from hexa to decimal:
GA1A3F8C
GA=?????? G - is little bit strange. Hexa numbers are from 1 to F. G isn't good?
1A=26
A3=163
8C=140

With a DRDA connection, you have to translate the first character of the hex IP address. All the other hex numbers are OK.

G = 0
H = 1
I = 2
J = 3
etc

grofaty · #5 (**permalink**) 02-28-05, 01:48

Marus_A,
Thanks for tip about DRDA connections.
Grofaty

Internet Services

Web Development

Digital Marketing

Consumer Tech