470,591 Members | 2,137 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,591 developers. It's quick & easy.

convert application id which starts with "/"

Hi!
Is there a way to convert application id ( db2 list applications
output) to a readable format?.
Auth Id Application Appl. Application Id DB
# of
Name Handle Name
Agents
-------- -------------- ---------- ------------------------------
-------- -----
VBUILD JDBC4DB2 735 /1061212.3238.00010024001E
VBUILDDB 1
how to convert /1061212.3238.00010024001E to ip address?

Jan 4 '06 #1
4 2280
More convenient is to get the information using sql:

select inbound_comm_address from table(snapshot_appl('YOURDB',-1)) as
t

INBOUND_COMM_ADDRESS
--------------------------------
-
-
192.168.1.3 21508

Read:
http://publib.boulder.ibm.com/infoce...n/r0007089.htm

-- Artur Wronski

Jan 4 '06 #2
I wonder about the " / " in the application id.
Normally, this would be an hexadecimal number, let's say: A
So:
/1061212.3238.00010024001E becomes A1061212.3238.00010024001E

What your are concerned with is the part:A1061212
A1 in hex is 161
06 in hex is 6
12 in hex is 18
12 in hex is 18
So, the IP address of the connection is: 161.6.18.18

Convert each pair of the first 8 digits to give you the IP address.
HTH, Pierre.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
<mc******@gmail.com> a écrit dans le message de news:
11*********************@o13g2000cwo.googlegroups.c om...
Hi!
Is there a way to convert application id ( db2 list applications
output) to a readable format?.
Auth Id Application Appl. Application Id DB
# of
Name Handle Name
Agents
-------- -------------- ---------- ------------------------------
-------- -----
VBUILD JDBC4DB2 735 /1061212.3238.00010024001E
VBUILDDB 1
how to convert /1061212.3238.00010024001E to ip address?


Jan 5 '06 #3
Pierre Saint-Jacques wrote:
I wonder about the " / " in the application id.
Normally, this would be an hexadecimal number, let's say: A
So:
/1061212.3238.00010024001E becomes A1061212.3238.00010024001E

What your are concerned with is the part:A1061212
A1 in hex is 161
06 in hex is 6
12 in hex is 18
12 in hex is 18
So, the IP address of the connection is: 161.6.18.18

Convert each pair of the first 8 digits to give you the IP address.
HTH, Pierre.


The first character of the application ID is treated a bit differently due
to DRDA requirements. The digits 0 thru 9 are mapped to the letters 'G' ..
'P'. Where the '/' is coming from, I do not know. It seems to be a bit
odd.

Here is also a description on the encoding of the IP address in the
application ID: http://tinyurl.com/9sjqh

--
Knut Stolze
DB2 Information Integration Development
IBM Germany
Jan 5 '06 #4
I think there is a problem in showing application id for certain
connections...
I coundn't convert application id /1061044.3529.000A0008000A
properly. But the corresponding ip address from snapshot is
106.104.46.112

Jan 5 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

13 posts views Thread by Bob Day | last post: by
4 posts views Thread by nacho | last post: by
2 posts views Thread by Ian Boyd | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.