IBM Oracle ICC Power System with i for JD Edwards

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