IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

DSNUTILB - parallelism


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
vasanthz

Global Moderator


Joined: 28 Aug 2007
Posts: 1742
Location: Tirupur, India

PostPosted: Mon Jan 19, 2015 10:16 pm
Reply with quote

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
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8696
Location: Dubuque, Iowa, USA

PostPosted: Tue Jan 20, 2015 4:22 am
Reply with quote

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
View user's profile Send private message
vasanthz

Global Moderator


Joined: 28 Aug 2007
Posts: 1742
Location: Tirupur, India

PostPosted: Tue Jan 20, 2015 11:02 pm
Reply with quote

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
View user's profile Send private message
vasanthz

Global Moderator


Joined: 28 Aug 2007
Posts: 1742
Location: Tirupur, India

PostPosted: Thu Jan 22, 2015 12:18 am
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Unloading Data from DECIMAL(n,0) Colu... DB2 6
No new posts DB2 parallelism DB2 1
No new posts DB2 Load using DSNUTILB with FORMAT I... DB2 4
No new posts DSNUTILB invocation conventions PL/I & Assembler 4
No new posts DSNUTILB and PLATINUM - Load Perforance DB2 9
Search our Forums:

Back to Top