If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > Decode IP from application ID

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 10-27-10, 10:07
DBFinder DBFinder is offline
Registered User
 
Join Date: Sep 2008
Location: Toronto,Canada
Posts: 606
Decode IP from application ID

Hi Friends,

Can some one advise me how do we find IP of client connected to DB2 remotely.

Sometimes I used to Hex convert discarding first caharacter. But just today I found appi_id which does not seem convertible easily.

Before GA070290.xxxx.xxxxx simply this one was 10.7.2.144.
Now C0A80A0D.xxxx..... this one is not similar


Is there a trick or any official way to find the IP.

Regards

DBFinder
Reply With Quote
  #2 (permalink)  
Old 10-27-10, 10:28
Marcus_A Marcus_A is online now
Registered User
 
Join Date: May 2003
Location: USA
Posts: 5,198
You do not discard the first character. You convert it as follows if greater than "F":

G=0
H=1
I=2
etc.

So I assume that you just convert the "C0" to the decimal value.
__________________
M. A. Feldman
IBM Certified DBA on DB2 for Linux, UNIX, and Windows
IBM Certified DBA on DB2 for z/OS and OS/390
Reply With Quote
  #3 (permalink)  
Old 10-27-10, 10:41
DBFinder DBFinder is offline
Registered User
 
Join Date: Sep 2008
Location: Toronto,Canada
Posts: 606
Thank you. I will change it.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On