Re: non Db2 DFSort and zIIP question [EXTERNAL]
Thanks, Dave! Not quite the answer I wanted but the answer I needed. :-) Rex -Original Message- From: IBM Mainframe Discussion List On Behalf Of Dave Betten Sent: Tuesday, April 5, 2022 4:42 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: non Db2 DFSort and zIIP question [EXTERNAL] Nothing has changed regarding DFSORT's zIIP exploitation. It only exploits zIIP when called by Db2 Utilities. And the new zSORT capability on z15 does not exploit zIIP but instead leverages the accelerator. Dave Betten Senior z/OS Performance Specialist IBM Z Technical Sales -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- The information contained in this message is confidential, protected from disclosure and may be legally privileged. If the reader of this message is not the intended recipient or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any disclosure, distribution, copying, or any action taken or action omitted in reliance on it, is strictly prohibited and may be unlawful. If you have received this communication in error, please notify us immediately by replying to this message and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: non Db2 DFSort and zIIP question [EXTERNAL]
Nothing has changed regarding DFSORT's zIIP exploitation. It only exploits zIIP when called by Db2 Utilities. And the new zSORT capability on z15 does not exploit zIIP but instead leverages the accelerator. Dave Betten Senior z/OS Performance Specialist IBM Z Technical Sales -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: non Db2 DFSort and zIIP question [EXTERNAL]
SMF16 records for DFSORT show how much cpu time was zIIP eligible and how much was actually dispatched on zIIP. You can check your own system to see what relevance it has for your workload. In the past only Db2 Utilities workload was zIIP eligible in DFSORT, but that may have changed recently (I don't know if IBM finally did it). Lots of other non-Db2 zIIP exploitation is out there. On Tue, Apr 5, 2022 at 7:45 AM Pommier, Rex wrote: > Thanks, Paul. That definitely answers my second question. I haven't seen > the Redbook so this clears up whether ZSort uses a zIIP. Kind of makes me > wonder if SyncSort's (OK, "Precisely's") ZPSaver would take advantage of > the new instructions. Best of both worlds on a significantly sub-capacity > machine. Use new instructions that accelerate sorting on a full speed > zIIP. :-) > > Back to my original question since I don't have a z15, does DFSort exploit > zIIP at all? I'm guessing "no" since I've seen nothing current about it. > > Thanks again, > > Rex > > -Original Message- > From: IBM Mainframe Discussion List On Behalf > Of Feller, Paul > Sent: Monday, April 4, 2022 4:09 PM > To: IBM-MAIN@LISTSERV.UA.EDU > Subject: Re: non Db2 DFSort and zIIP question [EXTERNAL] > > Rex, on a z15 there is an "Integrated Accelerator for Z Sort" which has > nothing to do with zIIPs or general CPs. > > From an IBM Redbook - IBM z15 (8561) Technical Guide IBM Integrated > Accelerator for Z SORT Sorting data is a significant part of IBM Z > workloads including batch workloads, database query processing, and utility > processing. The amount of data stored and processed on Z continues to grow > at a high rate driving an ever-increasing sort workload. IBM z15 processor > adds special hardware to significantly accelerate frequently used > functions. The IBM Integrated Accelerator for Z sort has been implemented > on each core and it provides new architected instructions for sorting data > to speed up sorting operations. It supports multiple active sorts in > parallel and it is designed to: > > • Optimize elapsed time and CPU time > • Shorten the batch window (primarily targeting existing batch type > sort workloads > • Improve select database functions, such as reorganization to help > reorganize data more frequently as sorted data is faster to access in > interactive use > > > Paul Feller > GTS Mainframe Technical Support > > -----Original Message- > From: IBM Mainframe Discussion List On Behalf > Of Pommier, Rex > Sent: Monday, April 4, 2022 3:22 PM > To: IBM-MAIN@LISTSERV.UA.EDU > Subject: non Db2 DFSort and zIIP question [EXTERNAL] > > Hello list, > > The subject line summarizes my question. We're running a z14 (so the > SORTL stuff doesn't apply according to the doc I've read) and z/OS 2.4. > Does DFSort support offloading to a zIIP processor for non Db2 sorting? I > know I could purchase db2sort which is Syncsort under the covers for db2 > sorts but I'm wondering about regular batch EXEC PGM=SORT usage of DFSort. > I found a hit from about 8 years ago where at that point they didn't > exploit a zIIP but was wondering if anything has changed. > > On a second subject, if we ever migrate beyond the z14, is the SORTL stuff > available on the z15 and above (presumably) using zIIP or is it merely > doing other acceleration on the general purpose engines? > > TIA, > > Rex > > -- > The information contained in this message is confidential, protected from > disclosure and may be legally privileged. If the reader of this message is > not the intended recipient or an employee or agent responsible for > delivering this message to the intended recipient, you are hereby notified > that any disclosure, distribution, copying, or any action taken or action > omitted in reliance on it, is strictly prohibited and may be unlawful. If > you have received this communication in error, please notify us immediately > by replying to this message and destroy the material in its entirety, > whether in electronic or hard copy format. Thank you. > > > -- > For IBM-MAIN subscribe / signoff / archive access instructions, send email > to lists...@listserv.ua.edu<mailto:lists...@listserv.ua.edu> with the > message: INFO IBM-MAIN > > -- > Please note: This message originated outside your organization. Please > use caution when opening links or attachments. > > > -
Re: non Db2 DFSort and zIIP question [EXTERNAL]
Thanks, Paul. That definitely answers my second question. I haven't seen the Redbook so this clears up whether ZSort uses a zIIP. Kind of makes me wonder if SyncSort's (OK, "Precisely's") ZPSaver would take advantage of the new instructions. Best of both worlds on a significantly sub-capacity machine. Use new instructions that accelerate sorting on a full speed zIIP. :-) Back to my original question since I don't have a z15, does DFSort exploit zIIP at all? I'm guessing "no" since I've seen nothing current about it. Thanks again, Rex -Original Message- From: IBM Mainframe Discussion List On Behalf Of Feller, Paul Sent: Monday, April 4, 2022 4:09 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: non Db2 DFSort and zIIP question [EXTERNAL] Rex, on a z15 there is an "Integrated Accelerator for Z Sort" which has nothing to do with zIIPs or general CPs. From an IBM Redbook - IBM z15 (8561) Technical Guide IBM Integrated Accelerator for Z SORT Sorting data is a significant part of IBM Z workloads including batch workloads, database query processing, and utility processing. The amount of data stored and processed on Z continues to grow at a high rate driving an ever-increasing sort workload. IBM z15 processor adds special hardware to significantly accelerate frequently used functions. The IBM Integrated Accelerator for Z sort has been implemented on each core and it provides new architected instructions for sorting data to speed up sorting operations. It supports multiple active sorts in parallel and it is designed to: • Optimize elapsed time and CPU time • Shorten the batch window (primarily targeting existing batch type sort workloads • Improve select database functions, such as reorganization to help reorganize data more frequently as sorted data is faster to access in interactive use Paul Feller GTS Mainframe Technical Support -Original Message- From: IBM Mainframe Discussion List On Behalf Of Pommier, Rex Sent: Monday, April 4, 2022 3:22 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: non Db2 DFSort and zIIP question [EXTERNAL] Hello list, The subject line summarizes my question. We're running a z14 (so the SORTL stuff doesn't apply according to the doc I've read) and z/OS 2.4. Does DFSort support offloading to a zIIP processor for non Db2 sorting? I know I could purchase db2sort which is Syncsort under the covers for db2 sorts but I'm wondering about regular batch EXEC PGM=SORT usage of DFSort. I found a hit from about 8 years ago where at that point they didn't exploit a zIIP but was wondering if anything has changed. On a second subject, if we ever migrate beyond the z14, is the SORTL stuff available on the z15 and above (presumably) using zIIP or is it merely doing other acceleration on the general purpose engines? TIA, Rex -- The information contained in this message is confidential, protected from disclosure and may be legally privileged. If the reader of this message is not the intended recipient or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any disclosure, distribution, copying, or any action taken or action omitted in reliance on it, is strictly prohibited and may be unlawful. If you have received this communication in error, please notify us immediately by replying to this message and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu<mailto:lists...@listserv.ua.edu> with the message: INFO IBM-MAIN -- Please note: This message originated outside your organization. Please use caution when opening links or attachments. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- The information contained in this message is confidential, protected from disclosure and may be legally privileged. If the reader of this message is not the intended recipient or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any disclosure, distribution, copying, or any action taken or action omitted in reliance on it, is strictly prohibited and may be unlawful. If you have received this communication in error, please notify us immediately by replying to this message and
Re: non Db2 DFSort and zIIP question [EXTERNAL]
Rex, on a z15 there is an "Integrated Accelerator for Z Sort" which has nothing to do with zIIPs or general CPs. From an IBM Redbook - IBM z15 (8561) Technical Guide IBM Integrated Accelerator for Z SORT Sorting data is a significant part of IBM Z workloads including batch workloads, database query processing, and utility processing. The amount of data stored and processed on Z continues to grow at a high rate driving an ever-increasing sort workload. IBM z15 processor adds special hardware to significantly accelerate frequently used functions. The IBM Integrated Accelerator for Z sort has been implemented on each core and it provides new architected instructions for sorting data to speed up sorting operations. It supports multiple active sorts in parallel and it is designed to: • Optimize elapsed time and CPU time • Shorten the batch window (primarily targeting existing batch type sort workloads • Improve select database functions, such as reorganization to help reorganize data more frequently as sorted data is faster to access in interactive use Paul Feller GTS Mainframe Technical Support -Original Message- From: IBM Mainframe Discussion List On Behalf Of Pommier, Rex Sent: Monday, April 4, 2022 3:22 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: non Db2 DFSort and zIIP question [EXTERNAL] Hello list, The subject line summarizes my question. We're running a z14 (so the SORTL stuff doesn't apply according to the doc I've read) and z/OS 2.4. Does DFSort support offloading to a zIIP processor for non Db2 sorting? I know I could purchase db2sort which is Syncsort under the covers for db2 sorts but I'm wondering about regular batch EXEC PGM=SORT usage of DFSort. I found a hit from about 8 years ago where at that point they didn't exploit a zIIP but was wondering if anything has changed. On a second subject, if we ever migrate beyond the z14, is the SORTL stuff available on the z15 and above (presumably) using zIIP or is it merely doing other acceleration on the general purpose engines? TIA, Rex -- The information contained in this message is confidential, protected from disclosure and may be legally privileged. If the reader of this message is not the intended recipient or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any disclosure, distribution, copying, or any action taken or action omitted in reliance on it, is strictly prohibited and may be unlawful. If you have received this communication in error, please notify us immediately by replying to this message and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu<mailto:lists...@listserv.ua.edu> with the message: INFO IBM-MAIN -- Please note: This message originated outside your organization. Please use caution when opening links or attachments. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN