1. technology and computing
2. enterprise technology
3. enterprise resource planning

Liwen Yeow - SWG Canada Competitive
p
Leader
[email protected]
(905) 413-2112
Why customers choose DB2
© 2011 IBM Corporation
Agenda
 Migration
Mi ti tto DB2
 Global Consolidation
1
© 2011 IBM Corporation
Successful
S
f l SAP Oracle
O l to
t
DB2 Migration at PepsiCo
BCP-3086A
Kimberly Floss, PepsiCo
Kelly Mannes
Mannes, IBM
2
Disclaimer
The views and opinions expressed in this presentation are strictly those of
the author. The contents of this presentation have not been reviewed,
endorsed or approved by PepsiCo
PepsiCo, Inc
Inc. or any of its affiliates
affiliates.
3
Disclaimer
© Copyright IBM Corporation 2010. All rights reserved.
U.S. Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule
Contract with IBM Corp.
THE INFORMATION CONTAINED IN THIS PRESENTATION IS PROVIDED FOR INFORMATIONAL PURPOSES ONLY. WHILE
EFFORTS WERE MADE TO VERIFY THE COMPLETENESS AND ACCURACY OF THE INFORMATION CONTAINED IN THIS
PRESENTATION, IT IS PROVIDED “AS IS” WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED. IN ADDITION, THIS
INFORMATION IS BASED ON IBM’S CURRENT PRODUCT PLANS AND STRATEGY,
STRATEGY WHICH ARE SUBJECT TO CHANGE BY IBM
WITHOUT NOTICE. IBM SHALL NOT BE RESPONSIBLE FOR ANY DAMAGES ARISING OUT OF THE USE OF, OR OTHERWISE
RELATED TO, THIS PRESENTATION OR ANY OTHER DOCUMENTATION. NOTHING CONTAINED IN THIS PRESENTATION IS
INTENDED TO, NOR SHALL HAVE THE EFFECT OF, CREATING ANY WARRANTIES OR REPRESENTATIONS FROM IBM (OR ITS
SUPPLIERS OR LICENSORS), OR ALTERING THE TERMS AND CONDITIONS OF ANY AGREEMENT OR LICENSE GOVERNING THE
USE OF IBM PRODUCTS AND/OR SOFTWARE.
IBM, the IBM logo, ibm.com, and DB2, Tivoli, TSA, AIX, POWER6 are trademarks or registered trademarks of International
Business Machines Corporation in the United States, other countries, or both. If these and other IBM trademarked terms are
marked on their first occurrence in this information with a trademark symbol (® or ™), these symbols indicate U.S.
registered or common law trademarks owned by IBM at the time this information was published. Such trademarks may also
be registered or common law trademarks in other countries. A current list of IBM trademarks is available on the Web at
“Copyright and trademark information” at www.ibm.com/legal/copytrade.shtml
SAP, Oracle, HP UX, Serviceguard, SRDF
Other company, product, or service names may be trademarks or service marks of others
Disclaimer: Information regarding potential future products is intended to outline our general product direction and it
should not be relied on in making a purchasing decision. The information mentioned regarding potential future
products is not a commitment, promise, or legal obligation to deliver any material, code or functionality. Information
about potential future products may not be incorporated into any contract. The development, release, and timing of
any future features or functionality described for our products remains at our sole discretion
discretion.
4
Summary
•
PepsiCo decided to transform the North American SAP infrastructure to
the IBM AIX/DB2 platform
• Benchmarked costs for SAP Infrastructure were high
• Frito Lay Business was coming on line
• Continuous availability environment
• Upper end scalability required
•
This program was initiated in late October 2009
– Rapid project team ramp-up required
– Migration to AIX/DB2 needed to be complete prior to peak selling season
•
Successfully migrated SAP applications to DB2 on AIX within 6 months
5
5
Business Drivers
Business
Implication
Technical Underpinning
• Compression - Saves disk space
Lower Cost
• Lower hardware cost
(Acquire &
Run)
• “Greener” – Less power/cooling
• SAP can be moved while running (Live Partition Mobility)
• Database and SAP CI can be moved while running
Less
Less
Shhdd l ldd
SScheduled
Scheduled
Downtime • No business outage for hardware/ OS maintenance
Downtime
• Database recovery with no loss of business sessions
Less
Un-Sched
Downtime
6
• SAP CI and Enqueue failover with no loss of sessions
• Pre-emptive live moves before incipient failures
A PepsiCo assessment concluded IBM technology can improve SAP
systems
t
availability
il bilit by
b 3.4
3 4 days.
d
PepsiCo outages totaled
148 hours, or 6 days
• Database
Management
y
System
• Server &
Operating
System,
Network
• Application
(SAP)
Unplanned
• Storage
• Zero outage for
lower-stack
management –
technology
gy
available today
in the industry
Planned
IBM proved to PepsiCo that our POWER6
Servers and DB2 with SAP can reduce
outages by 56%, or 3.4 days.
PoC
Technology
Benefit
Perform application
maintenance while
SAP is running
Live Partition
Mobility
No downtime for
planned
maintenance
Add resources to SAP
for increased
performance while
SAP is running
Dynamic Resource
Allocation
Immediately apply
resource to maintain
availability &
performance
Perform system
maintenance while
SAP is running
Tivoli Systems
Automation
No downtime for
planned
maintenance
• D
Database
t b
Content
• Minimize
outages for
Upper-stack
management
– need
innovative
development
with SAP
Current SAP availability is 97%.
In addition with DB2 HADR your SAP system and data are immediately
available after a disaster.
SAP availability will increase from 97% to 98%.
Value
The value of increased availability to PepsiCo can be significant
• The IBM solution will increase SAP availability by 84 hours per year
– @ $800,000/hour* total savings per year to PepsiCo is $67,200,000
• 80% is $53,760,000
$
• 60% is $40,320,000
• Higher impact during Summer sales months
•
Vision Solutions White Paper Understanding
Downtime
8
PepsiCo
Tangible/Direct
T
ibl /Di
Costs
C
– Lost transaction revenue
– Lost wages
– Lost inventory
– Remedial labor costs
– Marketing costs
– Bank fees
– Legal penalties from not delivering on SLA’s
Intangible/Indirect Costs
– Lost business opportunities
– Loss of employees and/or employee morale
– Decrease in stock value
– Loss of customer/partner goodwill
– Brand damage
– Driving business to competitors
– Bad publicity/press
Scope of 6 Month Project
• Migration of all SAP Landscapes from HP/UX (Superdome/Itanium) to Power/AIX
(Power6 p570/AIX)
• Migration of all SAP databases from Oracle (10g) to DB2 (9.7) including DB2
Compression
• Migration of all production and key non-production servers from HA Clustering on HP
to HA and DR clustering on p570 using Tivoli System Automation and DB2 HADR
• Implementation of fully virtualized server environment using AIX 6.1 with PowerVM,
Dynamic Partitioning, I/O Virtualization and Live Partition Mobility for both databases
(p570) and application (JS43 bladeservers) instances
• Displacement of HP servers, HP/UX, Oracle Database
9
PepsiCo SAP Environment
• 15 p6-570 Servers (32 core) and 55+ JS43 Bladeservers (8 cores) supporting
610+ LPARS; 60+ SAP databases including ECC and BI; 5 SAP Landscapes
(over 650,000 SD SAPS)
• SAP:
– ECC
– BI
– FI
– CO
– SD
– MM
– CRM
– SCM
– SRM
– APO
• Backend storage remains on EMC SAN infrastructure
10
Schedule
2010
2009
Q3
July
Aug
Q4
Sept
Platform Decision
Oct
Q1
Nov
Dec
Jan
Contract
Feb
Mar
Nov 18
Tech Sandbox
First migration
complete
by 12.21.09
P4 Minor Release
on weekend of
4/2
Exp-Imp2 + R&P
Exp-Imp1 + R&P
PreProd
Apr
P_Prod
ETC
May
June
R7 Early
Customer Tech
Cutover weekend
of 6/4
02.15.10
02
15 10
ETC
PreProd
Refresh process
by 07.12.10
R7 in PreProd
R7 Sandbox 01.25.10
R7 Dev2
02.15.10
R7 QA2
Key Stats:
•
•
•
•
•
•
LPARs/OS’s: 540
Databases: 209
Application Servers: 275
570 Frames: 14
Blade Servers: 80
SAP Products:
ERP/ECC, CRM, BI, BPS, SRM, SCM,
ICH, HCM, PI, Portal, CE
• High Availability Configured on:
Prod, PreProd, QA, Tech_SBX
R9 S_box
Training environments not shown (they were re-built, not converted)
11
04.08.10
Conversion completed
before “100 Days of
Selling”
01.18.10
R9 Dev
July
03.15.10
New Data Center
Oct 15
Q3
Q2
02.01.10
R9 QA
03.08.10
R9 UA/PreProd
Dev1
QA1
Exp-Imp3 Prod
04.12.10
04.12.10
04.26.10
05.10.10
How we did it?
• 11 Production Systems were moved in a single outage window
– Services provided by collaborative team across multiple business units in
–
IBM
24x7 Migration team assigned migration of same applications across the
SAP landscape
– 11 Migration consultants from 5 different countries
• Before migration a HA environment built on HADR and TSA (incl. replicated
Enqueue Server) was setup
• Parallel export and import with various advanced optimization techniques, like
unsorted export, split tables via where clause, special parameter setup for
import
• Manyy pperformance tests,, with varying
y g numbers of transactions / load
12
PepsiCo’s Perspective
13
Why PepsiCo chose IBM
•
Cost
– Software
•
DB2 was acquired through SAP OEM agreement so it does not cost
PepsiCo additional software$ when more CPUs are added to the
environment; Not the same for Oracle.
– Hardware
H d
•
•
•
•
•
PowerVM flexibility; Live Partition Mobility feature which helps
scheduled planned outages without application downtime
SAP / IBM relationship
Compression – disk savings
L
Less
security
it patching
t hi
IBM expertise to perform migration
14
What IBM brought to the table for PepsiCo
• Improved Availability to end users
– Reduced planned and unplanned outages via Live Partition
Mobility,
y, Dynamic
y
provisioning
p
g of resources,, and HADR/TSA
technology
• Reduced TCO
– 44% fewer boxes; over 50% reduced storage needs; 50% reduced
floor space; 57% reduced energy/power;
– Lowest cost: License and maintenance costs via SAP OEM
– Fastest access to technology for SAP customers
• Deep technical and project management services leading up to
migration cut over and after go-live
– Architecture and Design Services; Server Infrastructure services;
DB2 installation and configuration
• SAP and IBM Partnership
15
DB2 for SAP Summary Benefits Table
Function
Oracle
DB2 for SAP
Enterprise Database
Database Partitioning
RAC: Additional
Deep Compression (Proven 41% with PepsiCo data, additional 10% - 15% with new version of DB2)
Compression: Additional, not SAP Certified and not as
comprehensive
Range Partitioning
Range: Additional
Multi-Dimensional Clustering
g
Not Available
High Availability Failover for Disaster Recovery (HADR)
DataGuard: Additional
No Additional License and Maintenance Charges to PepsiCo for Year to Year Organic DB Growth
Additional Charges as additional CPU’s are required
No Additional License and Maintenance Charges for the addition of the Bottlers and PI
Additional Charges as additional CPU’s are required
Reduce Duration of PepsiCo Downtime and Scheduled Maintenance and Improved Uptime
(Compression & HADR)
Additional Charges for Compression and Data Guard
to enable shorter backup
p and restore
Database release cycles synchronized with SAP and prompt certification of new releases (enables
PepsiCo to take advantage of latest innovations and capabilities while reducing DBA work)
Improved Response Time for improved End User Performance (Compression)
16
16
Release windows not synchronized and delay for
certification of new releases
No Compression to enable improved response time
September 4, 2008
Benefits
• Business Case
– Reduce rate of growth in SAN infrastructure through DB2 Compression
– Reduce planned outages by up to 40% through tight DB2/SAP integration
– Reduce unplanned
p
transactional outages
g through
g tight
g integration
g
of TSA with
DB2/SAP
– Reduce planned outages from operating system and hardware maintenance
through PowerVM, LPM and TSA
– Increase SAP transactional performance and scalability through tight integration of
P
Power
and
d DB2 ttechnologies
h l i
• Observed Benefits
– DB2 Compression of SAP databases reduced disk consumption by 40+%
– Power Systems and DB2 increased the performance for key interactive and batch
–
–
–
–
17
workloads by up to 3x
Achieved high water mark of over 500,000 dialog steps/day within 48 hours of
production cut-over
Able to reorganize SAP databases without application outage
Able to fail-over SAP production using TSA without production outage
Able to migrate workloads between servers and increase resources to production
servers using PowerVM without taking SAP outage
Nestlé Global Consolidation
 GLobal Business Excellence
– Common Business Process (Best Practice)
– Common Data (Corporate Asset)
– Common IT Infrastructure (Standards)
 Largest SAP Implementation in the world
 Innovative SAP design and implementation
 All Nestlé’s 87 Markets will adopt GLOBE
 Designed by Company Nestlé, SAP and BCS
9.7,
7 Power7
Power7, DS8000)
 Implemented on IBM Technology (DB2 9
18
© 2011 IBM Corporation
Nestlé’s System Landscape
 4D
Data
t C
Centres
t
serving
i 3G
Geographies
hi (Eur,
(E A
Americas
i
and
d APA)
 500 Production Systems
– ECC,, BW,, APO,, CRM,, SEM
 ECC
–
–
–
–
–
Average 15-25TB database size (compressed)
40M di
dialog
l steps/week
t
/
k
150,000 active users
5,000 concurrent users
HADR with servers 100km apart – sync mode
 BW
– Largest is 80TB database size (compressed, saved 70TB) – Global Reporting system
– 700 SAP work processes
– Using DB2 DPF with 33 partitions – insert 5M rows into 32 partitions in 8s
19
© 2011 IBM Corporation
DB Architecture: DB2 DPF
DB2
Partition 0
DB2
Partitions
16-23
SAP Application Servers
DB2
Partitions
9-15
DB2
Partitions
1-8
DB2
Partitions
24-31
DB2 DPF Database with 33 partitions
© 2011 IBM Corporation
Nestle : World’s largest SAP BI Data Warehouse with 60TB
Major Key Performance Indexes
Requirement
Achieved
Recovery of an entire days work
Restore Database and roll forward 500GB of logs
<8hrs
2hr 40min
Using FlashCopy
Disaster Recovery
Complete Database restore from tape + roll forward of 2TBs of logs
<24hr
10hrs
Using LTO3
Daily Backup to Tape
Full Database backup to Tape
<12hr
6hr 10min
Using LTO3
Daily Backup to Disk
Completed processing of incremental FlashCopy of production day
<8hr
30min
Using Flash Copy
Infrastructure






21
SAP NetWeaver
N tW
7.0
70
IBM DB2 V9
Tivoli Storage Manager
p595 & AIX 5.3
DS8300
S
Turbo
Tape Library 3584
© 2011 IBM Corporation
Summary of Nestle’s experience
 Scalability
Scalabilit
– Ability to scale out to handle very large databases
– Near linear performance for data load, maintenance, and query performance
– NO
O LIMITS
S - Results
esu s sstrongly
o g y indicate
d ca e further
u e sca
scalability!
ab y
 Platforms
– Combination of SAP BW and IBM DB2 9 DPF p
proven to be industrial-strength
g p
platform for
very large Data Warehouse solutions
– Massive Performance and scalability benefits from powerful DB2 9 DPF partitioning
feature
Largest SAP BI Data Warehouse World Wide so far!
22
© 2011 IBM Corporation
200+ SAP customers migrated to DB2
23
© 2011 IBM Corporation
24
© 2011 IBM Corporation