View previous topic :: View next topic
|
Author |
Message |
Virendra Shambharkar
New User
Joined: 26 Aug 2015 Posts: 55 Location: India
|
|
|
|
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 |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
|
|
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
www.redbooks.ibm.com/abstracts/sg248180.html
and google with
ibm redbooks ziip db2 usage |
|
Back to top |
|
|
Virendra Shambharkar
New User
Joined: 26 Aug 2015 Posts: 55 Location: India
|
|
|
|
Thanks a lot . I realized after posting . DB2 itself will redirect eligible processing to zIIP if capacity is available.
Thanks again. |
|
Back to top |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010 Posts: 3051 Location: NYC,USA
|
|
|
|
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 |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008 Posts: 8696 Location: Dubuque, Iowa, USA
|
|
|
|
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 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 |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010 Posts: 3051 Location: NYC,USA
|
|
|
|
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 |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008 Posts: 8696 Location: Dubuque, Iowa, USA
|
|
|
|
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 |
|
|
vasanthz
Global Moderator
Joined: 28 Aug 2007 Posts: 1742 Location: Tirupur, India
|
|
|
|
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 |
|
|
vasanthz
Global Moderator
Joined: 28 Aug 2007 Posts: 1742 Location: Tirupur, India
|
|
|
|
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 |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008 Posts: 8696 Location: Dubuque, Iowa, USA
|
|
|
|
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 |
|
|
|