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):
EDU ID TID Kernel TID EDU Name USR SYS
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.