Results 1 to 6 of 6
  1. #1
    Join Date
    Jan 2003
    Posts
    1,605

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

    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

  2. #2
    Join Date
    Sep 2002
    Posts
    456
    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.

  3. #3
    Join Date
    Aug 2002
    Location
    Chennai, India
    Posts
    184
    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.

  4. #4
    Join Date
    Jan 2003
    Posts
    1,605
    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

  5. #5
    Join Date
    Feb 2004
    Location
    Copenhagen
    Posts
    220

    Arrow Hi

    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 !!
    Last edited by Tank; 12-28-05 at 10:16.
    Kristian K. Hansen
    Project Supervisor
    National Board of Health

  6. #6
    Join Date
    Sep 2002
    Posts
    456
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •