The point is the GCP pathlength is longer with DRDA than local attach. The zIIP eligibility helps with that and might or might not cover this increase. YMMV.
Cheers, Martin Martin Packer zChampion, Systems Investigator & Performance Troubleshooter, IBM +44-7802-245-584 email: martin_pac...@uk.ibm.com Twitter / Facebook IDs: MartinPacker Blog: https://www.ibm.com/developerworks/mydeveloperworks/blogs/MartinPacker Podcast Series (With Marna Walle): https://developer.ibm.com/tv/mpt/ or https://itunes.apple.com/gb/podcast/mainframe-performance-topics/id1127943573?mt=2 Youtube channel: https://www.youtube.com/channel/UCu_65HaYgksbF6Q8SQ4oOvA From: David Crayford <dcrayf...@gmail.com> To: IBM-MAIN@LISTSERV.UA.EDU Date: 24/11/2017 12:45 Subject: Re: SAS - DB2 conversion to Java Sent by: IBM Mainframe Discussion List <IBM-MAIN@LISTSERV.UA.EDU> How so? Does DB2 only offload to zIIP for remote DRDA? On 24/11/2017 8:40 PM, Martin Packer wrote: > One other thing I'd throw in is this: Do not assume that rewriting to java > will save GCP CPU when you go to DB2. > > Cheers, Martin > > Martin Packer > > zChampion, Systems Investigator & Performance Troubleshooter, IBM > > +44-7802-245-584 > > email: martin_pac...@uk.ibm.com > > Twitter / Facebook IDs: MartinPacker > > Blog: > https://www.ibm.com/developerworks/mydeveloperworks/blogs/MartinPacker > > Podcast Series (With Marna Walle): https://developer.ibm.com/tv/mpt/ or > > https://urldefense.proofpoint.com/v2/url?u=https-3A__itunes.apple.com_gb_podcast_mainframe-2Dperformance-2Dtopics_id1127943573-3Fmt-3D2&d=DwICaQ&c=jf_iaSHvJObTbx-siA1ZOg&r=BsPGKdq7-Vl8MW2-WOWZjlZ0NwmcFSpQCLphNznBSDQ&m=kTCU9OmUgdcaOs1-R4b3E-yEci2LxYSjiEb6cjUc11k&s=U6h5XFf1sl29QFvfMFNHhIQEADL856qdwzoL1XGp17U&e= > > > Youtube channel: https://urldefense.proofpoint.com/v2/url?u=https-3A__www.youtube.com_channel_UCu-5F65HaYgksbF6Q8SQ4oOvA&d=DwICaQ&c=jf_iaSHvJObTbx-siA1ZOg&r=BsPGKdq7-Vl8MW2-WOWZjlZ0NwmcFSpQCLphNznBSDQ&m=kTCU9OmUgdcaOs1-R4b3E-yEci2LxYSjiEb6cjUc11k&s=vKgiy2chndaPp5-KMHT-uZgF0QZK9bBB4zGzV4glF4A&e= > > > > From: "Vernooij, Kees (ITOPT1) - KLM" <kees.verno...@klm.com> > To: IBM-MAIN@LISTSERV.UA.EDU > Date: 24/11/2017 12:27 > Subject: Re: SAS - DB2 conversion to Java > Sent by: IBM Mainframe Discussion List <IBM-MAIN@LISTSERV.UA.EDU> > > > > I read it, that the OP wants to eliminate SAS license cost, by eliminating > SAS at all. > > I agree with Jantje: how do you rewrite PROCs MEANS, UNIVARIATE, GPLOT, > GCHART etc. with all their parameters to Java reliantly and still make the > project cost effective. A WPS project has a much greater chance. > > > > Kees. > > > >> -----Original Message----- >> From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On >> Behalf Of David Crayford >> Sent: 24 November, 2017 13:13 >> To: IBM-MAIN@LISTSERV.UA.EDU >> Subject: Re: SAS - DB2 conversion to Java >> On 24/11/2017 7:50 PM, Jantje. wrote: >>> On Thu, 23 Nov 2017 05:30:45 -0600, Munif Sadek >> <munif.sa...@gmail.com> wrote: >>>> Martin/Andrew >>>> SMF/CMF are least of our concern at the moment. We are initially >> inclined for any automated tool that can >>>> A.read SAS PDBs and convert them to DB2 tables and/or flat file. Tool >> must cater take for packed, COMP data elements. >>>> B. Can read SAS code and give us some basic converted Java code >>>> C. Will be good if the tool can convert DB2I calls to JDBC calls >>> I can see another of these 2-year/USD2mio projects coming, that, after >> 5 years and USD 12mio gets washed down the drain... >> Indeed! But Andrew Rowley made the suggestion of picking the low hanging >> fruit, the most CPU intensive SAS programs. A incremental project that >> reduced MSU usage by rewriting high cost SAS programs in Java would save >> money and reduce risk. That's a very good idea. Only recently somebody >> suggested the same but for COBOL programs. If you have zIIP processors >> and they're not maxed out your wasting your money. >>> Sorry if I sound negative, >>> Jantje. >>> ---------------------------------------------------------------------- >>> For IBM-MAIN subscribe / signoff / archive access instructions, >>> send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN >> ---------------------------------------------------------------------- >> For IBM-MAIN subscribe / signoff / archive access instructions, >> send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN > ******************************************************** > > For information, services and offers, please visit our web site: > https://urldefense.proofpoint.com/v2/url?u=http-3A__www.klm.com&d=DwIGaQ&c=jf_iaSHvJObTbx-siA1ZOg&r=BsPGKdq7-Vl8MW2-WOWZjlZ0NwmcFSpQCLphNznBSDQ&m=9bZnZimYLTO_D_wZlyROdm8iF7cx1JTHfe6VAku78Cw&s=aTpu1PmrysFc22uSbAd8v-M-Y-qxH4vcXAlz2HYx4O4&e= > . This e-mail and any attachment may contain confidential and privileged > material intended for the addressee only. If you are not the addressee, > you are notified that no part of the e-mail or any attachment may be > disclosed, copied or distributed, and that any other action related to > this e-mail or attachment is strictly prohibited, and may be unlawful. If > you have received this e-mail by error, please notify the sender > immediately by return e-mail, and delete this message. > > > > Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its > employees shall not be liable for the incorrect or incomplete transmission > of this e-mail or any attachments, nor responsible for any delay in > receipt. > > Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch > Airlines) is registered in Amstelveen, The Netherlands, with registered > number 33014286 > > ******************************************************** > > > > > ---------------------------------------------------------------------- > > For IBM-MAIN subscribe / signoff / archive access instructions, > > send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN > > > > > > Unless stated otherwise above: > IBM United Kingdom Limited - Registered in England and Wales with number > 741598. > Registered office: PO Box 41, North Harbour, Portsmouth, Hampshire PO6 3AU > > ---------------------------------------------------------------------- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN Unless stated otherwise above: IBM United Kingdom Limited - Registered in England and Wales with number 741598. Registered office: PO Box 41, North Harbour, Portsmouth, Hampshire PO6 3AU ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
