'list application':how to know which application is under name 'java'?

[grofaty]

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

 

[gregsimpson]

grofaty,

I find db2pd gives a wealth of information.

http://publib.boulder.ibm.com/infoc...?topic=/com.ibm.db2.udb.doc/core/r0011729.htm

Cheers
Greg

 

[grofaty]

Hi,
can you please provide the exact command for solving my problem?
Thanks,
Grofat

 

[gregsimpson]

Grofat,

I would say something along the lines of

db2pd -db "dbname" -applications -agents

Not at work to try syntax or output to see if it does exactly what you require. Give it a try and see if it gives you the output you require.

Further info here

http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0504poon2/

Cheers
Greg

 

[grofaty]

gregsimpson,
thanks for reply. I have seached all the db2pd info and I can't find out the useful info.
This is probably more question about WebSphere than DB2. So how to find out from the data on db2 site which application is run under WebSphere. I can find out the clientPID (process ID). Is there any way to say in WebSphere which process ID is running which java application?
Thanks,
Grofaty

 

[gregsimpson]

grofaty,

you've lost me with the websphere bit. However if you issue

db2pd -db dbname -age

You will get a list containing a clientpid and agent pid and an application handle, amongst other things. The client pid is the as it says the pid at the client, so in my instance I had connections from windows and AIX and could trace the pids on windows and AIX which are runnin the db2 applications on AIX, where my database resides.

Does that help at all

Cheers
greg

 

[grofaty]

gregsimpson,
all of the ClientPIDs have the same PID, because at WebSphere I am using connection pooling. So only one process (WebSphere connection polling 'program') is connected to DB2. WebSphere applications are 'connected' to connection polling and connection polling is connected to DB2. So at DB2 site I can see only one ClientPID.

Is there any other solution?

Thanks,
Grofaty

 

[Truusvlugindewind]

You just answered you own question, didn't you? How do you qualify "an application"? What do you want to distunguish?

Maybe you should split-up your WebShere configuration and give each application it's own container/JVM.

It's more of a J2EE issue (would not call it a problem) than a DB2 issue. Did you try thoose forums?