performance tuning service for

1. performancetuning servicefor IBM Mainframe Antonio Jose Ferreira

2. Reducing operational costs through MIPS management • Information Technology plays an important role in many organizations • IT related operational costs are high and no wonder that businesses ought to strive for their reduction • For most banks, it was estimated that total operational IT costs oscillate at around 15% to 20% of total operational costs • Businesses have taken a strong stance on operational costs reduction and sought solutions to slash IT costs • For instance, Citigroup estimated that removal of redundant systems from their IT portfolio yields a savings potential of over 1 billion USD 

3. Reducing operational costs through MIPS management • So far, organizations have tried a number of approaches to cut IT costs which included head count reduction, outsourcing, consolidating data centers or replacing old software and hardware with its newer counterparties • All these approaches, however, carry an element or risk and might end-up costing a lot especially when complex software environments are involved • There exists one approach which enables IT costs reduction at low-risk for both business and IT • By enabling control of MIPS consumption not only it is possible to achieve significant savings but also to improve performance of IT-systems 

4. Reducing operational costs through MIPS management • MIPS have envolved to become a measurement of processing power and CPU consumption • MIPS related costs are inevitable and high for those organizations which have grown on top of mainframes • A former CIO of a corporation, once said: “MIPS and salaries are my highest unit cost per month” • The amount of MIPS used by the average IT organization is on the rise • IT analysts estimate that most large organizations utilizing mainframes should expect their systems’ MIPS consumption to increase by 15-20 per cent annually 

5. Reducing operational costs through MIPS management • Each additional MIPS typically costs around GBP 2,500 in hardware and software charges • So if a company running a 10,000 MIPS system increases capacity by as little as ten per cent per annum, the incremental cost will be in the region of GBP 2.5 million • Despite the fact that the incurred MIPS related costs are substantial the majority of IT executives (60 %) do not monitor MIPS usage • Therefore, reducing MIPS is indispensable and is one of the major priorities of mainframe users, due mainly to a weak economy and high software costs on the platform 

6. Reducing operational costs through MIPS management • Where does the accrual of MIPS happen? MIPS consumption is directly driven by CPU usage, and CPU usage depends on the applications’ code Inefficient code of the applications is considered to be one major driver for MIPS usage According to a financial services company identified two lines of code that, once changed, saved 160 MIPS Given the market price of MIPS, the two lines of code contributed to substantial reduction of operational IT costs 

7. performance services in a z/OS WORLD Why pay more for inneficient code ? Reducing MIPS growth is a top priority Ideal MIPS usage The worldwide installed base of IBM mainframe exceeded 14 Million MIPS by end of 2008 - up approximately 20 % from year-end 2007 and roughly double of what was five years ago. The need for controlling MIPS attributed costs is indispensable given the high percentage they involve in the overall IT costs.

8. recommending a strategy Code optimization COBOL · SQL · JCL Reduction MIPS & I/O usage BATCH window reduction

9. recommending a strategy Implementing standards-oriented programming performance that allows: Increasing performance that results in MIPS reduction More workload to be processed without adding additional resources Allowing for growth Our approach relies on the mainframe usage data, facts extracted from source code, and is supported by a real MIPS-reduction project which involved tuning of COBOL  SQL  JCL

10. recommending a strategy Efficient COBOL Coding Techniques Specific rules for performance, typically oriented to the code level, may lead to significant improvement in performance, and should be a good starting point. More than 150 rules are available to achieve a better performance. JCL standards and efficient use The bad choices in JCL programming, may have a very negative effect on system performance, specially in cases involving a very large amount of information. Increasing ‘parallelism’ and an intensive use of IBM utilities. SQL performance and tuning The vast majority of the top MIPS consuming operations in the production environment involve the use of DB2. MIPS reduction at low-risk and also low-cost by improving SQL code on the basis of mainframe usage. More than 200 rules and tips to improve DB2 performance.

11. SUCCESSFUL REAL CASE Sample Tuned Charts

12. SUCCESSFUL REAL CASE Sample Tuned Charts

13. Conclusion  Recommendation • THE CHANCE TO ACHIEVE THE BEST PERFORMANCE • Improving individual program performance • Improving the parameters of the data sets employed • Increasing parallelism (through several methods) • Splitting or merging programs ideas for today and tomorrow