IBM STG Technical Conference Information Builders Web FOCUS

IBM STG Technical Conference Information Builders Web. FOCUS and i. Way Products Scalability and Performance Test on z 10 Server April – May 2009 Mark Nesson (Information Builders) At IBM Washington Systems Center 1 Advanced Technical Support (ATS) © 2007 IBM Corporation

IBM STG Technical Conference Information Builders Key Facts § Top-tier privately-held software vendor § Established in 1975 (34 years of expertise) § Dual competencies: – Integration – adapters, ETL § § 2 – Enterprise Business Intelligence 1, 300 customer focused employees globally 12, 000 customer sites worldwide Significant partnerships Recognized market leader Advanced Technical Support (ATS) © 2007 IBM Corporation

IBM STG Technical Conference Web. FOCUS 7 Solutions § Enterprise Standard For Reporting and Business Intelligence DEVELOPMENT INTEGRATION ADMINISTRATION § Management Alerts, Scorecards and KPI Dashboards SECURITY § Financial and Compliance Reporting § Outward Facing Self-Service Information Systems METADATA § Operational Reporting § Analytic Dashboards, GIS, and Advanced Visualization INTELLIGENCE Self Service SOLUTIONS USERS Executive 3 Geographic Financial Ad Hoc/ OLAP Dashboard/ Scorecard Power User Advanced Technical Support (ATS) Analyst Electronic Publishing Web Services Business User Excel, Power. Point, PDF, HTML, XML Customer/ Partner © 2007 IBM Corporation

IBM STG Technical Conference Web. FOCUS 7 Optimized access to System z data System i System z Web Server. Web. Sphere Java App Server. Web. FOCUS web application Web. FOCUS reporting server System p DB 2 System z Oracle 4 Advanced Technical Support (ATS) SAP Other People. Soft Systems System x © 2007 IBM Corporation

IBM STG Technical Conference Information Builders products used in benchmark § Web. FOCUS - a fully integrated enterprise business intelligence suite. It costeffectively delivers information at the operational, tactical, and executive level, providing the integration, scalability, and self-service usability needed for informed decision-making and reporting standardization throughout the extended enterprise. § i. Way Software - the world's leading provider of adapters – over 320 in all – supplies a universal adaptive framework that incrementally facilitates serviceoriented architectures and enables organizations to accelerate business integration with a low cost of entry and full project reusability. – i. Way Service Manager, is a unique and powerful Enterprise Service Bus (ESB) that invoked as Web services to provide event-driven integration and B 2 B interaction management. 5 Advanced Technical Support (ATS) © 2007 IBM Corporation

IBM STG Technical Conference Benchmark Objectives § Information Builders and IBM have created a partnership to test the industry leading BI product, Web. FOCUS, on the proven strengths of System z hardware running the Linux open source OS with UDB, and z/OS with DB 2 and CICS. § The benchmark objective is to evaluate the scalability and performance of Web. FOCUS and i. Way Service Manager in all operating systems environment on IBM z Server and the benefit of using various specialty engines on IBM z server. § All test configurations accurately and faithfully replicated prior benchmarks run by Information Builders to test Web. FOCUS on other UNIX and Windows platforms. § Test results therefore represent the true performance of Web. FOCUS workload on that hardware vendor machine. § Testing was done at IBM Gaithersburg (Washington Systems Center) in April May of 2009 by a combined team from IBM and Information Builders. 6 Advanced Technical Support (ATS) © 2007 IBM Corporation

IBM STG Technical Conference UDB and DB 2 database size § One Linux system running under z/VM, and one z/OS system were used in the various benchmark configurations to host the test databases. § These two databases were loaded with the same data to keep the database workload equivalent. – Multiple tables defined to each database Row counts ranging from 1 million to 7 million Row sizes ranging from 153 to 1065 bytes 7 Advanced Technical Support (ATS) © 2007 IBM Corporation

IBM STG Technical Conference Benchmark Test Workload used – Workload-Small: Query to retrieve 60 rows of data – Workload-Large: Query to retrieve 3000 rows of data – Workload-Complex: CPU intensive query, involves 4 table join retrieve 5631 rows – Queries for each workload listed in Appendix A. 8 Advanced Technical Support (ATS) © 2007 IBM Corporation

IBM STG Technical Conference How Information Builders tests were measured § For each given test configuration, Information Builders used the same parameter settings, i. e. interval time, keep alive time, to run small, large and complex workload by varying the concurrent active user numbers, then measure the end to end user response time. 9 Advanced Technical Support (ATS) © 2007 IBM Corporation

IBM STG Technical Conference Benchmark on IBM z Server § IBM z Server z 10 § Capacity used in benchmark was calculated relative to a 2094 -701 z 10 server which is assumed at 920 MIPS in the computer industry. – 2094 -702 (2 way): 1, 713 MIPS – 2094 -704 (4 way): 3, 227 MIPS – 2094 -708 (8 way): 5, 787 MIPS 10 Advanced Technical Support (ATS) © 2007 IBM Corporation

IBM STG Technical Conference Test Environments Three Main Configurations § All Linux configuration – 3 Linux guests. – One runs DB 2 UDB, one runs Web. Sphere Application Server, one runs IBI Reporting Server and i. Way Service Manager § Hybrid z/OS and Linux configuration – IBI Reporting Server and i. Way Service Manager are running under Linux LPAR – DB 2 database server running under z/OS LPAR – CICS running under z/OS LPAR § Pure z/OS configuration – IBI Reporting Server, Web. Sphere Application Server and i. Way service Manager under one z/OS LPAR – DB 2 database server running under a second z/OS LPAR – CICS running under a second z/OS LPAR 11 Advanced Technical Support (ATS) © 2007 IBM Corporation

IBM STG Technical Conference 12 Advanced Technical Support (ATS) © 2007 IBM Corporation

IBM STG Technical Conference Test Environment – 1 (Linux) Scenarios § Scenario 1: – IBILIN 2: 2/4/8 CP, 8 GB, Web. FOCUS 7. 6 Reporting Server, DB 2 Connect – IBILIN 3: 4 CP, 8 GB, UDB 9. 5 FP 3 a § Scenario 2: – IBILIN 1: 2 CP, 3 GB, WAS 7. 0. 0. 1, Web. FOCUS Client 7. 6 – IBILIN 2: 2/4/8 CP, 2 GB, Web. FOCUS 7. 6 Reporting Server, DB 2 Connect – IBILIN 3: 4 CP, 8 GB, UDB 9. 5 FP 3 a § Scenario 3: – IBILIN 2: 2/4/8 CP, 8 GB, i. Way Service Manager, DB 2 JDBC Type-4 – IBILIN 3: 4 CP, 8 GB, UDB 9. 5 FP 3 a 13 Advanced Technical Support (ATS) © 2007 IBM Corporation

IBM STG Technical Conference Test Env. – 1 (Linux), Scenario – 1 ( Web. FOCUS Reporting Server, DB 2 Connect, Workload-Small, Keep Alive for 3 minutes) 2 CP 4 CP 8 CP Users Total Time (sec) No. of Reque -sts Avg. Processing Time (sec) Total Time (sec) No. of Reque -sts Avg. Total Proces- Time sing (sec) Time (sec) No. of Avg. Reque- Proces sts -sing Time (sec) 50 170 22717 0. 303 170 47471 0. 125 170 71506 0. 072 100 170 22842 0. 63 170 43752 0. 273 170 73294 0. 127 200 175 22148 1. 383 172 42654 0. 587 170 77170 0. 21 500 181 26006 2. 605 175 42567 1. 522 ------- 14 Advanced Technical Support (ATS) © 2007 IBM Corporation

IBM STG Technical Conference Test Env. – 1 (Linux), Scenario – 1 ( Web. FOCUS Reporting Server, DB 2 Connect, Workload-Large, Keep Alive for 3 minutes) 2 CP 4 CP 8 CP Users Total Time (sec) No. of Avg. Reque- Proces sts -sing Time (sec) Total Time (sec) No. of Requests Avg. Proce s-sing Time (sec) Total Time (sec) No. of Reque -sts Avg. Proces -sing Time (sec) 50 171 3813 1. 614 171 7527 0. 868 171 14262 0. 461 100 174 3854 4. 139 171 7525 1. 901 171 14299 0. 919 200 178 4009 8. 029 181 7627 3. 931 175 17339 1. 658 500 253 5953 11. 774 177 14468 5. 111 -------- 15 Advanced Technical Support (ATS) © 2007 IBM Corporation

IBM STG Technical Conference Test Env. – 1 (Linux), Scenario – 1 ( Web. FOCUS Reporting Server, DB 2 Connect, Workload-Complex, Keep Alive for 3 minutes) 2 CP 4 CP 8 CP Users Total Time (sec) No. of Avg. Reque- Proces sts -sing Time (sec) Total Time (sec) No. of Requests Avg. Total Proces Time -sing (sec) Time (sec) No. of Reque -sts Avg. Proces -sing Time (sec) 50 177 1068 7. 386 173 2064 3. 954 171 3981 1. 876 100 183 1109 14. 809 176 2095 7. 791 174 4042 3. 837 200 202 1214 28. 99 184 2186 15. 228 176 3786 7. 622 16 Advanced Technical Support (ATS) © 2007 IBM Corporation

IBM STG Technical Conference Test Env. – 1 (Linux), Scenario – 2 ( WAS, Web. FOCUS Reporting Server, DB 2 Connect, Workload-Small, Keep Alive for 3 minutes) 2 CP 4 CP 8 CP Users Total Time (sec) No. of Avg. Reque- Proces sts -sing Time (sec) Total Time (sec) No. of Requests Avg. Total Proces Time -sing (sec) Time (sec) No. of Reque -sts Avg. Proces -sing Time (sec) 50 170 21429 0. 39 170 39539 0. 211 170 59016 0. 141 100 170 21749 0. 769 170 38407 0. 436 170 61740 0. 27 200 176 21648 1. 558 172 37441 0. 88 170 61421 0. 537 500 192 20030 3. 984 188 36447 2. 194 171 61404 1. 282 17 Advanced Technical Support (ATS) © 2007 IBM Corporation

IBM STG Technical Conference Test Env. – 1 (Linux), Scenario – 2 ( WAS, Web. FOCUS Reporting Server, DB 2 Connect, Workload-Large, Keep Alive for 3 minutes) 2 CP 4 CP 8 CP Users Total Time (sec) No. of Avg. Reque- Proces sts -sing Time (sec) Total Time (sec) No. of Requests Avg. Total Proces Time -sing (sec) Time (sec) No. of Reque -sts Avg. Proces -sing Time (sec) 50 171 4289 1. 959 170 7888 1. 059 172 14185 0. 588 100 173 4088 4. 128 171 7740 2. 173 175 15008 1. 116 200 179 4170 8. 126 360 8506 4. 627 175 15061 2. 19 500 270 4197 20. 88 180 8223 9. 781 177 15001 5. 292 18 Advanced Technical Support (ATS) © 2007 IBM Corporation

IBM STG Technical Conference Test Env. – 1 (Linux), Scenario – 2 ( WAS, Web. FOCUS Reporting Server, DB 2 Connect, Workload. Complex, Keep Alive for 3 minutes) 2 CP 4 CP 8 CP Users Total Time (sec) No. of Avg. Reque- Proces sts -sing Time (sec) Total Time (sec) No. of Requests Avg. Total Proces Time -sing (sec) Time (sec) No. of Reque -sts Avg. Proces -sing Time (sec) 50 175 1187 7. 212 172 2289 3. 454 178 4285 1. 976 100 184 1246 14. 012 176 2337 6. 315 173 4451 3. 783 200 193 1278 27. 74 183 2412 10. 505 180 4592 7. 288 19 Advanced Technical Support (ATS) © 2007 IBM Corporation

IBM STG Technical Conference Test Env. – 1 (Linux), Scenario – 3 ( i. Way SM, JDBC DB 2 on Linux, Workload-Small, Keep Alive for 3 minutes) 2 CP 4 CP 8 CP Users Total Time (sec) No. of Requests Avg. Proces -sing Time (sec) Total Time (sec) No. of Requests Avg. Total Proces Time -sing (sec) Time (sec) No. of Reque -sts Avg. Proces -sing Time (sec) 25 170 23310 0. 18 170 33111 0. 127 170 59584 0. 07 50 170 21949 0. 381 170 34783 0. 24 170 53693 0. 155 100 170 20773 0. 806 170 32082 0. 521 170 51713 0. 322 200 171 18496 1. 783 171 27689 1. 193 170 34669 0. 95 20 Advanced Technical Support (ATS) © 2007 IBM Corporation

IBM STG Technical Conference Test Env. – 1 (Linux), Scenario – 3 ( i. Way SM, JDBC DB 2 on Linux, Workload-Large, Keep Alive for 3 minutes) 2 CP 4 CP 8 CP Users Total Time (sec) No. of Requests Avg. Proces -sing Time (sec) Total Time (sec) No. of Requests Avg. Total Proces Time -sing (sec) Time (sec) No. of Reque -sts Avg. Proces -sing Time (sec) 25 175 445 9. 69 172 700 6. 064 1191 3. 566 50 180 477 18. 08 178 640 13. 533 174 866 9. 837 100 203 516 35. 78 194 697 25. 908 188 644 28. 142 200 248 580 71. 52 225 733 53. 135 220 764 51. 52 21 Advanced Technical Support (ATS) 172 © 2007 IBM Corporation

IBM STG Technical Conference Test Environment – 2 Scenarios § Scenario 1: – IBILIN 2: 2/4/8 CP, 8 GB, Web. FOCUS Reporting Server 7. 6, DB 2 Connect , CLI – (z/OS) IBI 1: 4 CP, 16 GB, z/DB 2: 6 tables – IBILIN 2: 2/4/8 CP, 8 GB, ISM – (z/OS) IBI 1: 4 CP, 16 GB, CICS 22 Advanced Technical Support (ATS) © 2007 IBM Corporation

IBM STG Technical Conference Test Env. – 2 (Linux), Scenario – 1 ( Web. FOCUS Reporting Server, DB 2 Connect System z/DB 2, Workload. Small, Keep Alive for 3 minutes) 2 CP 4 CP 8 CP Users Total Time (sec) No. of Requests Avg. Proces -sing Time (sec) Total Time (sec) No. of Requests Avg. Total Proces Time -sing (sec) Time (sec) No. of Reque -sts Avg. Proces -sing Time (sec) 50 173 24819 0. 276 170 45653 0. 132 170 71673 0. 07 100 173 24795 0. 568 170 42405 0. 294 170 73801 0. 127 200 179 24807 1. 205 176 41318 0. 656 171 72654 0. 197 23 Advanced Technical Support (ATS) © 2007 IBM Corporation

IBM STG Technical Conference Test Env. – 2 (Linux), Scenario – 1 ( Web. FOCUS Reporting Server, DB 2 Connect System z/DB 2, Workload. Small, Keep Alive for 3 minutes) 2 CP 4 CP 8 CP App. Server LPAR 2 CP DB System LPAR 4 CP App. Server LPAR 4 CP DB System LPAR 4 CP App. Server LPAR 8 CP DB System LPAR 4 CP Users %CPs %z. IIPs %CPs 50 189 18. 52 2. 02 355 31. 16 3. 69 641 47. 28 5. 73 100 190 18. 32 2. 03 364 29. 56 3. 5 676 48. 84 5. 95 200 191 18. 12 2. 02 368 28. 92 3. 43 665 49. 04 5. 92 %z. IIPs %CPs and z. IIPs used. 100% is one Engine 24 Advanced Technical Support (ATS) © 2007 IBM Corporation

IBM STG Technical Conference Test Env. – 2 (Linux), Scenario – 1 ( Web. FOCUS Reporting Server, DB 2 Connect System z/DB 2, Workload. Large, Keep Alive for 3 minutes) 2 CP 4 CP 8 CP Users Total Time (sec) No. of Requests Avg. Proces -sing Time (sec) Total Time (sec) No. of Requests Avg. Total Proces Time -sing (sec) Time (sec) No. of Reque -sts Avg. Proces -sing Time (sec) 50 172 3623 2. 061 171 6706 1. 015 170 13489 0. 483 100 174 3671 4. 31 172 6827 2. 145 171 13631 0. 959 200 178 3784 8. 487 173 6926 4. 412 172 13597 1. 995 25 Advanced Technical Support (ATS) © 2007 IBM Corporation

IBM STG Technical Conference Test Env. – 2 (Linux), Scenario – 1 ( Web. FOCUS Reporting Server, DB 2 Connect System z/DB 2, Workload. Large, Keep Alive for 3 minutes) 2 CP 4 CP 8 CP App. Server LPAR 2 CP DB System LPAR 4 CP App. Server LPAR 4 CP DB System LPAR 4 CP App. Server LPAR 8 CP DB System LPAR 4 CP Users %CPs %z. IIPs %CPs 50 190 12. 96 4. 01 376 22. 08 7. 47 735 41. 24 15. 01 100 193 13. 24 4. 08 379 22. 44 7. 62 749 42. 32 15. 23 200 197 13. 44 4. 15 381 22. 76 7. 71 750 42. 48 15. 25 %z. IIPs %CPs and z. IIPs used. 100% is one Engine 26 Advanced Technical Support (ATS) © 2007 IBM Corporation

IBM STG Technical Conference Test Env. – 2 (Linux), Scenario – 1 ( Web. FOCUS Reporting Server, DB 2 Connect System z/DB 2, Workload. Complex, Keep Alive for 3 minutes) 2 CP 4 CP 8 CP Users Total Time (sec) No. of Requests Avg. Proces -sing Time (sec) Total Time (sec) No. of Requests Avg. Total Proces Time -sing (sec) Time (sec) No. of Reque -sts Avg. Proces -sing Time (sec) 50 178 946 8. 774 171 1739 4. 389 171 3493 2. 295 100 186 987 17. 28 177 1812 8. 774 173 3497 4. 659 200 205 1070 33. 282 185 1921 17. 204 174 3291 9. 827 27 Advanced Technical Support (ATS) © 2007 IBM Corporation

IBM STG Technical Conference Test Env. – 2 (Linux), Scenario – 1 ( Web. FOCUS Reporting Server, DB 2 Connect System z/DB 2, Workload. Complex, Keep Alive for 3 minutes) 2 CP 4 CP 8 CP App. Server LPAR 2 CP DB System LPAR 4 CP App. Server LPAR 4 CP DB System LPAR 4 CP App. Server LPAR 8 CP DB System LPAR 4 CP Users %CPs %z. IIPs %CPs %z. IIPs 50 197 66. 6 30. 76 362 121. 36 57. 03 741 241. 56 115. 05 100 154 53. 56 24. 37 381 129. 04 60. 37 745 244. 76 116. 28 200 170 57. 08 26. 22 305 103. 2 706 240. 48 112. 58 %z. IIPs 47. 95 %CPs and z. IIPs used. 100% is one Engine 28 Advanced Technical Support (ATS) © 2007 IBM Corporation

IBM STG Technical Conference Test Env. – 2 (z/Linux), Scenario – 1 ( i. Way SM, TCP CICS, Workload-VSAM, Keep Alive for 3 minutes) 2 CP 4 CP 8 CP Users Total Time (sec) No. of Requests Avg. Proces -sing Time (sec) Total Time (sec) No. of Requests Avg. Total Proce Time s-sing (sec) Time (sec) No. of Requests Avg. Proces -sing Time (sec) 50 170 38561 0. 108 170 40554 0. 102 170 41405 0. 101 100 170 70375 0. 117 170 77427 0. 106 170 79393 0. 103 200 170 104071 0. 157 170 141905 0. 116 170 149609 0. 108 29 Advanced Technical Support (ATS) © 2007 IBM Corporation

IBM STG Technical Conference Test Environment – 3 (z/OS) Scenarios § Scenario 1: – IBI 1: 2/4/8 CP, 32 GB, Web. FOCUS Reporting Server 76, CLI – IBI 2: 4 CP, 16 GB, DB 2, 6 tables – IBI 2 communicates with IBI 1 via Hipersocket § Scenario 2: – IBI 1: 2/4/8 CP, 32 GB, WAS 7. 0. 0. 1, Web. FOCUS Reporting Server 76, WF Client, CLI – IBI 2: 4 CP, 16 GB, DB 2, 6 tables – IBI 2 communicates with IBI 1 via Hipersocket § Scenario 3: – IBI 1: 2/4/8 CP, 32 GB, ISM 6. 0, JDBC Type-4 Driver – IBI 2: 4 CP, 16 GB, DB 2, 6 tables – IBI 2: 4 CP, 16 GB, CICS VSAM 30 Advanced Technical Support (ATS) © 2007 IBM Corporation

IBM STG Technical Conference Test Env. – 3 (z/OS), Scenario – 1 ( Web. FOCUS Reporting Server, DB 2 Remote Sub. Sys Access, Workload -Small, Keep Alive for 3 minutes) 2 CP 4 CP 8 CP Users Total Time (sec) No. of Requests Avg. Proces -sing Time (sec) Total Time (sec) No. of Requests Avg. Total Proces Time -sing (sec) Time (sec) No. of Reque -sts Avg. Proces -sing Time (sec) 50 170 14196 0. 574 170 23874 0. 339 170 28440 0. 285 100 170 14133 1. 067 170 23370 0. 707 171 28265 0. 583 200 170 13616 2. 42 171 22294 1. 475 171 33155 0. 969 31 Advanced Technical Support (ATS) © 2007 IBM Corporation

IBM STG Technical Conference Test Env. – 3 (z/OS), Scenario – 1 ( Web. FOCUS Reporting Server, DB 2 Remote Sub. Sys Access, Workload -Small, Keep Alive for 3 minutes) 2 CP 4 CP 8 CP App. Server LPAR 2 CP DB System LPAR 4 CP App. Server LPAR 4 CP DB System LPAR 4 CP App. Server LPAR 8 CP DB System LPAR 4 CP Users %CPs %z. IIPs %CPs %z. IIPs 50 187. 46 20. 44 3. 68 350. 40 32. 64 6. 84 459. 68 22. 28 4. 62 100 144. 74 16. 08 2. 76 350. 20 32. 88 6. 8 461. 68 22. 24 4. 6 200 187. 84 19. 08 3. 65 347. 92 31. 72 6. 57 560. 80 25. 8 5. 29 %CPs and z. IIPs used. 100% is one Engine 32 Advanced Technical Support (ATS) © 2007 IBM Corporation

IBM STG Technical Conference Test Env. – 3 (z/OS), Scenario – 1 ( Web. FOCUS Reporting Server, DB 2 Remote Sub. Sys Access, Workload -Large, Keep Alive for 3 minutes) 2 CP 4 CP 8 CP Users Total Time (sec) No. of Requests Avg. Proces -sing Time (sec) Total Time (sec) No. of Requests Avg. Total Proces Time -sing (sec) Time (sec) No. of Reque -sts Avg. Proces -sing Time (sec) 50 172 3255 2. 578 171 6159 1. 353 172 11434 0. 722 100 175 3297 5. 06 172 6168 2. 714 171 11594 1. 439 200 180 3460 9. 55 175 6240 5. 348 175 11650 2. 843 33 Advanced Technical Support (ATS) © 2007 IBM Corporation

IBM STG Technical Conference Test Env. – 3 (z/OS), Scenario – 1 ( Web. FOCUS Reporting Server, DB 2 Remote Sub. Sys Access, Workload -Large, Keep Alive for 3 minutes) 2 CP 4 CP 8 CP App. Server LPAR 2 CP DB System LPAR 4 CP App. Server LPAR 4 CP DB System LPAR 4 CP App. Server LPAR 8 CP DB System LPAR 4 CP Users %CPs %z. IIPs %CPs 50 147. 38 12. 44 4. 31 378. 96 28. 24 11. 21 689. 52 40. 08 16. 61 100 194. 76 16. 2 5. 91 380. 56 29. 56 11. 31 698. 64 40. 72 16. 91 200 196. 14 16. 08 5. 89 387. 40 28. 56 11. 47 706. 56 41. 12 17. 00 %z. IIPs %CPs and z. IIPs used. 100% is one Engine 34 Advanced Technical Support (ATS) © 2007 IBM Corporation

IBM STG Technical Conference Test Env. – 3 (z/OS), Scenario – 1 ( Web. FOCUS Reporting Server, DB 2 Remote Sub. Sys Access, Workload -Complex, Keep Alive for 3 minutes) 2 CP 4 CP 8 CP Users Total Time (sec) No. of Requests Avg. Proces -sing Time (sec) Total Time (sec) No. of Requests Avg. Total Proces Time -sing (sec) Time (sec) No. of Reque -sts Avg. Proces -sing Time (sec) 50 177 701 12. 31 172 1363 6. 201 171 2696 3. 129 100 181 660 25. 93 174 1339 12. 648 173 2640 6. 386 200 563 66. 38 182 1118 30. 820 176 2183 15. 413 35 Advanced Technical Support (ATS) © 2007 IBM Corporation

IBM STG Technical Conference Test Env. – 3 (z/OS), Scenario – 1 ( Web. FOCUS Reporting Server, DB 2 Remote Sub. Sys Access, Workload -Complex, Keep Alive for 3 minutes) 2 CP 4 CP 8 CP App. Server LPAR 2 CP DB System LPAR 4 CP App. Server LPAR 4 CP DB System LPAR 4 CP App. Server LPAR 8 CP DB System LPAR 4 CP Users %CPs %z. IIPs %CPs 50 196. 28 49. 72 22. 67 382. 04 92. 84 43. 68 755. 44 182. 68 87. 38 100 153. 66 36. 6 16. 18 387. 64 92. 04 43. 25 765. 6 180. 12 86. 05 200 169. 06 31. 96 13. 84 309. 36 59. 28 27. 13 780. 56 150. 92 71. 43 %z. IIPs %CPs and z. IIPs used. 100% is one Engine 36 Advanced Technical Support (ATS) © 2007 IBM Corporation

IBM STG Technical Conference Test Env. – 3 (z/OS), Scenario – 2 ( WAS, Web. FOCUS Reporting Server, DB 2 Remote Sub. Sys Access, Workload-Small, Keep Alive for 3 minutes) 2 CP 4 CP 8 CP Users Total Time (sec) No. of Requests Avg. Proces -sing Time (sec) Total Time (sec) No. of Requests Avg. Total Proces Time -sing (sec) Time (sec) No. of Reque -sts Avg. Proces -sing Time (sec) 50 170 10859 0. 77 170 17745 0. 469 170 26895 0. 311 100 170 11037 1. 52 171 18330 0. 915 170 27303 0. 605 200 172 11193 2. 975 171 18548 1. 784 171 27262 1. 212 37 Advanced Technical Support (ATS) © 2007 IBM Corporation

IBM STG Technical Conference Test Env. – 3 (z/OS), Scenario – 2 ( WAS, Web. FOCUS Reporting Server, DB 2 Remote Sub. Sys Access, Workload-Small, Keep Alive for 3 minutes) 2 CP 4 CP 8 CP App. Server LPAR 2 CP DB System LPAR 4 CP App. Server LPAR 4 CP DB System LPAR 4 CP App. Server LPAR 8 CP DB System LPAR 4 CP Users %CPs %z. IIPs %CPs %z. IIPs 50 186. 60 17. 52 3. 58 356. 96 28. 04 5. 78 531. 68 23. 36 4. 36 100 187. 16 17. 56 3. 66 358. 60 28. 96 6. 0 531. 36 22. 2 4. 44 200 188. 70 17. 8 3. 7 359. 76 29. 24 6. 06 531. 04 22. 28 4. 42 %CPs and z. IIPs used. 100% is one Engine 38 Advanced Technical Support (ATS) © 2007 IBM Corporation

IBM STG Technical Conference Test Env. – 3 (z/OS), Scenario – 2 ( WAS, Web. FOCUS Reporting Server, DB 2 Remote Sub. Sys Access, Workload-Large, Keep Alive for 3 minutes) 2 CP 4 CP 8 CP Users Total Time (sec) No. of Requests Avg. Proces -sing Time (sec) Total Time (sec) No. of Requests Avg. Total Proces Time -sing (sec) Time (sec) No. of Reque -sts Avg. Proces -sing Time (sec) 50 172 3053 2. 764 171 5871 1. 431 170 10753 0. 777 100 175 3090 5. 515 172 5913 2. 841 171 10936 1. 535 200 180 3238 10. 50 176 6067 5. 53 173 10954 3. 034 39 Advanced Technical Support (ATS) © 2007 IBM Corporation

IBM STG Technical Conference Test Env. – 3 (z/OS), Scenario – 2 ( WAS, Web. FOCUS Reporting Server, DB 2 Remote Sub. Sys Access, Workload-Large, Keep Alive for 3 minutes) 2 CP 4 CP 8 CP App. Server LPAR 2 CP DB System LPAR 4 CP App. Server LPAR 4 CP DB System LPAR 4 CP App. Server LPAR 8 CP DB System LPAR 4 CP Users %CPs %z. IIPs %CPs %z. IIPs 50 191. 94 16. 4 5. 76 379. 84 31. 04 11. 19 695. 28 38. 88 16. 02 100 195. 20 16. 76 5. 88 381. 12 29. 96 11. 32 709. 20 39. 4 16. 27 200 195. 38 16. 84 6. 01 388. 92 30. 88 11. 63 710. 72 39. 56 16. 25 %CPs and z. IIPs used. 100% is one Engine 40 Advanced Technical Support (ATS) © 2007 IBM Corporation

IBM STG Technical Conference Test Env. – 3 (z/OS), Scenario – 2 ( WAS, Web. FOCUS Reporting Server, DB 2 Remote Sub. Sys Access, Workload-Complex, Keep Alive for 3 minutes) 2 CP 4 CP 8 CP Users Total Time (sec) No. of Requests Avg. Proces -sing Time (sec) Total Time (sec) No. of Requests Avg. Total Proces Time -sing (sec) Time (sec) No. of Reque -sts Avg. Proces -sing Time (sec) 50 179 718 12. 101 174 1419 6. 018 172 2875 2. 953 100 192 784 22. 94 180 1475 11. 72 175 2919 5. 82 200 216 890 42. 47 193 1587 22. 27 181 3023 11. 292 41 Advanced Technical Support (ATS) © 2007 IBM Corporation

IBM STG Technical Conference Test Env. – 3 (z/OS), Scenario – 2 ( WAS, Web. FOCUS Reporting Server, DB 2 Remote Sub. Sys Access, Workload-Complex, Keep Alive for 3 minutes) 2 CP 4 CP 8 CP App. Server LPAR 2 CP DB System LPAR 4 CP App. Server LPAR 4 CP DB System LPAR 4 CP App. Server LPAR 8 CP DB System LPAR 4 CP Users %CPs %z. IIPs %CPs 50 152. 24 38. 44 17. 36 387. 72 98. 04 46. 16 763. 68 193. 08 92. 54 100 162. 54 41. 68 18. 92 306. 48 75. 96 35. 41 775. 36 196. 08 93. 92 200 181. 24 46. 92 21. 48 325. 80 80. 84 37. 87 612. 64 152. 64 72. 85 %z. IIPs %CPs and z. IIPs used. 100% is one Engine 42 Advanced Technical Support (ATS) © 2007 IBM Corporation

IBM STG Technical Conference Test Env. – 3 (z/OS), Scenario – 3 ( i. Way SM, Jdbc Type 4, Workload-Small, Keep Alive for 3 minutes) 2 CP 4 CP 8 CP Users Total Time (sec) No. of Requests Avg. Proces -sing Time (sec) Total Time (sec) No. of Requests Avg. Total Proces Time -sing (sec) Time (sec) No. of Reque -sts Avg. Proces -sing Time (sec) 25 170 14126 0. 297 170 25945 0. 161 170 28924 0. 144 50 170 13638 0. 611 170 24279 0. 343 170 27339 0. 305 100 170 13146 1. 25 170 23281 0. 715 170 25659 0. 650 43 Advanced Technical Support (ATS) © 2007 IBM Corporation

IBM STG Technical Conference Test Env. – 3 (z/OS), Scenario – 3 ( i. Way SM, Jdbc Type 4, Workload-Small, Keep Alive for 3 minutes) 2 CP 4 CP 8 CP App. Server LPAR 2 CP DB System LPAR 4 CP App. Server LPAR 4 CP DB System LPAR 4 CP App. Server LPAR 8 CP DB System LPAR 4 CP Users %CPs %z. AAP %CPs %z. IIP 25 183. 6 166. 97 10. 68 1. 14 351. 64 320. 35 27. 88 3. 8 410. 8 349. 55 19. 08 2. 34 50 180. 88 163. 91 10. 64 1. 14 343. 72 310. 21 27. 68 3. 58 402. 56 335. 79 18. 52 2. 27 100 180. 38 162. 55 10. 28 1. 1 343. 16 305. 3 26. 32 3. 45 406. 96 329. 33 18. 24 2. 24 %CPs, z. IIPs, and z. AAPs used. 100% is one Engine 44 Advanced Technical Support (ATS) © 2007 IBM Corporation

IBM STG Technical Conference Test Env. – 3 (z/OS), Scenario – 3 ( i. Way SM, Jdbc Type 4, Workload-Large, Keep Alive for 3 minutes) 2 CP 4 CP 8 CP Users Total Time (sec) No. of Requests Avg. Proces -sing Time (sec) Total Time (sec) No. of Requests Avg. Total Proces Time -sing (sec) Time (sec) No. of Reque -sts Avg. Proces -sing Time (sec) 25 176 401 10. 816 172 747 5. 687 1009 4. 199 50 180 344 25. 266 180 611 14. 318 175 841 10. 196 100 208 303 64. 80 190 496 36. 63 622 28. 217 45 Advanced Technical Support (ATS) 171 183 © 2007 IBM Corporation

IBM STG Technical Conference Test Env. – 3 (z/OS), Scenario – 3 ( i. Way SM, Jdbc Type 4, Workload-Large, Keep Alive for 3 minutes) 2 CP 4 CP App. Server LPAR 2 CP Users %CPs %z. AAP DB System LPAR 4 CP %CPs %z. IIP 8 CP App. Server LPAR 4 CP %CPs %z. AAP DB System LPAR 4 CP %CPs %z. IIP App. Server LPAR 8 CP %CPs DB System LPAR 4 CP %z. AAP %CPs %z. IIP 25 192. 38 183. 06 4. 2 0. 56 367. 84 350. 8 8. 2 1. 39 531. 84 494. 96 6. 04 1. 37 50 194. 36 184. 11 3. 8 0. 5 374. 44 347. 5 7. 84 1. 15 531. 76 490. 09 5. 68 1. 18 100 171. 78 161. 11 3. 52 0. 34 302. 04 281. 25 6. 32 0. 71 389. 76 346. 75 4. 52 0. 69 %CPs, z. IIPs, and z. AAPs used. 100% is one Engine 46 Advanced Technical Support (ATS) © 2007 IBM Corporation

IBM STG Technical Conference Test Env. – 3 (z/OS), Scenario – 3 ( i. Way SM, CICS VSAM, Keep Alive for 3 minutes) 2 CP 4 CP 8 CP Users Total Time (sec) No. of Requests Avg. Proces -sing Time (sec) Total Time (sec) No. of Requests Avg. Total Proces Time -sing (sec) Time (sec) No. of Reque -sts Avg. Proces -sing Time (sec) 25 170 34975 0. 119 170 43560 0. 095 170 44314 0. 093 50 170 42655 0. 195 170 66434 0. 124 170 67137 0. 123 100 170 44835 0. 369 170 73532 0. 226 170 75376 0. 22 47 Advanced Technical Support (ATS) © 2007 IBM Corporation

IBM STG Technical Conference Test Env. – 3 (z/OS), Scenario – 3 ( i. Way SM, CICS VSAM, Keep Alive for 3 minutes) 2 CP Users 50 100 200 4 CP 8 CP App. Server LPAR 2 CP CICS LPAR 4 CP App. Server LPAR 4 CP CICS LPAR 4 CP App. Server LPAR 8 CP CICS LPAR 4 CP %CPs %z. AAP %CPs 140. 2 121. 17 16. 68 187. 24 154. 23 19. 60 206. 72 145. 88 19. 40 162. 52 141. 14 19. 48 266. 52 223. 08 27. 52 305. 68 225. 32 26. 00 185. 4 159. 46 21. 60 246. 28 199. 42 23. 88 380. 08 274. 12 30. 24 %CPs, z. IIPs, and z. AAPs used. 100% is one Engine 48 Advanced Technical Support (ATS) © 2007 IBM Corporation

IBM STG Technical Conference WSC Benchmark Team § John Goodyear § Robert Kaas § King Au § Kenneth Hain § Fred Bader § Glenn Materia Information Builders Benchmark Team 49 Advanced Technical Support (ATS) WSC Benchmark Team § Mark Nesson § Amit Chowdhury © 2007 IBM Corporation

IBM STG Technical Conference IBM and Information Builders System z Customers 50 Advanced Technical Support (ATS) © 2007 IBM Corporation

IBM STG Technical Conference Questions ? 51 Advanced Technical Support (ATS) © 2007 IBM Corporation

IBM STG Technical Conference Appendix A Workload-Small Query SELECT T 1. "F 3 SSN", T 1. "F 3 ALPHA 10", T 1. "F 3 INTEGER 5", T 1. "F 3 FLOAT 9 X 8", T 1. "F 3 DBL 15 X 2" FROM TST 2 MLN T 1 WHERE (T 1. "F 3 SSN" <= '000000061') FOR FETCH ONLY; 52 Advanced Technical Support (ATS) © 2007 IBM Corporation

IBM STG Technical Conference Appendix A Workload-Large Query SELECT T 1. "F 3 SSN", T 1. "F 3 ALPHA 10", T 1. "F 3 INTEGER 5", T 1. "F 3 FLOAT 9 X 8", T 1. "F 3 DBL 15 X 2" FROM TST 2 MLN T 1 WHERE (T 1. "F 3 SSN" <= '000003000') FOR FETCH ONLY; 53 Advanced Technical Support (ATS) © 2007 IBM Corporation

IBM STG Technical Conference Appendix A Workload-Complex Query SELECT T 1. "B_BKNG_NBR", T 1. "B_VOYAGE", T 1. "B_STATUS", T 1. "B_TOURS_INDICATOR", T 4. "B_P_USE", T 4. "B_P_CONC_CD", T 4. "EFFECTIVE_DATE", T 4. "EXPIRATION_DATE", MAX(T 1. "SHIP_KEY_CODE"), MAX(T 3. "SHIP_NAME"), MAX(T 1. "B_SAIL_DATE"), MAX(T 1. "SAIL_YEAR"), SUM(T 4. "PASSENGER_COUNT") FROM ( ( ( BKNG_MSTR T 1 INNER JOIN VOYAGE_MSTR T 2 ON T 2. "VYD_VOYAGE" = T 1. "B_VOYAGE" ) LEFT OUTER JOIN SHIP_NME_MSTR T 3 ON T 3. "SHIP_KEY_CODE" = T 1. "SHIP_KEY_CODE" ) INNER JOIN BKNG_PSNGR_AUDIT T 4 ON T 4. "B_BKNG_NBR" = T 1. "B_BKNG_NBR" AND T 4. "B_VOYAGE" = T 1. "B_VOYAGE" ) WHERE (T 1. "TRADE_CODE" = 'A') AND (T 2. "VYD_VOYAGE_STATUS" IN('A', 'H')) AND (T 2. "RPT_YEAR" ='2006') AND (T 4. "EXPIRATION_DATE" > '2007 -02 -17') AND (T 4. "EFFECTIVE_DATE" <= '2006 -10 -17') AND (T 4. "B_P_PASSENGER_STATUS" = 'C') AND (((T 1. "B_GROUP_TYPE" ='H') AND (T 4. "B_P_PASSENGER_ID" = '2')) OR ((T 1. "B_GROUP_TYPE" <> 'H') OR T 1. "B_GROUP_TYPE" IS NULL)) GROUP BY T 1. "B_BKNG_NBR", T 1. "B_VOYAGE", T 1. "B_STATUS", T 1. "B_TOURS_INDICATOR", T 4. "B_P_USE", T 4. "B_P_CONC_CD", T 4. "EFFECTIVE_DATE", T 4. "EXPIRATION_DATE" ORDER BY T 1. "B_BKNG_NBR", T 1. "B_VOYAGE", T 1. "B_STATUS", T 1. "B_TOURS_INDICATOR", T 4. "B_P_USE", T 4. "B_P_CONC_CD", T 4. "EFFECTIVE_DATE", T 4. "EXPIRATION_DATE" FOR FETCH ONLY; 54 Advanced Technical Support (ATS) © 2007 IBM Corporation