Re: Looking for SRB sample in PL/I or COBOL
Hi Denis, I was thinking about this a bit on the way home the other day. You are obviously frustrated and none of what I suggest will be a silver bullet but there are some things you can do if you have not already. TUNE! Tuning the most heavily CPU intensive portion of those IMS transactions might well pay for itself in a month or two. There are tools like Intune http://www.bmc.com Strobe http://www.compuware.com APA http://www.ibm.com http://www-306.ibm.com/software/awdtools/apa/ Freezeframe http://www.macro4.com and many other profile tools including inspect in OMEGAMON http://www.tivolii.com and CPU PROFILE in TMONMVS http://www.asg.com all of which are available on trials if you don't have any of them installed. GTF trace requires considerable more time to grok but it's included with z/OS for free. Once you find the most expensive program or section of a program optimize it and bring in help if you need it. This might be a case where a product like Data Kinetics tableBASE http://www.DKL.com or a custom developed high performance assembler search routine by http://www.celestini.com/ Art Celestini or one of the other available Wizards For Hire (WFH's) might be the ticket. If nothing else gnaw on the LE performance tips floating in IBM documentation, SHARE papers, and dig into the algorithm that is being used to process the data. Pull out the Knuth's if you must http://www-cs-faculty.stanford.edu/~knuth/taocp.html I have found that simply fetching the appropriate volume from the shelf and placing on the desk beside the terminal often exorcises demons from my programs:-) NEGOTIATE! MANAGE! BEAT! vendors into better pricing! Start a SAM Software Asset Management Effort and get off MIPS based pricing with vendors that matter. Participate in the ISVCOSTS mailing list for starters. You might want to join the ISVCOSTS mailing list and review the archives and pose your question in that forum. ISVCOSTS is a no-vendors-allowed discussion list for open discussion by IBM customers of ISV cost issues. http://www.ibm.com/software/solutions/isvcosts/ NOTE: the updated URL courtesy of IBM's genius web master who keeps moving popular pages without providing forwarding so http://www.can.ibm.com/isvcosts/ doesn't work anymore:-( Don't be afraid again to get some help with tooling or advice from folks who know how to play the game http://www.sherkow.com/ and maybe can help you leverage IBM's various pricing schemes like WLC charging to save some money. If all else fails closet yourself and read What Would Machiavelli Do? http://www.amazon.com/gp/product/0066620104 and get in touch with your inner evil prince before negotiating that next contract. A good SAM plan is probably the best way to improve the TCO of your mainframe for the business. Good Luck! Best Regards, Sam Knutson, GEICO Performance and Availability Management mailto:[EMAIL PROTECTED] (office) 301.986.3574 Now he has departed from this strange world a little ahead of me. That means nothing. People like us, who believe in physics, know that the distinction between past, present, and future is only a stubbornly persistent illusion. Albert Einstein -Original Message- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Denis Gaebler Sent: Wednesday, April 05, 2006 8:37 AM To: IBM-MAIN@BAMA.UA.EDU Subject: Re: Looking for SRB sample in PL/I or COBOL Hi List, thanks for the responses so far. It was just an idea, if there was a possibility to move some CPU intensiv pieces of code out to the upcoming zIIP processors (requires SRB envlave mode). In our shop the main cost driver is CPU. Nevertheless, I assume there are more issues waiting, if calling routines as SRB. In high level languages it would be hardly possible to ensure the SRB restrictions such as not calling SVCs etc. Not to mention the authorization issues for normal programs. If that were possible I would have continued to investigate if SRBs could be used in IMS transactions. Some of our IMS transactions do a lot of scanning of in memory tables, which requires a lot of CPU. Since this pieces of code just do memory work, I thought that were candidates for SRBs, since those code sections do not use any IMS services or SVCs. Thanks for your responses. Denis Gaebler. This email/fax message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution of this email/fax is prohibited. If you are not the intended recipient, please destroy all paper and electronic copies of the original message. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at
Doing Scanning with DB2 - was: Re: Looking for SRB sample in PL/I or COBOL
snip If that were possible I would have continued to investigate if SRBs could be used in IMS transactions. Some of our IMS transactions do a lot of scanning of in memory tables, which requires a lot of CPU. Since this pieces of code just do memory work, I thought that were candidates for SRBs, since those code sections do not use any IMS services or SVCs. snip It seems to me that you could offload some of this tables scanning work mentioned in your post directly to DB2: Why not create global temporary tables, loading them with the contents of concern and doing the scanning with SQL? Arthur -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Looking for SRB sample in PL/I or COBOL
Hi Denis, You cannot directly invoke an SRB from PL/I or COBOL so you would need to call a routine installed into the system previously that would be an authorized service provider to schedule an SRB for your problem state PL/I or COBOL program. Why do you want to invoke an SRB? PL/I and COBOL both can access a lot of z/OS services designed to be called by high level languages and some that are not even if a small assembler glue module is required. If you can explain what you need maybe someone can give you a better answer. Best Regards, Sam Knutson, GEICO Performance and Availability Management mailto:[EMAIL PROTECTED] (office) 301.986.3574 Ohh... it's not always easy to know what to do. H. Bogart -Original Message- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Denis Gaebler Sent: Wednesday, April 05, 2006 7:47 AM To: IBM-MAIN@BAMA.UA.EDU Subject: Looking for SRB sample in PL/I or COBOL Hi List, does anyone have a very basic sample on how to invoke a SRB from PL/I or COBOL language? Any help would be appreciated. Thanks. Denis Gaebler. This email/fax message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution of this email/fax is prohibited. If you are not the intended recipient, please destroy all paper and electronic copies of the original message. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Looking for SRB sample in PL/I or COBOL
The service calls to schedule an SRB rae only available from an assembler routine. In addition, in order to schedule and SRB the caller must be authorized, ie. APF authorized, running in a system key or supervisor state, all attributes rarely assigned to COBOL or PL/I programs. Wayne Driscoll Product Developer JME Software LLC NOTE: All opinions are strictly my own. -Original Message- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Denis Gaebler Sent: Wednesday, April 05, 2006 6:47 AM To: IBM-MAIN@bama.ua.edu Subject: Looking for SRB sample in PL/I or COBOL Hi List, does anyone have a very basic sample on how to invoke a SRB from PL/I or COBOL language? Any help would be appreciated. Thanks. Denis Gaebler. ___ Try the New Netscape Mail Today! Virtually Spam-Free | More Storage | Import Your Contact List http://mail.netscape.com -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Looking for SRB sample in PL/I or COBOL
Hi List, thanks for the responses so far. It was just an idea, if there was a possibility to move some CPU intensiv pieces of code out to the upcoming zIIP processors (requires SRB envlave mode). In our shop the main cost driver is CPU. Nevertheless, I assume there are more issues waiting, if calling routines as SRB. In high level languages it would be hardly possible to ensure the SRB restrictions such as not calling SVCs etc. Not to mention the authorization issues for normal programs. If that were possible I would have continued to investigate if SRBs could be used in IMS transactions. Some of our IMS transactions do a lot of scanning of in memory tables, which requires a lot of CPU. Since this pieces of code just do memory work, I thought that were candidates for SRBs, since those code sections do not use any IMS services or SVCs. Thanks for your responses. Denis Gaebler. -Original Message- From: Binyamin Dissen [EMAIL PROTECTED] To: IBM-MAIN@BAMA.UA.EDU Sent: Wed, 5 Apr 2006 15:23:38 +0300 Subject: Re: Looking for SRB sample in PL/I or COBOL On Wed, 5 Apr 2006 07:47:27 -0400 Denis Gaebler [EMAIL PROTECTED] wrote: :does anyone have a very basic sample on how to invoke a SRB from PL/I :or COBOL language? No. But why would you? What kind of SRB service would be required by a high-level language routine? -- Binyamin Dissen [EMAIL PROTECTED] http://www.dissensoftware.com Director, Dissen Software, Bar Grill - Israel Should you use the mailblocks package and expect a response from me, you should preauthorize the dissensoftware.com domain. I very rarely bother responding to challenge/response systems, especially those from irresponsible companies. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html ___ Try the New Netscape Mail Today! Virtually Spam-Free | More Storage | Import Your Contact List http://mail.netscape.com -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Looking for SRB sample in PL/I or COBOL
-Original Message- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Denis Gaebler Sent: Wednesday, April 05, 2006 7:37 AM To: IBM-MAIN@BAMA.UA.EDU Subject: Re: Looking for SRB sample in PL/I or COBOL Hi List, thanks for the responses so far. It was just an idea, if there was a possibility to move some CPU intensiv pieces of code out to the upcoming zIIP processors (requires SRB envlave mode). In our shop the main cost driver is CPU. Nevertheless, I assume there are more issues waiting, if calling routines as SRB. In high level languages it would be hardly possible to ensure the SRB restrictions such as not calling SVCs etc. Not to mention the authorization issues for normal programs. If that were possible I would have continued to investigate if SRBs could be used in IMS transactions. Some of our IMS transactions do a lot of scanning of in memory tables, which requires a lot of CPU. Since this pieces of code just do memory work, I thought that were candidates for SRBs, since those code sections do not use any IMS services or SVCs. Thanks for your responses. Denis Gaebler. Why not get a zAAP and use Java? Java is not really all that bad to program it. And the compiler is free as is the run time (JVM). Now, without a zAAP, forget it. It is CPU intensive (compared to COBOL or PL/I). The current COBOL can INVOKE a JAVA class. -- John McKown Senior Systems Programmer UICI Insurance Center Information Technology This message (including any attachments) contains confidential information intended for a specific individual and purpose, and its content is protected by law. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this transmission, or taking any action based on it, is strictly prohibited. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Looking for SRB sample in PL/I or COBOL
There are additional requirements for running on zIIP processors than simply running in SRB mode. The SRB will have to be associated with a WLM enclave, and it will need to be marked as zIIP eligible and as of yet, the API's do to this have not been disclosed to the public by IBM. Remember that zIIP processors were designed with DB2 in mind. Wayne Driscoll Product Developer JME Software LLC NOTE: All opinions are strictly my own. -Original Message- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Denis Gaebler Sent: Wednesday, April 05, 2006 7:37 AM To: IBM-MAIN@bama.ua.edu Subject: Re: Looking for SRB sample in PL/I or COBOL Hi List, thanks for the responses so far. It was just an idea, if there was a possibility to move some CPU intensiv pieces of code out to the upcoming zIIP processors (requires SRB envlave mode). In our shop the main cost driver is CPU. Nevertheless, I assume there are more issues waiting, if calling routines as SRB. In high level languages it would be hardly possible to ensure the SRB restrictions such as not calling SVCs etc. Not to mention the authorization issues for normal programs. If that were possible I would have continued to investigate if SRBs could be used in IMS transactions. Some of our IMS transactions do a lot of scanning of in memory tables, which requires a lot of CPU. Since this pieces of code just do memory work, I thought that were candidates for SRBs, since those code sections do not use any IMS services or SVCs. Thanks for your responses. Denis Gaebler. -Original Message- From: Binyamin Dissen [EMAIL PROTECTED] To: IBM-MAIN@BAMA.UA.EDU Sent: Wed, 5 Apr 2006 15:23:38 +0300 Subject: Re: Looking for SRB sample in PL/I or COBOL On Wed, 5 Apr 2006 07:47:27 -0400 Denis Gaebler [EMAIL PROTECTED] wrote: :does anyone have a very basic sample on how to invoke a SRB from PL/I :or COBOL language? No. But why would you? What kind of SRB service would be required by a high-level language routine? -- Binyamin Dissen [EMAIL PROTECTED] http://www.dissensoftware.com Director, Dissen Software, Bar Grill - Israel Should you use the mailblocks package and expect a response from me, you should preauthorize the dissensoftware.com domain. I very rarely bother responding to challenge/response systems, especially those from irresponsible companies. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html ___ Try the New Netscape Mail Today! Virtually Spam-Free | More Storage | Import Your Contact List http://mail.netscape.com -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Looking for SRB sample in PL/I or COBOL
Remember that zIIP processors were designed with DB2 in mind. Wayne Driscoll Product Developer JME Software LLC NOTE: All opinions are strictly my own. Fancy that. So was MVS/XA. :) Todd -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Looking for SRB sample in PL/I or COBOL
M - I was at a tech presentation by IBM a couple of weeks back. Selection for dispatch on a zIIP is likely to be severely more limited than Wayne intimates. From the IBM FAQ; Eligible work that can be directed to the zIIP are portions of those requests made from the application server, to the host, via SQL calls over a DRDA® over TCP/IP connection. This is _very_ specific - work cannot be selected if generated from the same LPAR for example. Work originating from a Linux LPAR on same CEC (using hipersockets) is o.k. Not all eligible work will be redispatched on the zIIP - this will be decided by IBM (marketing ???) - maybe only 40% will be eligible. It appears the customer (or code) will have no means of influencing this. Star schema parallel queries and some (DB2) utility workloads are also mooted as eligible - in these cases including workloads originating on the same environment. Seems this support is less mature. Shane ... On Wed, 2006-04-05 at 08:51 -0500, Wayne Driscoll wrote: John, As you mentioned the zAAP processor was designed to reduce the licensing of cost of System Z software when using applications coded in java. However, a lot of the workload that IBM is pushing the System Z for isn't written in JAVA such as SAP and Peoplesoft applications. However, these n-Tier applications perform the bulk of their work on System Z via DB2 DRDA requests, which run in enclave SRB's via the DDF address space. However, if you are running a lot of this work, you may find that you need to upgrade your CPU to support this work. By adding one (or more) zIIP processors, this work will get done, without an increase in software licensing. I am assuming that IBM will publish (maybe just to those willing to pay) the API's that will allow those writing system level code to get dispatched in a zIIP, but this is just a guess on my part. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
