SAP On IBM Systems
SAP On IBM Systems
SAP On IBM Systems
Agenda
SAP & IBM SAP Components SAP on IBM Systems SAP and availability Example architectures Datawarehouse benchmark SAP and Dynamic Infrastructure
2000 Leading SAP BW benchmark achieved with DB2 1999 DB2 becomes the strategic database for SAP 1998 IBM becomes start up member of the SAP Linux Lab 1996 Foundation of Lotus and Tivoli Centers of Excellence
1993 Foundation of the IBM SAP International Competence Center 1972 IBM becomes Logo and Development Partner of SAP
>30% of SAPs developers are located across the globe in 8 SAP Labs
Canada
Montreal
Hungary
Budapest
Bulgaria
Sofia
USA
Palo Alto Business Innovation Ecosystem
Israel
Raanana Technological Innovation
China
Shanghai
India
Bangalore Talent pool
Common Technologies
J2EE (not .Net and C#) Web Services Open Standards SOAP, UDDI, XML Eclipse based
Enterprise Services Repository Analytics
Partner Composite Applications
Awarded with multiple SAP Awards of Excellence and 13 SAP Pinnacle Awards
Founded in 1993, jointly staffed by IBM and SAP Located at SAP headquarters in Walldorf, Germany Central point of access for IBM and SAP projects Heart and home of the IBM SAP Alliance
IBM Investment in SAP Alliance (Germany): ~40 IBM Solution Architects (Concepts, Sizings, Interoperability) ~65 IBM Code Enablers (Porting, Product Quality, 3rd level support) ~100 IBM Software Developers (Adaptors to SAP application, IBM Middleware Product Development)
Middleware
Information Management
Rational
Linux Windows AIX/Linux i5/OS z/OS
Infrastructure
Servers
9 Common meeting May 5, 2009
Storage
2009 IBM Corporation
10
SAP components
Collaboration
Analytics
New dimensions
mySAP.com
SAP CRM SAP CRM
All-inOne
SD
Sales & Distribution
FI
Financial Accounting
MM PP
Materials Mgmt. Production Planning
CO
Controlling
R/3
Client / Server ABAP/4
HR IS
Industry Solutions
AM
Fixed Assets Mgmt.
R/2 1972
12
QM
PS
Project System
...
1997
WF
Workflow
Human Resources
Acquisition of Top Manage Financial Solutions Ltd and introduction of SAP Business One
Time
2008
1992
1996
1999
2002
2004
2007
Integrated Applications
mySAP PLM
mySAP SRM
mySAP ERP
Financials Human Resources Corporate Services Operations Management
mySAP CRM
SustainabilityNEW
mySAP SCM
High Performing Assets Financial Excellence Responsive Supply Networks
SAP NetWeaver
Application-centric Benefit: Integration Large-scale implementations Limited eco-system Upgrade required Independent components
SAP 2008 / Page 13
Customer-centric Benefit: Value-creating processes Step-by-step implementations Vast array of solution extensions No upgrade, no business disruption Harmonized, end-to-end processes
SAP Business Suite helps companies optimize and execute their business and IT strategies in a world of accelerating change.
Insight
Access to information, anytime, anywhere Connect operations with strategy End-to-end process transparency and visibility Improve visibility of outsourced processes
Flexibility
Non-disruptive innovation Compose and design new processes Step-by-step implementations Network of solution extensions
Efficiency
Built-in industry best practices Cross industry process support Collaboration across company boundaries One platform to manage
SAP NetWeaver
Composite Application Framework
INFORMATION INTEGRATION Bus. Intelligence Knowledge Mgmt Master Data Mgmt PROCESS INTEGRATION Integration Business Broker Process Mgmt APPLICATION PLATFORM JAVA ABAP DB and OS Abstraction
Security
DB2
MultiplatformSupport
Tivoli
Websphere
$400M
SAP All-in-One
$150M
$20M
Source: SAP AG
In te gr at i
on
System z
1000 Installations Best Quality of Service for SAP Absolute highest reliability and security Unmatched availability & scalability
System p
14700 Installations #1 Unix Platform for SAP 1st platform for new SAP innovations WPARS, Decimal Floating Point, etc. #1 in SAP performance
System x
14000 Installations Blades #1 Market Share Most scalable IA platform, certified for 4-core & above
System i
3000 Installations Integrated, simple, flexible systems for SAP Support more endusers & workloads for mid-size sites
System Storage
Unmatched flexibility, performance and affordability for SAP Most complete HA & Disaster Recovery plus Storage Mgmt. Leader in storage virtualization
Require less staff Certified for SAP time to manage with Fast Start, optimized superior uptime for BladeCenter S
18
Windows (*8) Server 2008 on x64 64bit Server 2008 on IA64 64bit
HP-UX 11.31 on PA-RISC 64bit 11.31 on IA64 64bit 11.23 on IA64 64bit
System z 64bit
x86_64 64bit
Power 64bit
IA32 32bit
IA64 64bit
6.1 64bit
+/+ X
+/+ X X X
X
+/+ X X(*9) X
X
+/+
-
+/+ +/+
Q1
+/+ X X X X X X -
+/+ +/+ X X X X X X X X X X X -
+/+ X X X X X X -
+/+(*16)
-/+ X X X X X -
+/+ X X X X X -
+/+ X X X X X X APP -
+/+ APP
+/+ X -
-/HA(*1) DB
+/+ -
X X X X X X -
X X X X APP DB HA x64
SQL Server 2000 (*12) X SQL Server 2005 (*10) X SQL Server 2008 DB2 LUW V8 DB2 LUW V9.1 (*15) DB2 LUW V9.5 (*15) MaxDB 7.6 MaxDB 7.7 (*17) DB2 for i5/OS V5R3, DB2 for i 5.4, 6.1 (*4) DB2 for z/OS V8, V9 (*7)
-
X X
X X
X X X X -
X X X X X APP APP X P
X X X X
X X X X
APP
Available for DB and APP Planned Deprecated (Not recommended for productive use)
Not for DB server. Application server with whole SAP NetWeaver stack only, Database Server only High Available Solution only X64 and x86_64 represent the same hardware
System i
Power 560 Power 570 Power 595
BladeCenter JS21/JS22
System p
BladeCenter JS21/JS22 p550 p520 p570 p595
21
22
Users
HP SD 32 cores
HP SD 64 cores
570/16 16 cores
570/32 32 cores
M8000
HP SD
HP SD
570/16
570/32
The SAP Application Performance Standard (SAPS) is a hardware-independent unit that describes the performance of a system configuration in the SAP environment. It is derived from the Sales and Distribution (SD) Benchmark, where 100 SAPS is defined as 2,000 fully business processed order line items per hour. In technical terms, this throughput is achieved by processing 6,000 dialog steps (screen changes), 2,000 postings per hour in the SD Benchmark, or 2,400 SAP transactions. In the SD Benchmark, fully business processed means the full business process of an order line item: creating the order, creating a delivery note for the order, displaying the order, changing the delivery, posting a goods issue, listing orders, and creating an invoice.
23 Common meeting May 5, 2009 2009 IBM Corporation
SAPS ~ IOPS
An iterative process !!
24 Common meeting May 5, 2009 2009 IBM Corporation
SAP Certification
http://www.sap.com/benchmark
25
POWER6
Advanced POWER Virtualization
POWER5
POWER4
LPARs
For SAP new installs on UNIX platform Power System w/ AIX market share is ~45% Even better than overall share SAP customers rely on the excellent Power platform!
HP Sun Others IBM
26
Test
Application Servers
Server Classes
-Central Backends (ERP, HR, BW) -Functional Backends (CRM, BW) -Transient Systems (Portals, Pricer)
LAN
Presentation Clients
27
POWER Approach
Batch mySAP BI
100
Batch
01:00
03:00
05:00
07:00
09:00
11:00
13:00
15:00
17:00
19:00
21:00
23:00
80
60
Web Services
40
20
00:00
02:00
04:00
06:00
08:00
10:00
12:00
14:00
16:00
18:00
20:00
22:00
24:00
00:00
01:00
02:00
03:00
04:00
05:00
06:00
07:00
08:00
09:00
10:00
11:00
12:00
13:00
14:00
15:00
16:00
17:00
18:00
19:00
20:00
21:00
22:00
23:00
mySAP ERP
Web Services
Many SAP applications are integrated from a business and date perspective but not from a workloads point of view They are managed as separate servers/LPARs Results in low degree of synergy
POWER processor-based systems and manageability features will allow for workload combination while still keeping applications distinct Improved system efficiency Less TCO Less energy
28
24:00
VM reboot CAPP/EAL 2 No No 8
29
Today unique feature on Power systems among virtualized platforms Consumed entitlement of an LPAR over time history data
30
SAP supports as with with Dynamic LPARs (DLPAR), Shared Processor LPARs (SPLAR)
No SAP code modifications required SAP will not formally certify this feature but rely on support of DBvendors for DB-Servers
Support statement from DB2, MaxDB pending, Oracle expected in 2009 Supports SAP zero downtime strategy Integration of Mobile Partitions into SAP Adaptive Concept in plan
31
Example:
Add 5% to an amount of 0,70:
- 1.05 x 0.70 using the conventional data type binary double exactly results in: 0.73499999999999998667732370449812151491641998291015625 - rounding to two currency digits results in 0,73 - Using a decimal calculation will result in 0,74
To compensate for rounding inaccuracy in binary computing requires much programming efforts and lots of cycles during runtime!
32
Security Features
1. 2. Role Based Administration Encrypted Filesystem
Dynamic Tracing
improving serviceability for customers and support
33
AIX 6
SAP specific settings for environment variable are now implecitely in AIX
E.g., minperm% 3, maxperm% 90, maxclient% 90 etc.
New tools for more efficient problem analysis and SAP runtime behaviour have been distributed
dynamic tracing with "ProbeVue" lightweight memory trace
34
and
on
35
IBM POWER6
SAP BI-D Query Performance
100 90 80 70 60 50 40 30 20 10 SAP BW Throughput (2-tier) in Query Navigation Steps in Query Phase
79%
IBM
POWER6 i570 4 cores IBM
POWER6
Power System
Increase !
IBM POWER5+
SAP BI-D Query Performance
Average no. of rows: 77,550,719 Average no. of rows: 67,498,194 (Average throughput total 67,498,194) Query Phase :Navigation steps: 437,760
IBM
POWER5+ i570 4 cores
520
2 cores
36
37
SAP on i* in Numbers
Years of Success SAP on i customers worldwide SAP on i installations worldwide (productive) SAP users (named) on a single System i server SAPS capacity on the 595 64way SAP BW Benchmark Navigations Steps to come
39
Outstanding SAP product availability on IBM Power Systems AIX and Linux on Power
AIX, Linux on POWER Tier 1 SAP platforms
Includes database server support for DB2 LUW, Oracle, MaxDB Also includes AIX as an application server support for DB2 for z/OS
Very large IBM Power Systems SAP performance test investment to continue to reduce solution TCO and improve performance
40
IBM System x Portfolio The Leading Intel / AMD Platform for SAP Business Solutions
Large symmetrical multiprocessing (SMP) Clusters and virtualization
x3950 M2
x3850 M2 x3755
High density
Scalable portfolio
Manageability
43
- IBM System x high end servers use mainframe-inspired enhancements and advanced availability technologies and has an embedded Hypervisor - IBM BladeCenter combined with IBM Virtualization Engine delivers a perfect virtualized SAP environment for scale out solutions
Virtualization Skill & Services
Environmental Responsibility
- IBM has long experience in virtualization technologies, going as far back as the 1960s and the origin of virtualization itself - Deep SAP understanding and many years Experience with Virtualization of SAP Environments on different platforms - More than 2,000 virtualization systems installed worldwide and more than 100 customer references
Management
- IBM has the right tools which manage different virtualization solution for all IBM platforms - Skills in Management of Virtualized Environment ( )
IBM Virtualization Solution
44
- Infrastructure solutions Virtualization on System x and BladeCenter Rapid application2009 deployment , Business resiliency & Common meeting May 5, Infrastructure simplification
x3950 M2 4 processors
x3950 M2 4 processors
Consolidation and Optimize Workload Manageability Build new environments Legacy Application on new Hardware Minimize downtime (Maintenance) Upgrade / Move
Rapid deployment for Test and Development Flexibility High Availability Resiliency Upgrade / Move
45
x86
SCSI
Etn
Virtualization layer sits between hardware and operating systems Separate product and management tools
Part of Windows Server 2008 as server role or Standalone as Hyper-V Server Snapshot & Quick Migration
Part of Major Linux Distributions Open Source, released under the terms GNU GPL Live Migration Simple Management GUI and 3rd party Management Tools Paravirtualization and Full Virtualization see SAP Note 962334
$$
Image Management
Additional Plug-Ins
Additional Plug-Ins
Additional Plug-Ins
Additional Plug-Ins
Additional Plug-Ins
TPMfOSD
Configuration
BOFM
Hardware
IBM and non-IBM hardware
47
48
IBM Systems Solution for SAP NetWeaver BW Accelerator A Scalable Solution Helping Provide Near Real-Time Analytics
For businesses who need timely answers to vital Business questions
Accelerator engine responds to queries: joins and aggregates are done in run time
Query & Response
Indexing
Accelerator engine creates and stores indexes for data in InfoCube tables
Business Data
Super-charged BW query performance 10 100x faster than previous methods Scalable to support the largest SAP BW installations
Resulting in:
Faster access to data and information with near real-time visibility into business operations Improved management decision-making capability Support growing numbers of users with a stable, improved query response Lower Total Cost of Ownership for SAP BW computing environment
Choosing the IBM Systems Solution for BW Accelerator technology ensures that Bayer Business Services has a high-performance, cost-effective solution that is highly scaleable, and one that offers room for future growth.Peter Kossmann, Bayer Business Services
49 Common meeting May 5, 2009 2009 IBM Corporation
Why SAP NetWeaver Enterprise Search? Simple, Intuitive Access to Enterprise Data
Personalized, high quality search results
Leveraging SAPs deep understanding of users and business context Bringing together the SAP and non-SAP world in an intelligent way
Secure search
Leveraging the underlying security model of SAP business applications
50
All systems are already installed and configured Delivered on a single prototyping / development server System x3650 server 2 Intel Xeon quad core CPU, 16 GB RAM HDD: 4 x 300GB + 1x 146GB (2 OS + 2 Data + 1 recovery) Windows Server 2003 EE 32 Bit SAP Discovery system v3
51
#1 SAP #1 SAP SD SD
Date of Certification
9,200
46,170
Windows Server
09/08/2008
5,156
25,850
11/18/2008
5,300
26,550
Windows Server
12/02/2008
4,386
22,000
Windows Server
12/17/2008
5,100
25,530
Windows Server
12/19/2008
52
SAP Certification
http://www.sap.com/benchmark
53
54
What is availability ?
Server or cluster availability Server or cluster availability The server and the OS or the cluster is up and operating The server and the OS or the cluster is up and operating The storage subsystems can be accessed and are available The storage subsystems can be accessed and are available Network Availability Network Availability All Network Components are available and functioning All Network Components are available and functioning Platform availability Platform availability Mail, ERP, Internet and other platforms are up and functioning? Mail, ERP, Internet and other platforms are up and functioning? Data availability Data availability Database accessible Database accessible Application availability Application availability Applications are running Applications are running Applications are processing specified business goals Applications are processing specified business goals User availability User availability The end users can see and use the applications and have access to the data The end users can see and use the applications and have access to the data (considering WAN, gateways, LANs, and all of the above functioning properly) (considering WAN, gateways, LANs, and all of the above functioning properly) Business process availability Business process availability All elements required for aabusiness process to occur (taking ccreditcard payments All elements required for business process to occur (taking redit card payments on aawebsite, etc) are up and running on website, etc) are up and running
56 Common meeting May 5, 2009 2009 IBM Corporation
Harder to measure Harder to measure Harder to measure Harder to guarantee Harder to guarantee Harder to guarantee
Make business applications ready for HA Select the right technology components
IBM and Partners Infrastructure components (network server storage DB) Unplanned downtime (eliminate SPOFs) Planned downtime
57
A typical multi tier infrastructure contains of a chain of server which provides specific functions
58
59
Defining HA Switchover Units for a SAP landscape start with finding SPOFs in your SAP landscape
SCS-Instance including
Enqueue Server for Java Message Server for Java
Central file share /sapmnt/ Application Server Infrastructure service (ADS,DNS) Load Balancer
60
GUI
ICM
Message Server
Database
61
Enqueue Client
Enqueue Client
Message Server
Dialog Work Process
Enqueue Client
Enqueue Service
R/3 Database
Enqueue Client
Enqueue Client
Dispatcher
Enqueue Work Process
r te lus C
Enqueue Table Enqueue Replica
Enqueue Table
Characteristics / Functionality Single Point of Failure Keeps critical Data in Enqueue Table Enqueue Table is held in memory (not persistent due to insufficient performance) Loosing that Enqueue Table forces transaction reset Data in update requests is protected by locks which are persisted to the enqueue backup file Failure detection and takeover only possible by an ClusterSolution Bottleneck Message Server <-> Dispatcher Communication restricts Enqueue throughput and performance
Characteristics / Functionality
class ic
No Single Point of Failure Replicated Enqueue Information available at a standbyserver No loss of Lock-entries in table, no transaction reset For failure detection and takeover a Cluster Solution is still reuired When the failing node comes up, it will become the replication
target for the enqueue service
Removing Bottleneck Direct and parallel Communication passing by the Message Server
62
lus C
er t
63
DB Write DB Write
Transaction Log
Database
Transaction Log
Database
64
Interconnect
RAC
Table A
Mirr or
Presentation SAP Application
Table B Database
DB2 HA/DR internal DB2 UDB process send Log records of log files from the primary database to the standby database log files are replayed and the tables on standby systems are modified accordingly DB2 automatic client reroute feature
Database mirroring works by transferring and applying a stream of database log records from the principal database to the other copy of the database located on the mirror server. SQL clients and applications can only connect and perform work on the principal. Server Roles: Principal, Mirror, Witness (opt.) Server
Real Application Cluster High availability Scalability Application load balacing Seemless connections Very good for SAP workload Application transparency Data access during recovery
65
Disk subsystem
r te lus C
Node 2
66
r te lus
67
Chipkill & Memory ProteXion Technology Redundant network Redundant fibre channel RAID for local disk Hot-swap & Hot-add in all major subsystems BladeCenter
Redundant Cooling Domains at Chassis Level Redundant Connectors / Disks Design at Blade Level Redundant Power Modules at Chassis Level Redundant blowers
Red. HDD e.g. Power Feeds
68
POWER5 significant reduction in scheduled hardware outages while at the same time
enhancing availability
Selected concurrent firmware update I/O error handling extended beyond base PCI adapter ECC has been extended to inter-chip connections for the fabric/processor buses (data, address, control) Partial L2 cache deallocation L3 cache line deletes improved from 2 to 10 for better self-healing capability Concurrent Maintenance
69
70
JSCS Instance
ENQ Server (JAVA) MSG Server (JAVA)
Failover Group
JSCS Instance
ENQ Server (JAVA) MSG Server (JAVA) ICM
Dialog Instance
ASCS Instance
ENQ Server (ABAP) MSG Server (ABAP)
HACMP
ASCS Instance
ENQ Server (ABAP) MSG Server (ABAP) Replicated ENQ Server (JAVA)
ABAP
JAVA
ABAP
JAVA
IGS
Failover Group
IGS
Database
ABAP Schema JAVA Schema HACMP
Database
ABAP Schema JAVA Schema
71
VERITAS Cluster Server, the industry's leading open systems clustering solution, is ideal for reducing planned and unplanned downtime, facilitating server consolidation, and effectively managing a wide range of applications in heterogeneous environments.
SteelEye LifeKeeper
72
SteelEye LifeKeeper products help provide high availability clustering, data replication and disaster recovery solutions to ensure continuous availability of business-critical applications, servers and data.
PowerHA
IBM SW Offering High Availability solutions for IBM i 6.1 and i5/OS V5R4
Logical Replication
iCluster (iCluster SMB)
Best Fit
Geographic Dispersion Data replication/recovery Can be adapted for HA (HASM/XSM) Geographic Mirroring
(HASM/XSM) Geographic Mirroring Metro Mirror Global Mirror (for DR) Global Mirror Metro Mirror
HA Operations (XSM) - Metro Mirror DR Operations (XSM) - Global Mirror* Disaster Recovery
Please note : This is "rule of thumb" guide, each environment should be individually assessed to determine which technology approach is the best fit. 73 Common meeting May 5, 2009 2009 IBM Corporation
Metro Mirror
Synchronous PPRC
Global Mirror
Asynchronous PPRC
Global Copy
PPRC-eXtended Distance
Allows synchronous mirroring within a 10km (max 100km) distance between the production and replicated system Distance: near Latency: medium concurrency: 100% HA solution phys
74 Common meeting May 5, 2009
Asynchronous mirroring. No acknowledgement to host, if replicated site in error. Primary controller manages error + peak conditions (buffers Writes)
AS DBMS OS
Example: Almost no effort to extend a two node scenario to eight nodes No script programming
Little effort for defining complex HA scenarios
Event Event
Restart & Failover Rules Customer Policies Generic Scenario: customer specified policies SAP Policy DB2 Policy Apache Policy
75
Architecture examples
77
PROD
SAP Landscape
ERP
1 Client DEV&CFG 1 Client Unit Testing 1 Client SNDBX
RDBMS
ERP
1 Client Reference 1 Client Integration testing 1 Client Usr Acc testing
RDBMS
ERP
1 Client
RDBMS
PI
1 Client DEV&CFG 1 Client Unit Testing 1 Client SNDBX
RDBMS
PI
1 Client
RDBMS
BI
1 Client Integration testing 1 Client Usr Acc testing
RDBMS
BI
1 Client
RDBMS
EP
1 Client DEV&CFG 1 Client Unit Testing 1 Client SNDBX
RDBMS
EP
1 Client
RDBMS
CM
RDBMS
TREX
RDBMS
CM
RDBMS
TREX
RDBMS
SCM
1 Client DEV&CFG 1 Client Unit Testing 1 Client SNDBX
RDBMS
SCM
1 Client DEV&CFG 1 Client Unit Testing 1 Client SNDBX
RDBMS
SCM
1 Client
RDBMS
OPTIM
RDBMS
LC
RDBMS
OPTIM
RDBMS
LC
RDBMS
OPTIM
RDBMS
LC
RDBMS
SOLMAN
RDBMS
SOLMAN
RDBMS
78
79
g Lo sh ip pi ng
80
81
ERP CI BI EP PI ERP PI EP SM SOLMAN S P S F P F S P S F P F 146 GB 146 GB 146 GB 146 GB 146 GB 146 GB 146GB 146GB 146GB 146GB 146GB 146GB 146GB 146GB 146GB 146GB 146 GB 146 GB 146 GB 146 GB 146 GB 146 GB 146 GB 146 GB 146 GB 146 GB 146 GB 146 GB 146 GB 146 GB 146 GB 146 GB
S P S F P F
SAN
PI EP
DS4800-4GB dual controller - 16 disks of 146GB 5 EXP810 with - 16 disks of 146GB each
DS4800-4GB dual controller - 16 disks of 146GB 5 EXP810 with - 16 disks of 146GB each
Backup server
S P A R E
82
IBM recommendations
Cluster
OLTP
OLTP
OLAP
OLAP
Cluster
OLTP
OLTP
OLAP
OLAP
Cluster Cluster
VIO
32 FC
VIO
32 FC
Mirroring
Disk DEV/ QA
Mirroring
Disk DEV/ QA
Disk PRD
Boot disks
Disk PRD
Boot disks
83
Datawarehouse benchmark
2008
2009
2010
85
Phase1
DB2 Partition 0 (1-5 dormant) DB2 Partitions 6-13
DB2 Partitions 14-21
Phase2
DB2 Partition 0 (1-5 dormant) DB2 Partitions 6-13
DB2 Partitions 14-21
DB2 Partitions 22-29 DB2 Partitions 30-37 DB2 Partitions 22-29 DB2 Partitions 30-37
6->33 Partitions As Received from Nestle: single DB LPAR with 6 DB2 DPF partitons Redistribution of data over 33 DB2 DPF partitions and 5 x p5 LPARs Phase2 Scalability: DB2 distributed over 5 p595s. Final phase is p5 virtualization: shared processor pool
2009 IBM Corporation
86
87
www.ibm.com/dynamicinfrastructure
89
90
91
Information infrastructure
Storage solutions which integrate with SAP
92
Questions?
Contact: [email protected]
93