Audio by Conference Call US Toll Free:1-888-426-6840 US Toll: 1-215-861-6239 Participant Passcode: 3249008 Power System with i for JD Edwards EnterpriseOne - Update Oracle Alliance TeamCompetency Center IBM Oracle International International Competency Center Patrick Moore Solution Sales Specialist [email protected] © 2012 IBM Corporation Diane Webster IBM ICC JD Edwards Specialist IBM Oracle ICC Agenda Solution Edition Update Performance and Tuning Update ► Single Core Tuning ► Express Installation Customization ► Power 740 Performance Tests ► Solid State Drive Tests ► Updated Tuning Guides ► Batch Priority Adjustments Planned Testing Sizing Update Resources Questions 2 © 2012 IBM Corporation IBM Oracle ICC Solution Edition Offering Example One — 50 Users Example Two — 150 Users Example Three — 500 Users Power 720 Power 720 Power 740 1 POWER7 socket, 4 core 3.00 GHz 1 POWER7 socket, 6 core, 3.00 GHz 1 POWER7 socket, 6 core, 3.72 GHz 16 GB memory 32 GB memory 64 GB memory 1.1 TB of integrated storage (8 x 140 GB disk arms (15K rpm)) 1.7TB of integrated storage (12 x 140 GB disk arms (15K rpm)) 4.4TB of integrated storage (32 x 140 GB disk arms (15K rpm)) Tape drive Tape drive External fibre card for tape attach IBM i 7.1 (1-core, 50 users) IBM i 7.1 (2-core, 150 users) IBM i 7.1 (4-core, unlimited users) PowerVM PowerVM PowerVM *These are examples only. Actual configuration can be customized to meet customer needs. Deployment Server not included and can be added or sold separately 3 © 2012 IBM Corporation IBM Oracle ICC Cost of Acquisition — new 50-user example 4 Solution IBM i Solution Edition for JD Edwards Intel/Microsoft/Three-tier Systems $19,877 $22,744 OS $6,925 $4,832 Windows Std. Svr./Backup DB NC $8,600 MS SQL Server Web NC $5,000 Oracle Application Server Std. Ed. 1 core Total $30,712 $41,176 © 2012 IBM Corporation IBM Oracle ICC Cost of Maintenance — new 50-user example Solution IBM i Solution Edition for JD Edwards Intel/Microsoft/Three-tier Systems 3 yr. warranty! $333 for 24x7 $1,048 per year OS $1,739 per year $989 per year DB NC $2,151 per year NC $1,100 per year 1-year Total $2,072 $5,288 3-year Total $6,216 $15,864 Web 5 © 2012 IBM Corporation IBM Oracle ICC Three-year Cost Analysis — new 50-user example IBM i Solution Edition for JD Edwards Intel/Microsoft/Three-tier Acquisition Cost $30,712 $41,176 Maintenance 3-year cost $6,216 $15,864 $0 4 hrs per month, $250 per month $9,000 Express Install - $0 Traditional Install - $10,000 - $20,000 LPAR Additional boxes? SQL licenses? $36,928 $66,040 - $86,040 Solution DBA 3-year cost Installation Test & Dev. systems Total 44-57% CHEAPER PLUS: Customers* implementing JD Edwards software for the first time may qualify for a Power Systems rebate: Model 720 = $1,200 or Model 740 = $3,000. *US and Canada only. 6 © 2012 IBM Corporation IBM Oracle ICC Single Core Tuning White Paper White Paper WP102059 ► http://www03.ibm.com/support/techdocs/atsmastr.nsf/WebIndex/WP102059 Key Highlights ► In our lab testing, we specifically limited our disk arms to determine if we could create bottle necks with a low number of arms. ► Monitoring memory usage ► Disk arm performance ► Recommendation on concurrent number of ubes based on lab testing of ● UBEs running standalone ● UBEs running concurrently with interactive users ► 7 Discussion of adding a new subsystem to for separating high and low priority UBEs © 2012 IBM Corporation IBM Oracle ICC Express Install Express Install Training ► Express Install Training video: http://www03.ibm.com/support/techdocs/atsmastr.nsf/WebIndex/PRS4738 ► Transitioning from Express Install with WebSphere Express on IBM i to a Virtual Three Tier Environment recorded presentation: http://www03.ibm.com/support/techdocs/atsmastr.nsf/WebIndex/PRS4867 Install Training – PRS4738 ► ► ► 8 Overview of the process Step by Step Instructions to perform Express Install Things to watch for © 2012 IBM Corporation IBM Oracle ICC Express Install ► Training PRS4867 ► Leveraging Express Install to Create a Virtual Three Tier Environment with WebSphere on either Window or IBM I Express Install requires that all components are installed on single server This training shows how a slight modification to the Express Install can help you create a virtual three-tier environment ► ► IBM HTTP Server WebSphere Express App Server EnterpriseOne JDBC HTML App Driver (AS_JS_80_PD) Server Manager Agent Server B (Windows or IBM i) IBM HTTP Server WebSphere Express App Server EnterpriseOne JDBC Driver Database Server Enterprise Server HTML App (AS_JS_80_PD) IBM i Server A Database Enterprise Server Server Server Manager Agent Server Manager Agent IBM i Server A Virtual 3-tier Express Install 9 © 2012 IBM Corporation IBM Oracle ICC Express Install JD Edwards EnterpriseOne Express Install transitioning to WebSphere ND clustering - WP102009 ► http://www03.ibm.com/support/techdocs/atsmastr.nsf/WebIndex/WP102009 ► Express Install requires WebSphere Express Edition ► This paper walks through how to take that environment and deploy EnterpriseOne HTML Server to Network Deployment Edition ► Then it shows how to create a cluster IBM HTTP Server JVM JVM JVM JVM WebSphere ND App WebSphere ND App WebSphere ND App WebSphere ND App Server Server Server Server EnterpriseOne EnterpriseOne EnterpriseOne EnterpriseOne HTML App HTML App JDBC HTML App JDBC HTML App JDBC JDBC (AS_8080_M..) (AS_8080_M..) (AS_8080_M..) Driver Driver(AS_8080_M..) Driver Driver Database Server 10 © 2012 IBM Corporation Enterprise Server IBM Oracle ICC Power 740 Performance Characterization What was tested Power 740 ► ► ► Processors: 12 cores (3.7 GHz) Memory: 192 GB memory Disk: 48 HDDs and 8 SSDs IBM i ► ► ► v7.1 DB2 for IBM i WebSphere ND 7.0.17 EnterpriseOne ► ► Applications 9.02 Tools 8.98.4.5 Day In the Life test kit ► ► 17 interactive applications Mix of short and long running UBEs Tests run Express Install ► Complete installation in under 2 days! Interactive users ► Scaling from 1000 – 4000 users Batch mix of short and long running UBEs ► 2 short, 2 long ► 4 short, 4 long ► 8 short, 8 long Mixed workload ► 4000 interactive users ► 16 batch queues IBM POWER7 performance characterization with JD Edwards EnterpriseOne white paper (WP102069): http://www-03.ibm.com/support/techdocs/atsmastr.nsf/WebIndex/WP102069 11 © 2012 IBM Corporation IBM Oracle ICC Interactive Applications Response times ranged from 0.085 to 0.127 Consistent response times as load and configuration changed Near linear scaling as seen by CPU utilization (10% to 50%) Scaling higher and achieving better response time! Interactive Applications Users Call Obj JVMs 1000 40 2 2000 80 4 3000 120 6 4000 160 8 Response Times 0.14 0.12 0.1 0.08 Power 740 0.06 0.04 0.02 0 1000 2000 3000 4000 Users 12 © 2012 IBM Corporation IBM Oracle ICC Batch Workloads Mixed batch workload of short and long running UBEs ► Short running UBEs have increased job initiation and termination activity and associated resources ► Long running UBEs have heavier CPU utilization for calculations CPU utilization increased from 69% to 85% as batch load increased Batch job throughput of 47 UBEs/minute while maintaining excellent record throughput At high CPU utilization, long running UBE throughput diminished ► This is the desired result as short running UBEs have end-users waiting on response ► System prefers short running UBEs based on setting higher priority for batch queue UBE Throughput UBEs per Minute 50 18000 16000 14000 12000 10000 8000 6000 4000 2000 0 40 30 20 10 0 2+2 4+4 UBEs/min Rec/min 8+8 Short and Long Running UBEs 13 © 2012 IBM Corporation IBM Oracle ICC Mixed Batch and Interactive Workloads 4,000 users with 0.196 second response time and 16 concurrent UBE streams Mixed workload ► 4,000 interactive users for all tests ► Increasing number of batch jobs with very little impact to interactive response times Response times varied little as UBE workload increased ► 0.127 with no UBEs ► 0.186 with 4 concurrent UBE streams ► 0.196 with 16 concurrent UBE streams 100 0.4 80 0.35 0.3 60 0.25 40 0.2 20 0.15 0 0.1 2+2 4+4 Response Time CPU Utilization UBE Throughput Batch Database Logic Web Response Time 8+8 Short and Long Running UBEs 14 © 2012 IBM Corporation IBM Oracle ICC Boosting Performance with Solid State Drives Solid State Performance White Paper ► http://www03.ibm.com/support/techdocs/atsmastr.nsf/WebIndex/WP102061 In this paper we see how solid state improved the performance of a couple of UBEs ► Pre-Payroll (R07200) improved over 50% ► MRP (R3483) improved approximately 10% Discusses approach for identifying areas where solid state drives can best leveraged 15 © 2012 IBM Corporation IBM Oracle ICC Boosting Performance with Solid State Drives ► Identifying subsystems which may be most benefited by solid state drives. All screen shots in this section are taken from System Director Navigator for i and the data was obtained from performance data 16 © 2012 IBM Corporation IBM Oracle ICC Boosting Performance with Solid State Drives 17 ► Identifying jobs which may be most benefited by solid state drives. ► Discuss how to determine which QSQSRVR jobs a UBE uses © 2012 IBM Corporation IBM Oracle ICC Boosting Performance with Solid State Drives 18 ► Using TRCASPBAL and STRASPBAL to move hot data to solid state drives ► Analyzing the performance after running STRASPBAL © 2012 IBM Corporation IBM Oracle ICC Boosting Performance with Solid State Drives ► Discuss one way to determine what data was moved to solid state ► Discuss use of STRASPBAL *MP ► Examine some of the system wide effects of that can occur with solid state drives. ● ● ● ● 19 Increased in Logical I/O per second Increased physical disk I/O Increased CPU utilization due to less time spent waiting for disk I/O Increased page fault rates © 2012 IBM Corporation IBM Oracle ICC Updated Tuning Guides IBM i Power WebSphere Tuning Guide ► ► ► Updated version of WP101777 ● http://www03.ibm.com/support/techdocs/atsmastr.nsf/WebIndex/WP101777 Updated to include WebSphere 7 and to remove WebSphere 6 (which is end of life) New section discussing FRCA (Fast Response Cache Accelerator) ● FRCA creates a cache for static HTML content which is managed by the operating system instead of the HTTP server ● This will be most useful in large environments with heavier HTTP traffic ● In general today’s internet browsers do a pretty good job of caching static content, but there are cases where this may not be case and then more pressure is put on the HTTP server. – Specific browser settings prevent or limit caching – A large number of users who infrequently access the system 20 © 2012 IBM Corporation IBM Oracle ICC Updated Tuning Guides IBM i Power Enterprise Server Tuning Guide ► Updated version of WP101504 ► ● http://www03.ibm.com/support/techdocs/atsmastr.nsf/WebIndex/WP101504 ● Updated to include IBM i 7.1 New sections ● SQL Package ini setting – Re-emphasizing the importance of this setting – Determines whether UBEs create new SQL packages or reuse them – This was found to have a big performance impact in environments with lots of short running UBEs. ● Controlling the subsystem that QSQSRVR jobs run in – By default these jobs always run in *BASE – There are some cases, where you may want more control either the priority of the jobs or the amount of memory that the SQL uses ● Adjusting the priorities of batch jobs 21 © 2012 IBM Corporation IBM Oracle ICC Batch Priority Adjustments Using a priority scheme for batch jobs ► Allow you to run lower priority jobs during the day ► Ensure that specific day time reports have priority over other jobs Lab Testing ► A long running UBE queue was set to run at priority 60 ► A short running UBE queue and a second long running UBE queue remained at the default priority 50 Lab Results 22 ► The number of short running jobs processed per hour increase by 27% ► The priority 50 long running jobs ran about 6% faster © 2012 IBM Corporation IBM Oracle ICC Batch Priority Adjustments Process to do this on the i ► Create new subsystem (CRTSBSD) ● CRTSBSD SBS(QBATCH60) ► Create new class (CRTCLS or CRTDUPOBJ) ► Create a new job queue ● CRTJOBQ QBATCH60 ► Change the run priority in new class ● CHGCLS QBATCH60 RUNPTY(60) ► Add the job queue to the new subsystem ● ADDJOBQE SBSD(QBATCH60) JOBQ(QBATCH60) ► Add a routing entry to the new subsystem which uses the new class ● ADDRTGE SBSD(QBATCH60) SEQNBR(9999) CMPVAL(*ANY) PGM(QCMD) CLS(QGPL/QBATCH60) 23 © 2012 IBM Corporation IBM Oracle ICC Batch Priority Adjustments ► Steps in EnterpriseOne ● Use program P986130 to add new job queue to the environment 24 © 2012 IBM Corporation IBM Oracle ICC Batch Priority Adjustments ► Steps in EnterpriseOne ● Options for sending work to the new job queue – Change the default queue – Create a new version or change the versions to use new job queues in OMW – Use the new job queue in your scheduler – Specify the new job queue in the RUNUBE command – Override the job queue at submission time 25 © 2012 IBM Corporation IBM Oracle ICC Planned Tests EnterpriseOne 9.1 Applications and Tools performance testing JD Edwards EnterpriseOne high-water benchmark on POWER7 JD Edwards World performance testing ► Newest release being tested and results available soon WAS Express / Base HTML server clustering and failover testing with EnterpriseOne ► 26 Less expensive option than WAS ND for clustering and failover © 2012 IBM Corporation IBM Oracle ICC EnterpriseOne Sizing - WLE Web-based sizing tool for JD Edwards EnterpriseOne Accessed from IBM PartnerWorld website Rob Jump can grant access to the tool Collaborative sizing now enabled 27 © 2012 IBM Corporation IBM Oracle ICC Available Resources JDE ROI Tool Access the tool at: http://k.kmaone.com/JdeRoiTool JDE Sizing Access the questionnaire at: http://www.ibm.com/erp/sizing Express Install Express Install Training video: http://www-03.ibm.com/support/techdocs/atsmastr.nsf/WebIndex/PRS4738 Transitioning from Express Install with WebSphere Express on IBM i to a Virtual Three Tier Environment recorded presentation: http://www-03.ibm.com/support/techdocs/atsmastr.nsf/WebIndex/PRS4867 Transition from Express Install with WebSphere Express to WebSphere ND: http://www-03.ibm.com/support/techdocs/atsmastr.nsf/WebIndex/WP102009 IBM i Solution Edition for JD Edwards Solution Edition Data Sheet: http://www-03.ibm.com/support/techdocs/atsmastr.nsf/WebIndex/PRS4143 3-year TCO Analysis: http://www-03.ibm.com/support/techdocs/atsmastr.nsf/WebIndex/WP101732 Video References IBM and Oracle YouTube Channel: http://www.youtube.com/user/IBMandOracle Tuning and Performance 28 WebSphere 6.1 and 7.1 Tuning Guide: http://www-03.ibm.com/support/techdocs/atsmastr.nsf/WebIndex/WP101777 Enterprise Server Tuning Guide for IBM i: http://www-03.ibm.com/support/techdocs/atsmastr.nsf/WebIndex/WP101504 Single core Tuning Guide: http://www-03.ibm.com/support/techdocs/atsmastr.nsf/WebIndex/WP102059 Taking advantage of Solid State Drives: http://www-03.ibm.com/support/techdocs/atsmastr.nsf/WebIndex/WP102061 IBM POWER7 performance characterization with JD Edwards EnterpriseOne: http://www-03.ibm.com/support/techdocs/atsmastr.nsf/WebIndex/WP102069 © 2012 IBM Corporation IBM Oracle ICC Questions Email questions to Pat Moore at [email protected] 29 © 2012 IBM Corporation IBM Oracle ICC
© Copyright 2024