Leveraging your FOCUS Assets

1. Leveraging your FOCUS Assets Walter Blood Technical Director FOCUS Division, Information Builders

2. Leveraging Your FOCUS AssetsValue of Your Mainframe • Security superior to any other hardware platform • 99.99% system availability • Processing power for massive volumes of data • “Green” – most efficient energy use for large number of users and massive amounts of data • Disaster recovery • Backed by IBM

3. Identifying Your FOCUS Assets APPLICATIONS OUTPUTS FOCUS DATA ACCESS PERFORMANCE

4. Leveraging APPLICATIONS FOCUS APPLICATIONS Interactive / Batch Number of users Use of FOCUS sink machine User developed reports and utilities Infrequently used applications/reports Heavy lifting tools

5. Leveraging ApplicationsWhere’s the Value In existing APPLICATIONS: • Currently working without problems • Built on rules the company is currently using • Access large amounts of historical data • Require minimal user maintenance How extensive are your assets? • FOCLOG • Site Analyzer

6. FIN FIN FIN FIN FTP TABLE Reports Mainframe Analysis PC Analysis (Local or Information Builders) Leveraging ApplicationsFOCLOG FOCUS Online User FOCUS Batch Job FOCUS Online User FOCUS Batch Job Memory Memory Memory Memory LOG FILE (character flat file) FOCLOG MFD [ M V S O N L Y ]

7. Leveraging APPLICATIONSBatch Applications For batch applications: • Make the application runnable remotely • Provide scheduling capability to optimize cpu usage • Re-package application output for remote access • Spreadsheet – Excel, Lotus • Document – PDF, Postscript • Data – Alpha, WP • Output delivery • Direct shipment via ftp or email • Create repository for output

8. Leveraging APPLICATIONSInteractive Applications For interactive applications: • Separate interactive data collection/manipulation • Provide data collection/manipulation information via file • Replace CRTFORM with FIXFORM from file • Retain original processing logic • Use screen scraping tool like IBM HATS to convert screen input to HTML .

9. Leveraging APPLICATIONSAll Applications For all applications: • Isolate parts of application that can stand alone • Make those pieces available as services • Look for opportunities to deliver output to WebFOCUS .

10. Identifying Data Access FOCUS DATA ACCESS FOCUS/XFOCUS Relational – DB2, Oracle, Teradata Non-relational – IMS, IDMS, ADABAS VSAM, sequential Legacy databases

11. Leveraging Data AccessWhere’s the Value FOCUS access to mainframe data • FOCUS provides access to critical data • Very large volumes of data • High security requirements • Mainframe only databases • Moving the data is not really an option • Too expensive – time and money • Application not broken, why fix?

12. Leveraging Data AccessData Access FOCUS access to mainframe data • To reduce mainframe runtime costs • Use the most efficient FOCUS version • Use FOCUS for data access only and move formatting to a less-expensive platform with WebFOCUS • Fully optimize relational queries • Generate, store and make available reports that are run repetitively on a daily basis with WebFOCUS Reportcaster and Report Library

13. Leveraging Data AccessFOCUS 7.6 CPU Usage Reduction CPU Benchmark% of 7.6 Improvement Tests Large MODIFY Load Large MODIFY UPDATE REBUILD Large TABLE SUM Large TABLE WHERE JOIN TABLE MATCH HOLD OUTPUT MAINTAIN • 7.3.6 • 22% • 30% • 39% • 7% • 8% • 18% • 8% • 44% • 38% 7.2.11 16% 26% 53% 16% 7% 10% 37% 37% 29% 7.1.1 11% 23% 45% 16% 9% 13% 19% 47% 30% See White Paper for performance details

14. Leveraging Data AccessIBM zIIP • No IBM charges for eligible workload CPU utilization on zIIP • zIIP does not count toward overall MIPS rating of the machine • May avoid/delay Central Processor (CP) or machine upgrade • Improves resource optimization by reducing latent workload demand which the CP can now absorb • May stimulate some visible performance improvement IBM's zIIP chip reduces mainframe's overall Total Cost of Ownership “zIIP”: System zIntegrated Information Processor

15. Leveraging Data AccessData Access FOCUS access to mainframe data • Eliminate duplicated mainframe workload • Generate, store and make available subsets of data that handle 80% of your requests. • Control duplicate data • Database fields – Site Analyzer • Hold and intermediate files

16. Leveraging Outputs FOCUS OUTPUTS Screen based applications Paper based Intermediate outputs

17. Leveraging OutputsWhere’s the Value… Leveraging FOCUS output • Current output – portable or not portable? • Data target – ascii vs ebcdic? • Accessibility – paper, screen, mobile device?

18. Leveraging OutputsOutputs Leveraging FOCUS output • Use existing procedures with possible updates • For portability: • PDF, Postscript, Excel, Lotus • For data transport • ALPHA, XML • DFIX with delimiter • EXTRACT – Structured HOLD files

19. Plain HOLD File A B C D A E B C D Leveraging ApplicationsStructured HOLD FiIes Retains knowledge of one-to-many relationships of original file Structured data easily downloads off mainframe to WebFOCUS *More extensive syntax/options documented FOCUS Database TABLE FILE PRINT A B C D IF C EQ 5 ON TABLE HOLD [ FORMAT EXTRACT ] * END A Structured HOLD File B C=5 C HOLD EXTRACT options ALPHA, FOCUS, binary D

20. Leveraging Performance FOCUS PERFORMANCE User volume Data volume Application requirements vs costs Security issues Allowable downtime

21. Leveraging PerformanceConsiderations Retain the cost-effective performance Analyse existing mainframe applications for functionality involving data best retained on mainframe for performance: • Legacy database access especially those with JOINs • Data access that can be re-used by many users • Large volumes of historical data • Security sensitive data Move/rewrite other parts of application Balance cost of move vs cost of Mainframe Use

22. Leveraging Your FOCUS AssetsQuestions? Any Questions?