Hi,

My java application is running under application server (e.g. IBM WebSphere Application Server) and application connects to IBM DB2 database.

On DB2 database I can see 'application ID' and the name of application. Java applications running from windows environment I see application name 'java.exe' and java applications running from unix environment I see application name 'java'. But I don't know which java application is it. Is there any way to find out which application si running under application name 'java'?

Thanks,
Grofaty

My system:
db2 WSE v8 fp9 on Windows 2003 sp1

Take a snapshot of the database; there are various formats e.g.:

db2 get snapshot for applications on <your database name>

or to get everything

db2 get snapshot for all on <your database name>

From db2 list applications note down the application handle and then search the output of snapshot to cross-reference.

To know information about a particular application handle - after issuing 'db2 list applications show detail'; you can use...

db2 get snapshot for application agentid <application handle>

HTH.

Hi,
thanks for reply. I know all about snapshots. But I don't know all this info and how to relate WebSphere java application.

This is probably more WebSphere question than DB2 question. So how to find out witch db2 'application hande' is which application under WebSphere. Is there any command on WebSphere to find out the application name (the best would be path to .ear file).

Thanks,
Grofaty

I understand your question

I'm pretty sure it's the Application Id from the listing
of 'list applications show detail' that binds frontend and
backend together ex:

MAST javaw.exe 96 C0A8D775.HD06.01A9C8135417 0005 7 0 197908 UOW Waiting 28-12-2005 15.05.30,678943 SST /home/db2inst2/db2inst2/NODE0000/SQL00003/

The C0A8D775.HD06.01A9C8135417 is the connection id -
apparantly querying this depends on building java funtion try seeing:

http://www-128.ibm.com/developerwork...302stolze.html

Good luck !!

Let's say you have the following application_id:

AA318EE5.B098.040125192529

Cut the first half into four equal peices i.e.

AA 31 8E E5

Using the Window's calculator convert each part into Decimal and that will be your IP address! The second part after dot (.) is port number and third part is timestamp.

You might find following links useful as well:

http://www-1.ibm.com/support/docview...=utf-8&lang=en
http://publib.boulder.ibm.com/infoce...n/r0001166.htm