1-4_SAP-升级及信息迁移解决方案

DB2OptimizedForSAP:SAPUpgradeandMigrationSolutionWang,[e-mail]upportAgenda•ExperiencefromaHappyDB2/SAPReferenceCustomer•WhyshouldyouuseDB2inyourSAPinfrastructure•SomekeyDB2TechnologicalDifferentiatorsforSAPSolutions•HowtomigratefromOracletoDB2•MythsregardingmigratingfromOracletoDB2•LearningsfrommoreSAPCustomers:MigratingfromOracletoDB2ExperiencefromaHappyDB2/SAPReferenceCustomerSAPITrunsitsbusinesssystemsonDB2•SAPITisanOracle-Freezone(sinceAug2007)•HR@SAPrunsonDB2/HP-UXwithUnicode(migratedfromOracle)•CRM@SAPrunsonDB2/HP-UXplatform(migratedfromOracle)•UpgradedR/3tomySAPERP2005(a.k.a.SAPERP6/ECC6)onDB2/HP-UXwithUnicode(migratedfromOracle)•UpgradedtoBI7.0/NetWeaver2007onDB2(migratedfromOracle)Agenda•ExperiencefromaHappyDB2/SAPReferenceCustomer•WhyshouldyouuseDB2inyourSAPinfrastructure•SomekeyDB2TechnologicalDifferentiatorsforSAPSolutions•HowtomigratefromOracletoDB2•MythsregardingmigratingfromOracletoDB2•LearningsfrommoreSAPCustomers:MigratingfromOracletoDB2ValueofDB2OptimizedforSAPtoYOU-theCustomerTheDB2/SAPPartnership:deliversDB2OptimizedforSAPSoftwaregivesCustomersBetterPerformanceLowerTotalCostofOwnership(TCO)Better-than-ForecastReturns-on-Investment(ROI)Value:BetterPerformancewithDB2•Proof-points:–SAPIT:achieved40%betterperformance–rku.it:40%betterdialogandbatchperformanceonthesamehardware–Siemens:40%betterperformanceonthesamehardware–SAP3-TierSDbenchmark:DB2is68%betterthanOracle;80%betterthanSQLServer•ValueforCustomer:–Betterperformance=betterthroughput=higherworkloadproductivity=better/quickerresponse–DB2willdeliverbetterthroughput(processedmoreworkload)onsimilarhardwareconfigurationinfrastructurecomparedtootherdatabases–Betterthroughputalsomeansthelife-spanofhardwareinfrastructurewilllastlonger=savingsonhardwareinvestmentsorhigherthroughputperunitofhardwareinvestmentonDB2•AsinSAPIT,the‘..investmentinnewserverandstoragehardwarewillactuallylastlonger’Value:LowerTotalCostofOwnership(TCO)withDB2•Proof-points:–AustrianRailways:reducedTCOby25%–rku.it:reducedTCOby40%–Siemens:reducedSAPTCOby40%within1styear–Coca-Coca:reducedstoragefootprintby40%•ValueforCustomer:–LowerTCO=savingsonITBudget(CAPEX&OPEX)•CapitalInvestmentsavings=deferredhardwareinvestmentorlesshardwareresourcetodeliveranunitofthroughtput–DB2“exploits&extends”thelifeofthehardware(includingstorage)•Operatingexpensesavings=lessITresourcetomanageSAPonDB2=10%to30%savingsonmanpoweronthesameunitofworkload–ViatheSAPDBACockpit,DB2iseasiertomanage(autonomic&invisible)–Lowerexpensesonlicensing/maintenanceonDB2(whichincludeDB2Compression,HighAvailability&DisasterRecovery,DatabasePartioning&WorkloadMgtatnoadditionalcost)–LowerhardwareinfrastructureexpensesforSAPonDB2(duetoDB2Compressionwhichreducesstorageexpense&improvednetworkbandwidth;lesshardwareinfrastructureforHA&DR,etc)–Simplifiedoperations/managementforSAPonDB2(simplifiedSAPadmin/operations&reducedmgttime/resourcethruSAPDBACockpit,reducedbackup/archivalexpenseswithDB2Compression,lowerrecoverytime/expenses,etc)ITGReportsonTCOforSAP(DB2vsOracle&DB2vsSQLServer):Cost/BenefitBusinesscaseforSAPEnterpriseMigrationNewInstallation:DB2is47%lessthanSQLServerMigrationfromSQLServertoDB2:DB2is46%lessthanSQLServer(Includedatabaselicense,transitioncosts~dataconversion/migration,retraining)NewInstallation:DB2is38%lessthanOracleMigrationfromOracletoDB2:DB2is34%lessthanOracle(Includedatabaselicense,transitioncosts~dataconversion/migration,retraining)Value:BetterReturns-on-Investment(ROI)withDB2•Proof-points:–Siemens:achieveditsROIwithin1styearofmigrationtoDB2–SAPIT:‘…contributingtoabetter-than-forecastROI…’–CocaCola:achievedROIof205%withabreakevenin8months•ValueforCustomer:–BetterROI=enhancingtheshareholders’value–BetterROIachievedby:•BetterperformancethroughputatlowerTCO–DB2isextractingmorevalueperunitofinvestmentfromthehardwareinfrastructurewhileloweringthecostperunitofinvestmentdeployedAgenda•ExperiencefromaHappyDB2/SAPReferenceCustomer•WhyshouldyouuseDB2inyourSAPinfrastructure•SomekeyDB2TechnologicalDifferentiatorsforSAPSolutions•HowtomigratefromOracletoDB2•MythsregardingmigratingfromOracletoDB2•LearningsfrommoreSAPCustomers:MigratingfromOracletoDB2SAPonDB2KeyTechnologyDifferentiators•SelectedSAPonDB2differentiatorscoveredinthistalk:–DB2_WORKLOAD=SAP–DB2Compression–SAPonDB2virtualtables–DB2IntegratedHA–DB2DatabasePartitioningFeature–DB2MultidimensionalClustering–DB2AutomaticMaintenance–DBACockpit–……•Thisisnotanexhaustivelistandonlyintendedtoprovideanoverview.YoucanfindmoreinformationaboutSAPonDB2inSDN.DB2_WORKLOAD=SAP–One-stopoutoftheboxDB2configuration•TailoredsettingfortheuseoftherespectiveDB2levelwithSAPsoftware•CoversallDB2settingsrequiredtorunoptimallywithSAPapplications–Asafebetforconfiguration.NoreadingofSAPnotesormanualupdaterequired–TestedduringISIScertification–CheckedbySAPkernelandSAPtoolsatconnecttime•db2set–all|grepDB2_WORKLOAD•[i]DB2_WORKLOAD=SAP•[i]DB2_TRUST_MDC_BLOCK_FULL_HINT=YES[DB2_WORKLOAD]•[i]DB2_ATS_ENABLE=YES[DB2_WORKLOAD]•[i]DB2_RESTRICT_DDF=YES[DB2_WORKL