Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2002
    Posts
    30

    Unanswered: How to check the client ip address

    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,

  2. #2
    Join Date
    Jan 2003
    Posts
    1,605
    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

  3. #3
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    in v8, you can do
    db2 "select INBOUND_COMM_ADDRESS from table(SNAPSHOT_APPL('',-1)) as x"
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    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
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  5. #5
    Join Date
    Jan 2003
    Posts
    1,605
    Marus_A,
    Thanks for tip about DRDA connections.
    Grofaty

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •