View previous topic :: View next topic
|
Author |
Message |
vasanthz
Global Moderator
Joined: 28 Aug 2007 Posts: 1742 Location: Tirupur, India
|
|
|
|
Hi,
I am a DB2 novice & pardon my terminology.
In some of the DB2 load jobs, PGM=DSNUTILB they have CPU time higher than the elapsed time, which suggest that multiple threads are running in parallel.
Could you please let me know where I can see how many TCBs are concurrently active for a particular DB2 job?
Any specific field in SMF? or can we see it in the job itself?
Thanks & Regards, |
|
Back to top |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008 Posts: 8696 Location: Dubuque, Iowa, USA
|
|
|
|
If your site uses zIIP processors, then you would need to look at those fields in the SMF records as well. I don't know of anywhere that records the number of TCBs in use, although it is possible the value is somewhere in the SMF records.
Also note that zIIP processors can run at higher speeds than your CP engine. zIIP processors can run parallel DB2 tasks so there's another source of parallelism. |
|
Back to top |
|
|
vasanthz
Global Moderator
Joined: 28 Aug 2007 Posts: 1742 Location: Tirupur, India
|
|
|
|
Hi Robert,
Thank you for your thought.
We have zIIP processors, but the Central processor CPU time was higher than the elapsed time.
To check the number of TCBs active I looked at the SMF TYPE 30 records but unable to find a breakup of all the TCBs that were active. It appears type 30 has only a summarised data of all the TCBs. :S No luck here
Regards, |
|
Back to top |
|
|
vasanthz
Global Moderator
Joined: 28 Aug 2007 Posts: 1742 Location: Tirupur, India
|
|
|
|
Hi,
The number of TCBs invoked & parallelism info were present in MXG DB2ACCT member. A huge relief after 4 days. :-)
Thanks & Regards, |
|
Back to top |
|
|
|