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
 

 

Run stats processing on zIIP Engine

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

New User


Joined: 26 Aug 2015
Posts: 28
Location: India

PostPosted: Fri Oct 14, 2016 10:24 am    Post subject: Run stats processing on zIIP Engine
Reply with quote

Hi,

With DB2 V11 RUNSTATS processing like COLCARD, FREQVAL, HISTOGRAM statistics, including inline stats are zIIP eligible . As we understand that DBA does not have control where DB2 utilities will run . DB2 decides that.
Are there any pointers how we can move DB2 utilities to run on zIIP engine?

FYI -IBM's System z Integrated Information Processor (zIIP) is a specialty offload engine that helps improve
computing performance for a subset of mainframe workloads

Thanks,
Virendra
Back to top
View user's profile Send private message

enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10202
Location: italy

PostPosted: Fri Oct 14, 2016 3:28 pm    Post subject: Reply to: Run stats processing on zIIP Engine
Reply with quote

Quote:
As we understand that DBA does not have control where DB2 utilities will run . DB2 decides that.
if You have evidence of that
no reason to ask
Quote:
Are there any pointers how we can move DB2 utilities to run on zIIP engine?


anyway take a look at
https://www.redbooks.ibm.com/abstracts/sg248180.html

and google with
ibm redbooks ziip db2 usage
Back to top
View user's profile Send private message
Virendra Shambharkar

New User


Joined: 26 Aug 2015
Posts: 28
Location: India

PostPosted: Fri Oct 14, 2016 3:47 pm    Post subject: Reply to: Run stats processing on zIIP Engine
Reply with quote

Thanks a lot . I realized after posting . DB2 itself will redirect eligible processing to zIIP if capacity is available.

Thanks again.
Back to top
View user's profile Send private message
Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 1610
Location: NY,USA

PostPosted: Fri Oct 14, 2016 9:54 pm    Post subject:
Reply with quote

Quote:
FYI -IBM's System z Integrated Information Processor (zIIP) is a specialty offload engine that helps improve
computing performance for a subset of mainframe workloads
IBM don't charge for zIIP engines to compete with others.
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 7913
Location: Bellevue, IA

PostPosted: Fri Oct 14, 2016 9:59 pm    Post subject:
Reply with quote

Quote:
IBM don't charge for zIIP engines to compete with others.
What is your source for this information? I've seen price quotes from $40,000 to $100,000 (depending on the machine -- more for z13 and less for z9) per zIIP engine. This is significantly less than the cost of a standard engine, but certainly zIIP engines are not free. From http://www-03.ibm.com/systems/z/hardware/features/ziip/pricing.html
Quote:
The zIIPs are attractively priced delivering a lower total cost of acquisition.

The maintenance price for the zIIP is significantly lower than that of general purpose CPs. Also, the z13 provides symmetric multithreading (SMT) support for zIIP specialty engines. The use of SMT can provide significantly more throughput for zIIPs.
Back to top
View user's profile Send private message
Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 1610
Location: NY,USA

PostPosted: Fri Oct 14, 2016 10:09 pm    Post subject:
Reply with quote

Quote:
but certainly zIIP engines are not free.
You are right, I double checked with another DBA and the link by you , it is at discounted price with finite capacity.
some bmc options for simple (non-sql) unload & load, such as DIRECT YES that cut CPU significantly.
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 7913
Location: Bellevue, IA

PostPosted: Fri Oct 14, 2016 10:16 pm    Post subject:
Reply with quote

There are advantages to using zIIP engines (you can have 2, or in some limited cases 4, per general processor; they run at the full machine speed no matter what the general processor(s) speed is; if they're installed the operating system will use them automatically; no software charges on zIIP processors; can lower 4-hour rolling average MSUs for sub-capacity sites) but they do have a cost.
Back to top
View user's profile Send private message
vasanthz

Global Moderator


Joined: 28 Aug 2007
Posts: 1445
Location: Azeroth

PostPosted: Sat Oct 15, 2016 2:39 am    Post subject:
Reply with quote

Quote:
Are there any pointers how we can move DB2 utilities to run on zIIP engine?

My two cents..
DB2 controls what and how much of that work runs on zIIP and we have no control over it. However there are ways to make sure the eligible work actually runs on zIIP.

IEAOPTXX member option ZIIPAWMT - This parameter is somewhat like that amount of time the work will wait for zIIP. If zIIP is very busy processing other work and is not available for the specified amount of time, then the zIIP eligible work will run in General Processor.
(provided IIPHONORPRIORITY=YES)

zIIP eligible work running on General processor is generally a thing best monitored and made to run on zIIP, without affecting response times/performance.

There is also a field in DB2 SMF records which says the amount of zIIP eligible work that ran on GP. Based on the amount of zIIP eligible work that ran on GP, ZIIPAWMT can be tuned or additional zIIP engines can be added to make the work run on zIIP.
Back to top
View user's profile Send private message
vasanthz

Global Moderator


Joined: 28 Aug 2007
Posts: 1445
Location: Azeroth

PostPosted: Sat Oct 15, 2016 2:45 am    Post subject:
Reply with quote

Quote:
Also, the z13 provides symmetric multithreading (SMT) support for zIIP specialty engines. The use of SMT can provide significantly more throughput for zIIPs.

Oh does that mean zIIP would have more throughput than a GP for certain work? I've always through zIIP is just a GP with microcode to disable some instructions.
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 7913
Location: Bellevue, IA

PostPosted: Sat Oct 15, 2016 5:22 am    Post subject:
Reply with quote

Quote:
Oh does that mean zIIP would have more throughput than a GP for certain work?
The zIIP doesn't have the full functionality of a CP, so it won't necessarily complete the same amount of work as fast as a CP could do it. However, if your site is not using the full speed of the machine then the zIIP, which runs at the full speed of the machine, could potentially do more work than the CP for a given amount of time. Something else to consider, though, is that there frequently isn't that much work for a zIIP to do -- unless your site is running Java and DB2 and Websphere and MQ Series in production, that is. We didn't have these products and it was rare for our zIIP to run more than 3% of the workload, so it was almost never very active.
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 Streaming Batch Processing Problem Manshadi DB2 4 Sat Sep 24, 2016 12:14 pm
No new posts Extracting Information from DD Statem... Charles Wolters All Other Mainframe Topics 7 Wed Apr 13, 2016 10:21 pm
No new posts Output of NDM stats shreya19 All Other Mainframe Topics 5 Wed Mar 02, 2016 4:35 pm
No new posts how to implement multi-thread process... dejunzhu COBOL Programming 7 Sat Oct 31, 2015 2:15 pm
No new posts MQ message to wait for processing mohitsaini Java & MQSeries 1 Sat Jun 20, 2015 5:39 am


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