Migracja z oracle_do_db2

© 2011 IBM CorporationSeptember 26, 2011

Migracja z Oracle do DB2 9.7Korzyści biznesowe i wsparcie ze strony IBM

Andrzej SteinderManager, CEE IMTEIBM Krakow

[email protected]

© 2011 IBM Corporation22

Agenda

Why migrate to DB2? DB2 9.7 business values Oracle to DB2 migration is easy IBM migration support and service offering Success stories Q&A


Why migrate from Oracle to DB2

DB2 provides better business value formoney Lowest TCO, highest performance..

Migration is easy

IBM provides wide offering supportingmigrations

Expand customer base (IndependentSoftware Vendors – ISVs)


Oracle Drops Support for Itanium Servers

On March 22, 2011, Oracle announced that it will no longer develop orcertify any Oracle software for the Itanium microprocessor

This follows Oracle’s Dec 1, 2010 announcement that it had doubledthe cost of running Oracle software on HP Itanium servers

Oracle is attacking HP, but is hurting their HP-UX Itanium customersin the process by– Doubling license fees– Limiting choice– Putting existing investments in HP-UX at risk

What will Oracle do next?– Is Oracle a software partner you can trust?


IBM Continues to Support HP-UX Itanium Servers

IBM is one of the worlds largest providers ofsoftware certified to run on HP-UX including– DB2– InfoSphere– WebSphere– Tivoli– Rational

IBM is committed to supporting its large HP-UXcustomer base

“A cornerstone of our middleware strategy is to deploy service-orientedarchitectures across a broad range of platforms, including HP Integrity serversrunning HP-UX 11i, which is a priority platform supported by IBM SoftwareGroup” - Sandy Carter, VP WebSphere Strategy, IBM Software Group


Agenda



The Business Value of DB2 for Linux, UNIX, andWindows Lower administration requirements than other

DBMSs– Means less DBA resources for day-to-day activities

Better performance per core than other DBMSs– Means less cores required for the same work

Better compression than other DBMSs– Means less storage and improved performance

Better availability than other DBMSs– Means less down time, no loss of

goodwill/opportunity Better development - Supports PL/SQL with little to

no change– If you want consolidate Oracle applications, you can

do that on DB2 with little or no change

Most ReliableWorld class audit & security

Easy High AvailabilityWorkload ManagementY

Most ReliableWorld class audit & security

Easy High AvailabilityWorkload ManagementY

Simple to UseFlexible Development

Industry leading XML supportSelf-Managing

Simple to UseFlexible Development

Industry leading XML supportSelf-Managing

Lowest TCOUnparalleled Automation

Deep CompressionLightning Fast

Lowest TCOUnparalleled Automation

Deep CompressionLightning Fast


Coca-Cola Bottling Caps Rising Costs of Oracle$1.4B manufacturer improves performance while reducing costs

The need: Optimize performance and manageability of business-critical SAP

applications with SAP upgrade and conversion to Unicode Avoid increased Oracle licensing costs

The solution: Replace the Oracle database with DB2, reducing licensing and

TCO costs while improving performance

The IBM advantage: DB2 deep compression reduced data storage from just under

1TB to 575GB Migration in <26 hours, ahead of schedule, under budget Higher Oracle licensing costs avoided

The benefits: 40% reduction in storage, saving cost, reducing backup times

65% faster manufacturing runs: from 90 minutes to 30 minutes

5 year cost savings $750,000

An easier to administer systemSource: ftp://public.dhe.ibm.com/common/ssi/ecm/en/spc03074wwen/SPC03074WWEN.PDF

“By choosing to implement DB2compression right away, we havereduced the database size by around40 per cent. This gives us fasterbackup and reduced storage costs,and makes the SAP technicalupgrades easier and quicker.”

— Andrew Juarez, SAP Lead Basis, Coca-ColaBottling Company Consolidated

Solution components: IBM DB2 software IBM POWER Systems hardware IBM-SAP Alliance services


What Customers Worldwide Say About DB2 9.7

“The migration to DB2 was completed in three months. We estimate that databaseoperational costs have been cut by 68 percent. Deep system and analysis checks thatformerly took several hours are now completed within 30 minutes, returning valuablemanagement data quickly and cost effectively. The migration was smooth and completedabsolutely without a hitch.”

Head of Server and Storage Operations

Industrielle Werke Basel

"We switched from Oracle Database to IBM DB2 and cut our data management costs inhalf, while improving performance and reliability of business applications."

Systems ArchitectBanco de Crédito del Peru


Agenda



Moving to IBM DB2 9.7 is Easy

DB2 has native support for the following Oracle Database features

Typically, more than 90% of code runs out-of-the-box in DB2 Many clients continue to use their Oracle skills after moving to DB2!


DB2 PL/SQL Compatibility Results 430 worldwide customers and partners

Variety of EAP participants: Different industries Different types of solutions Different countries

Different size applications tested Biggest: 185,000 PL/SQL statements Smallest: 2,000 PL/SQL statements

Evaluated millions of lines of PL/SQL code

PL/SQL support results: More than 750,000 lines tested Average compatibility: 98.43%

90% reduction of migration times

The IBM DB2 9.7 compatibility is amazing — and there are no queries or DB2-specific code inour applications! Everything is compatible with Oracle and DB2 9.7.”- Gene Ostrovsky, VP R&D, ExactCost


9.1 → 9.7 reduced Conversion effort to 1/10th

9.7 → Next DB2 release reduces Conversion effort by half again

Widening theFunnelAccept forapplicationsMore APIsPro*CFormspureScaleExtend DPF support

Fatteningthe PipeFurthersimplifyconversions

DB2 Development Strategy


Openbravo migration to DB2

Web-based Open source ERP Developed by Openbravo Millions of downloads Used in over 50 countries

Currently supported RDBMS Oracle & PostgreSQL Database Size 520 tables 400+ PL/SQL routines/triggers

"To move our application to DB2 9.5 would have taken an estimated two-year effort. Wewere thrilled to see it took only one week to move it to DB2 9.7. This represents a terrificopportunity to expand our international community of users, partners and developers, andwe’re very excited to partner with IBM to make new deployment options available.” PaoloJuvara, CTO of Openbravo (Spain)


The Praise for SQL Compatibility

“We specifically chose to take part in the IBM DB2 early access program because of theprogram's goal to run 90 to 95 percent of Oracle PL/SQL functionality without modification.This allows us to reduce the time to port our stored produce persistence layer from Oracleto DB2 from 450 days down to 75 days.” – David Moody, Senior Vice President of Product andFounding Director, Lagan

“The Oracle compatibility feature will enable Oracle applications to run natively on DB2.In discussions with Gartner, reference customers tell us that DB2 runs 95% or more ofOracle specific functionality found in SQL statements and natively runs PL/SQL, Oracle’sstored procedure language. This native functionality is not an emulator, nor does itrequire changes to the application code (other than the 5%, which is mostly minorfunctionality, not found in many applications). Any provider offering applications that runwith the Oracle DBMS can easily port its application to IBM’s DB2…” - Donald Feinberg,Gartner VP Distinguished Analyst


Agenda



Mitigate the risk of moving from Oracle to DB2/InformixConvert with experience and trust

Information Management Technology EcosystemWorldwide

IMTE has the breadth and depth of experience

• Successful track record in many projects• Proven implementation methodology• World class capabilities

350+ Experts

What kind of support can IMTechnology Ecosystem provide?

Skills Transfer (Bootcamps): Teachyou deep product implementationskills required for real project execution

Project Specific Enablement: Provideimplementation assistance to clientsand ISVs to accelerate time-to-valueand mitigate risk

Mentoring: Create more valueby helping clients navigate the wealth

of IM portfolio and apply technologyin solutions

Skilled & certifiedStrong driver for a successful

project

Provide consultative support toyou in real life projects

Build deep relationship withyou for repeatable success

IM Product Areas:• DB2 for LUW• DB2 for z/OS• DB2 pureScale• SAP and DB2• Informix• InfoSphere Warehouse• InfoSphere Information

Server• Infosphere DataStage• InfoSphere QualityStage• InfoSphere Change Data

Capture• InfoSphere MDM

Server/MDM for PIM• Optim Governance• Guardium• Netezza


Information Management Technology Ecosystem TeamWe can help! Anywhere, anytime!

DB2 “Avalanche” Offering ListConversion Assessment

Proof of Concept / Pilot

Application Conversion (fee based)

Post Conversion Health checks

Education & Knowledge Sharing

DB2 for SAP Offering List

Proof of Concept

Pre-Migration Support

Production Migration through Services*

Post Migration Support

Education / Knowledge Sharing

* Contact Joerg Peinelt for details


Conversion AssessmentDescription:

The Conversion Assessment provides an analysis of your database and application architecture. IBM willwork with <Client> to outline the scope of the assessment. Our Conversion Assessment Questionnaireallows us to gather information for evaluating the technical feasibility of a conversion to DB2 for Linux, UNIX,and Windows.

Includes: In-depth examination of your source code and database

Benefits:

This “No Charge” offer provides an assessmentof your application and database

Make informed decisions Identify potential issues early Understand your business risk Provides you with a comprehensive inventory

of your current applications Identify candidate pilot project(s) Accurately scope and plan your conversion

Deliverables:

Conversion Assessment High-Level Project Plan


Proof of Concept / PilotDescription:

The Proof of Concept (POC) focuses on migrating 1-2 candidate applications. It will allow IBM and <Client>to prove that a full conversion can be completed successfully.

Includes: A DB2 technical viability exercise using your database and application(s) within your environment

Benefits:

Provides confidence moving forward with afull conversion

Demonstrates Oracle compatibility features inDB2 9.7

Confirms the conversion strategy Reduces risk by addressing issues in a

controlled environment Allows the project team to validate

assumptions and assessment

Deliverables:

Conversion and Compatibility Report Functional database(s) on DB2 Functional application(s) Proof of Concept Final Report Lessons learnt session


Application Conversion (fee based)Description:

The Conversion Implementation Service provides a full conversion of your database and application(s) toDB2. IBM will hand-over to <Client> a fully functional environment for acceptance testing. Our team willwork with you during test cycles to address any issues as a result of the changes made to your code.

Includes: Production ready system with database and application source code modifications

Project is based on Statement of Work between client and IBM

Benefits:

Implement a well defined strategy Leverage IBM's proven implementation

methodology and conversion experience toreduce your risk

Receive a final report documenting all thechanges IBM has made to your code

Post go-live support

Deliverables:

Conversion Specification Document Conversion and Compatibility Report Functional database(s) on DB2 ready for

production Functional application(s) ready for production DB2 Solution Health Check Report Lessons learnt session


Education and Knowledge SharingDescription:

Education and best practice sharing is a key ingredient to the success of the overall project. IBM hasdeveloped several training bootcamps to address the needs of your team as you migrate over to DB2.These courses will assure your developers and DBA's that DB2 and Oracle have more in common than justPL/SQL and confirm that their skills are re-usable.

Benefits:

This “No Charge” offer provides you with quickramp up to DB2 for your resources Leverage IBM's conversion experience to

reduce your risk Ease the transition to DB2 Learn how to exploit features independent of

code level

Deliverables:

2 week bootcamp DB2 9.7 and Oracle to DB2 9.7

Conversion Clinic IBM DB2 Workshop for Oracle

Professionals Performance Tuning and Monitoring

Clinic


DB2 9.7 and Oracle toDB2 9.7 Conversion Clinic

The DB2 9.7 Bootcampintroduces features andenhancements in the latestversion of DB2 for Linux®,UNIX® and Windows®

IBM DB2 Workshop forOracle ProfessionalsDesigned especially for Oraclepractitioners, this sessioncovers the OracleCompatibility features in DB29.7 and includes a demo onthe conversion process. Italso compares Oracle andDB2 technologies to help youunderstand the similarities anddifferences

WEEK 1 WEEK 2*

Performance Tuning andMonitoring Clinic

The DB2 Performance Tuningand Monitoring Clinic is a seriesof distinctly focusedpresentations and labs repletewith "How to's" and "BestPractices" intended to help theattendee master the intricaciesof maintaining a healthy androbust DB2 based informationmanagement system

*Note: Performance Tuning and Monitoring Clinic is recommended post go-live after your teamhas had a chance to work with DB2

DB2TrainingDB2Training

Education and Knowledge SharingCourse Description


Resource Investment and Executive Management Lab Advocate: <Client> will be assigned a Lab Advocate. The Lab Advocate

Program is a relationship with select IBM clients focused onassisting them in achieving success in their use of the DB2solution

For ISVs – IBM Ready 4 DB2 program

Senior Architect Support: (Onsite and Remote) IBM will provide an architect as part of the project to ensure

success. Your architect will be supporting the team post go-livefor up to 2 weeks providing continuity and reducing your risksduring this critical phase

Executive Management Support: IBM will provide Executive Management support during the

project

IBM Account Team: The IBM Account Team will work closely with <Client> to ensure

<Client> gets any necessary assistance on an ongoing basis


Your Path to DB2 – We can do it for you… Project management Configuration management and merge processes Re-coding of non-compliant segments from Oracle to DB2 Performance analysis and optimization Solution deployment and world wide roll outs

BENEFITSREALIZATION

VALUEPROPOSITION

PROGRAMPLAN

BENEFITSREALIZATION

VALUEPROPOSITION

PROGRAMPLAN

AnalysisWhat are wegoing to do?

AnalysisWhat are wegoing to do?

DesignHow will we

do it?

DesignHow will we

do it?

TestQuality

Assurance

TestQuality

Assurance

BuildGetting it

done!

BuildGetting it

done!

DeployPrepare to

Go Live!

DeployPrepare to

Go Live!

StrategySolve aproblem

or BusinessValue?

StrategySolve aproblem

or BusinessValue?

Strategy & Analysis

Post DeployHow do we

measuresuccess?

Post DeployHow do we

measuresuccess?

Knowledge Sharing & Training

Development, Configuration, Infrastructure, Conversion, Testing

Program ManagementProgram Scope


Standard Conversion Practice Conversion assessment phase

Conversion assessment questionnaire Application conversion session Conversion assessment document

Database object conversion phase Conversion of database structures and objects Move of data from old to new system Enabling compression Configuration of autonomic functions

Application conversion phase Code adjustments to existing application per

conversion assessment Function and system test

Solution deployment phase Additional database optimization Index review Overall solution health-check

Skills Transfer and DB2 ramp up (independent of above)

If a PoC, is required, please addPlanning Phase- Outline conversion PoC process- Define resources required (HW,SW and people)- Define IBM and Clientcommitments- Application Selection(Goal is to ensure that we jointlyselect an application whichshowcases DB2's ease ofconversion, yet can be containedwithin a PoC window)- Joint project plan with milestonedates.


Tools Available At Each Step of the MigrationPOCAssessment Database

ConversionApplicationConversion Testing

AutoFix MEET Estimator

CAQ

• AutoFix Parse applicationcode and replace unknownSQL API syntax by properDB2 SQL API syntax. We usestandard pattern basedreplacement of knownrepetitive code snippets

• MEET Analyzes SQL code forits compatibility with DB2residing inside the databaseor within other programminglanguages

• Conversion AssessmentQuestionnaire (CAQ)Creation of electronic formwhich will prepare thecollected information byclients for the estimationprocess

• Estimator calculates theconversion efforts based onMEET and CAQ findings

PackageVisualizer

• Package Visualizerdepicts dependenciesbetween PL/SQLobjects to identify theright scope for a POC

IDMT

• IDMTAutomaticallydeploys databasestructure and datafrom othervendor’sdatabases to DB2

Databaseconversionworkbench

ConversionProject

Timeline

Optim DataStudio

AdditionalOracle

Packages


Agenda



Success story - JSC Rietumu BankaReducing total cost of ownership by 20-30 percent

The need:With the worldwide recession placing pressure on banks to reduce costs, thecompany’s CIO was concerned with total cost of hardware, software andadministration supporting the company’s online banking applications. Thebank’s web applications ran on Oracle Database and Sun servers and it foundthat the annual fees were costly and administration time consuming.

Solution:The bank selected iRietumu, its remote banking application, as its firstapplication to migrate from Oracle Database 10i system on Sun Fire E6900operating systems to IBM DB2 9.7 for Linux data server on IBM Power 750Express servers running the IBM AIX Enterprise Edition operating system.

Decision factors: Cost analysis – expected significant (30%) cost reduction after migration Successful PoC for application migration – demonstrating feasibility andease of migration to DB2 9.7. More than 90% of the application code ran out-of-the-box in DB2


Success story - JSC Rietumu BankaReducing total cost of ownership by 20-30 percent

“By migrating to IBM DB2we expect to decrease totalcost of ownership for our

mobile device bankingapplications by 20-30

percent.”

— Sergey Golubev, Head of ITMaintenance and Networking

Department, JSC Rietumu Banka

Project implementation: The customer team supported by IBM consultants migrated iRietumu applicationin 6 weeks IBM has delivered training courses and certified Rietumu staff in DB2 9.7

The benefit:

With its migration to IBM DB2 JSC Rietumu Banka reduced the total cost ofownership for its online banking infrastructure and dramatically improved queryperformance and data availability. On average, user queries are now executed upto 3 times faster, with some queries completed up to 30 times faster (for example,some queries that before took 30 seconds now take less than one second). Duringthe migration process, the bank reported an out-of-the-box compatibility rate ofmore than 90 percent.


Q&A

Migracja z oracle_do_db2

Technology

Transcript of Migracja z oracle_do_db2