Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2009

    Unanswered: Querying process (edus) information

    I am studying database administration. I would like to do some queries to get information about process, but I am having problems with it, I would be very happy if someone could help me. (I posted it in developerWorks forum, but nobody could help me)

    I was able to discover the db2pd tool, from there I could get information about all the EDUs.
    I would like to get EDUs information like status, is there any command to do it? I have been looking the db2pd tool with its arguments but I wasn't able to find any argument to query information about one specific EDU.
    I also tried the db2diag -eduid, but it outputs the log file, it is not exactly what I want. I would like the status at the time I run the command.

    I also want to get information about EDUs for specific databases. For instance: if I stop and start my instance, without any connection, I get the "basic" edus (they are 8):
    ================================================== ==================================================
    17 47108031768896 10374 db2resync 0 0.000000 0.000000
    16 47108035963200 10373 db2tcpcm 0 0.000000 0.000000
    15 47108040157504 10372 db2tcpcm 0 0.000000 0.000000
    14 47108044351808 10371 db2ipccm 0 0.000000 0.000000
    13 47108048546112 10370 db2licc 0 0.000000 0.000000
    12 47108052740416 10369 db2thcln 0 0.000000 0.000000
    11 47108056934720 10368 db2alarm 0 0.000000 0.000000
    1 47107796887872 10367 db2sysc 0 0.040000 0.020000

    But if someone connects, I get a lot more.
    I would like to be able to have 2 distinct connections to databases (it can be two connections to the same db or to different db) and be able to know to which connection is the process related to.

    In my research I found out that Oracle would use a dinamical view called v$process and one could query it, but DB2 doesn't use this approach.
    I've googling for 2 or 3 days and couldn't make much progress, I would be very happy if you could help me.

    After, I foudn out that to query the EDUs related to a database, I could use the db2pd -agents command, is it right? Then I would get the information related to the databases. But I still dont know how to get the infos related to connection processes.

    thank you,

  2. #2
    Join Date
    Aug 2008
    Toronto, Canada
    You may find this article helpful:
    How multithreaded architecture works in DB2 9.5

  3. #3
    Join Date
    Nov 2009
    ok, Ill take a look.

Posting Permissions

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