Hi Friends,
We are using db2v8.1 on Win2K. After issuing the "db2 list applications" command I got the following output. Now, my query is how to identify which "Application Id" is from which client/tcpip address. After going thru the online manual I came to know "Application Id" parameter denotes the same and converts the IP address into hexadecimal. But still it is not clear to me as how to get the IP address or node name. If anybody can explain the same to me it would be of great help.

For example Application Id :
17216851.1444.000B00180031
or
*LOCAL.DB2.040705055452

what does this denote?

db2 => list applications

Auth Id Application Appl. Application Id DB # of
Name Handle Name Agents

-------- -------------- ---------- ------------------------------ -------- -----
FFM db2syscs.exe 85 *LOCAL.DB2.040705055452
FFM_ENTS 1
FFM JDBC4DB2 80 17216851.1444.000B00180031 FFM_ENTS 1
FFM db2syscs.exe 81 *LOCAL.DB2.040705055355 FFM_ENTS 1
FFM db2syscs.exe 73 *LOCAL.DB2.040705055226 FFM_ENTS 1
FFM JDBC4DB2 71 17216851.1398.000B00160018 FFM_ENTS 1

Applicaion ID 17216851.1444.000B00180031

IP address (group two characters together and the convert from hex to dec - you can use Calculator program - just turn on Scientific option from View menu)
17=23
21=33
68=104
51=81

So IP adress is 23.33.104.81

Port number in hexa
1444 = 5188

LOCAL.DB2.040705055452
Local means localhost so from within the same computer.

The third part of Application ID is timestamp of connection. I just can't remember how to get it. Does anyone know how to get timestamp from application id? Within LOCAL I understand so the above time is: 2004-07-07-05:54:52. What about remote connection timestamp. It is in hexa so, how to get this timestamp from Application ID?

Grofaty

Thanks a lot.

The timestamp is in CUT (or GMT)
The format is
yymmddHHMMSS

There is no hex in this filed

Cheers
Sathyaram

Hi,

sathyaram_s your statement is true for local connections what about remote connections e.g.: Application ID: 17216851.1444.000B00180031

So what does 000B00180031 means? Noties charachter "B" inside string?

Thanks,
Grofaty

That looks a strange number to me ...

The date with year and day part 00 is strange ...

Cheers
Sathyaram

Hi,

I have tested: db2 list application on Linux and there it works fine, but on Windows there are some strange numbers and characters in field 3. Why is there a difference?

Grofaty

Why not do a snapshot for applications? That gives you the IP too, in a less cryptic format.

There's also the new query-able snapshot stuff:
SELECT INBOUND_COMM_ADDRESS FROM TABLE( SNAPSHOT_APPL( 'SAMPLE', -1 )) as SNAPSHOT_APPL

See the Monitoring Guide for full details of all the available columns, it's pretty extensive.