Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2005
    Posts
    108

    Unanswered: DB2 application ID: Conver hex IP address to decimal address

    Hi All
    According to the book, the first 8 characters of "Applications Id" is the IP address (in hex) of hosts who have connections to DB2. I don't have problem to convert A2462315 to 162.70.35.21. But how to convert GAADC916 starting with G? Thank you for advice.

    $ db2 list applications

    Auth Id Appl-name Appl-handl Application-Id DB #agnt

    -------- -------------- ---------- ------------------------------ -------- -----
    AF36D1 db2jccThread-8 479 A2462315.H02A.01082F503165 AH3D_02 1
    AF36DAT dbsurfer.exe 150 GAADC916.N807.01A6C5163135 AH3D_02 1
    Last edited by DBA-Jr; 12-16-05 at 00:06.

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    For DRDA connections (the only time you will see these hex numbers > F), make the following conversion:

    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

Posting Permissions

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