convert application id which starts with "/"

[mcmreddy@gmail.com]

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.00 010024001E
VBUILDDB 1


how to convert /1061212.3238.00 010024001E to ip address?

[Artur]

Re: convert application id which starts with "/"

More convenient is to get the information using sql:

select inbound_comm_ad dress from table(snapshot_ appl('YOURDB',-1)) as
t

INBOUND_COMM_AD DRESS
--------------------------------
-
-
192.168.1.3 21508

Read:

http://publib.boulder.ibm.com/infocenter/db2luw/v8//topic/com.ibm.db2.udb.doc/admin/r0007089.htm

-- Artur Wronski

[Pierre Saint-Jacques]

Re: convert application id which starts with "/"

I wonder about the " / " in the application id.
Normally, this would be an hexadecimal number, let's say: A
So:
/1061212.3238.00 010024001E becomes A1061212.3238.0 0010024001E

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
<mcmreddy@gmail .com> a écrit dans le message de news:
1136400758.1232 29.94060@o13g20 00...legro ups.com...[color=blue]
> 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.00 010024001E
> VBUILDDB 1
>
>
> how to convert /1061212.3238.00 010024001E to ip address?
>[/color]

[Knut Stolze]

Re: convert application id which starts with &quot;/&quot;

Pierre Saint-Jacques wrote:
[color=blue]
> I wonder about the " / " in the application id.
> Normally, this would be an hexadecimal number, let's say: A
> So:
> /1061212.3238.00 010024001E becomes A1061212.3238.0 0010024001E
>
> 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.[/color]

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@gmail.com]

Re: convert application id which starts with &quot;/&quot;

I think there is a problem in showing application id for certain
connections...
I coundn't convert application id /1061044.3529.00 0A0008000A
properly. But the corresponding ip address from snapshot is
106.104.46.112