Deploying a private database cloud on z Systems

April 13

₂₀₁₆

Deploying a private database cloud on z Systems

How DPS evolved over time and what is coming next

SAP on z IBM Systems Conference

Trademarks

The following are trademarks of the International Business Machines Corporation in the United States and/or other countries.

BlueMix

CICS*

COGNOS*

DB2*

MQSeries*

OMEGAMON*

Parallel Sysplex*

RACF*

DS6000*

DS8000*

FICON*

GDPS*

* Registered trademarks of IBM Corporation

Notes:

Performance is in Internal Throughput Rate (ITR) ratio based on measurements and projections using standard IBM benchmarks in a controlled environment. The actual throughput that any user will experience will vary depending upon considerations such as the amount of multiprogramming in the user's job stream, the I/O configuration, the storage configuration, and the workload processed. Therefore, no assurance can be given that an individual user will achieve throughput improvements equivalent to the performance ratios stated here.

IBM hardware products are manufactured from new parts, or new and serviceable used parts. Regardless, our warranty terms apply.

All customer examples cited or described in this presentation are presented as illustrations of the manner in which some customers have used IBM products and the results they may have achieved. Actual environmental costs and performance characteristics will vary depending on individual customer configurations and conditions.

All statements regarding IBM's future direction and intent are subject to change or withdrawal without notice, and represent goals and objectives only.

Information about non-IBM products is obtained from the manufacturers of those products or their published announcements. IBM has not tested those products and cannot confirm the performance, compatibility, or any other claims related to non-IBM products. Questions on the capabilities of non-IBM products should be addressed to the suppliers of those products.

These are trademarks or registered trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. A current list of IBM trademarks is available on the web at “Copyright and trademark information” at: http://www.ibm.com/legal/us/en/copytrade.shtml

The following are trademarks or registered trademarks of other companies.

LinkedIn, the LinkedIn logo, the IN logo and InMail are registered trademarks or trademarks of LinkedIn Corporation and its affiliates in the United States and/or other countries. Java and all Java based trademarks and logos are trademarks or registered trademarks of Oracle and/or its affiliates.

Linux is the registered trademark of Linus Torvalds in the U.S. and other countries.

Adobe, the Adobe logo, Acrobat, PostScript, and Reader are either trademarks or registered trademarks of Adobe Systems Incorporated in the United States and/or other countries. Microsoft, Windows, Excel, Outlook, and PowerPoint are registered trademarks of Microsoft Corporation.

Oracle and Java are registered trademarks of Oracle and/or its affiliates. UNIX, X/Open, OSF/1, and Motif are registered trademarks of the Open Group.

OpenStack is a trademark of OpenStack LLC. The OpenStack trademark policy is available on the OpenStack website.

SAP, R/3, SAP NetWeaver, ByDesign, SAP BusinessObjects Explorer, StreamWork, and other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP SE in Germany and other countries.

All other product and service names mentioned are the trademarks of their respective companies.

Data contained in this document serves informational purposes only. National product specifications may vary.

GUARDIUM*

HyperSwap

IBM*

IBM (logo)*

Rational*

Redbooks*

SmartCloud*

Tivoli*

UrbanCode

WebSphere*

z13

zEnterprise*

z/OS*

zSecure

z Systems

z/VM*

Legal information

Please note

IBM’s statements regarding its plans, directions, and intent are subject to change or withdrawal without notice at IBM’s sole discretion. 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.

Performance is based on measurements and projections using standard IBM benchmarks in a controlled environment. The

actual throughput or performance that any user will experience will vary depending upon many factors, including

considerations such as the amount of multiprogramming in the user’s job stream, the I/O configuration, the storage

configuration, and the workload processed. Therefore, no assurance can be given that an individual user will achieve results

similar to those stated here.

Availability. References in this presentation to IBM products, programs, or services do not imply that they will be available in all countries in which IBM

operates.

The workshops, sessions and materials have been prepared by IBM or the session speakers and reflect their own views. They are provided for

informational purposes only, and are neither intended to, nor shall have the effect of being, legal or other guidance or advice to any participant. 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. IBM shall not be responsible for any damages arising out of the use of, or otherwise related to, this presentation or any other

materials. 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 the applicable license agreement governing the use of IBM software.

All customer examples described are presented as illustrations of how those customers have used IBM products and the results they may have

achieved. Actual environmental costs and performance characteristics may vary by customer. Nothing contained in these materials is intended to, nor

shall have the effect of, stating or implying that any activities undertaken by you will result in any specific sales, revenue growth or other results.

Let me tell you a story...

... our story, the story about our journey

Source: haroldloren.com

... the journey of our transformation

Who we are...

the SAP on OS/390  development team

people having different skill sets, many of them non-mainframer,

SAP‘s Software Lifecycle Validation (FA, PS) departement

located all over the place, no mainframe skill at all*

and the IT department responsible for all infrastructure,

system programer, database- and storage administrators

What was happening as the story began was…

First shipment 1997: SAP R/3 3.0F

The team provided databases running on z/OS and executed the necessary

life cycle management tasks based on user request, all manually

Volume of requests was clear, rather constant, predictable

Rolling out a single SAP product: SAP R/3

And then what happened was…

the situation escalated, SAP changed its product portfolio, explosive growth in

number of databases required and in consequence also the number

of requests for provisioning, maintenance, cloning, short lead time.

Procedures in place felt short, took too long and did not scale well.

Delays in development, testing and rollout because of request jam.

There was a high danger in missing important SAP product rollout cycles.

SAP SCM 4.0

SAP SCM 4.1

SAP SCM 5.0

SAP SCM 5.1

SAP SCM 7.0

SAP BBP 2.0B SR2

SAP BBP 2.0C SR1

SAP EBP 3.0

SAP EBP 3.5

SAP EBP 4.0

SAP SRM 2.0

SAP SRM 3.0

SAP SRM 4.0

SAP SRM 5.0

SAP SRM 6.0

SAP SRM 7.0

Start Releases: min. 64

SAP systems needed: 256

SAP CRM 2.0B SR2

SAP CRM 2.0C SR1

SAP CRM 3.0 SR1

SAP CRM 3.1

SAP CRM 4.0

SAP CRM 5.0

SAP CRM 5.1

SAP CRM 6.0

SAP CRM 7.0

SAP APO 3.0A

SAP APO 3.1

SAP BW 2.0B

SAP BW 2.1C

SAP BW 3.0A

SAP BW 3.0B

SAP BW Content 3.1

SAP BW 3.5

SAP BW 7.0

SAP BW 7.01

SAP BW 7.10

SAP WEB AS 6.10

SAP WEB AS 6.20

SAP WEB AS 6.30

SAP WEB AS 6.40

SAP NetWeaver 04 / 7.0

SAP NetWeaver 04S / 7.1

SAP EP 6.0

SAP PI 3.0

SAP PI 7.1

4 platforms

SAP Solution Manager 3.0

SAP Solution Manager 3.1

SAP Solution Manager 7.01

SAP R/3 3.1I SR1

SAP R/3 4.0B SR1

SAP R/3 4.5B

SAP R/3 4.6B

SAP R/3 4.6C SR2

SAP R/3 Enterprise 47X110 SR1

SAP R/3 Enterprise 47X200

SAP ECC 5.0

SAP ECC 6.0

SAP Business Suite 7

What is your Challenge?

Frequent SAP System Refresh

New SAP landscapes

for development

Introduce new DB2 release

provide dev systems

migration existing systems

Apply DB2 maintenance

Provide Sandbox systems, short lead time

Add SAP systems for new geographies

And to take on the situation, we…

Initiated a dev project, the idea of database provisioning system was born.

Automate most critical operations, first based on existing procedures, mainly

to support the database administrator only.

Build prototype quickly, first success did not stop us from moving on...

Recognize the possibilities & opportunity to turn the table

Which resulted in…

Private database cloud on z/OS

IBM Entry Cloud Configuration for SAP Solutions on zEnterprise

Self-service portal for development and test departments

(pools & groups)

Proactive resource planning and template preparation

(monthly + SAP note 81737)

Foundation for continuous, automated testing, rollouts on schedule (REST)

And it goes on…

Add support for more Cross-sysplex cloning scenarios

Enable DB2 discovery

Deep integration with SAP LVM

Rolling out new capabilities continuously,

• Be proactive – turn the tables

• Get started, it is available - PoC, free of charge

• DPS = IBM Entry Cloud Configuration for SAP Applications on IBM zEnterprise

• Cultural change: Take the opportunity

• Distributed learned a lot from mainframe, now its time to learn something from

distributed

• „We are in competition“

• Recommended set of video: How mainframers can participate in cloud

youtube video

http://youtu.be/1K8R03TTgmg?list=PLfD3irl3Su9osSjGc58LHaO2B56Ncf2wk

Key Takeaways

Thank you

DPS: Automatic build & test

•

Agile development: 2 week iteration

•

Daily automatic build

•

Automatic deploy on test server

•

Run test suite which covers approx. 90 workflows including cloning tests

•

Continuous delivery to productive environment: SAP Test Cloud

SAP OQ Tests

•

SAP‘s test framework to ensure quality: Output Qualification

•

Continuous, scheduled tests (daily, weekly, ...)

•

Covers

•

installation of SAP with DB2 on z/OS

•

Several upgrade scenrios (ABAP, Java)

•

Leverage DPS to

•

Provide DB2 instances on z/OS with current maintenance levels (at least monthly, every DB2

put level)

DPS – New capabilities

•

System level backup / restore

•

Cloning

•

Based on system level backup

•

Based on logical dump

•

Cross-sysplex*

•

Pools and Groups

•

REST API

•

SAP PTF checker integrated

•

Start/Stop

IBM z/OS Management Facility (z/OSMF)

•

Part of z/OS, no extra costs

•

Tasks

•

Capacity Provisioning

•

Configuration Assistant

•

Incident Log

•

ISPF

•

Software Management

•

System Status and Resource Monitoring

•

Workflows

•

Workload Management

•

Representational State Transfer (REST) services for

•

Creating and managing workflows

•

Creating and managing software instances