Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

DSNUTILB - parallelism

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
vasanthz

Global Moderator


Joined: 28 Aug 2007
Posts: 1445
Location: Azeroth

PostPosted: Mon Jan 19, 2015 10:16 pm    Post subject: DSNUTILB - parallelism
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: 7913
Location: Bellevue, IA

PostPosted: Tue Jan 20, 2015 4:22 am    Post subject:
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: 1445
Location: Azeroth

PostPosted: Tue Jan 20, 2015 11:02 pm    Post subject:
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: 1445
Location: Azeroth

PostPosted: Thu Jan 22, 2015 12:18 am    Post subject:
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    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts DB2 Load using DSNUTILB with FORMAT I... yogi.47eie DB2 4 Wed May 28, 2014 4:54 pm
No new posts DSNUTILB invocation conventions vshchukin PL/I & Assembler 4 Thu Mar 20, 2014 9:53 am
No new posts DSNUTILB and PLATINUM - Load Perforance vicky10001 DB2 9 Sun Jun 23, 2013 7:56 pm
No new posts DSNUTILB various parameter details Rohit Umarjikar DB2 11 Mon Apr 16, 2012 9:06 pm
No new posts Getting error while using DSNUTILB ut... Gnanas N DB2 2 Thu Jun 30, 2011 3:17 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us