convert application id which starts with "/"

[mcmreddy]

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?

[Artur]

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

[Pierre Saint-Jacques]

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?

[Knut Stolze]

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

[mcmreddy]

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