0300 u03 bw system copy orange

BW ORANGE SystemcopyRoland Kramer Product/Solution Management BW/BI/In-MemoryOctober 2011 (Version 2.0)

© 2011 SAP AG. All rights reserved. 2Internal

Main Landing Page – „one stop“http://www.sdn.sap.com/irj/sdn/edw-ops

http://www.sdn.sap.com/irj/sdn/edw-ops


Notes to consider, HANA sizing, TASK MANAGER, etc.

• Note 1600929 - SAP BW powered by SAP inMemory DB – Information

• Note 1514966 - SAP HANA 1.0: Sizing SAP In-Memory Database• Note 1637145 - SAP BW on HANA: Sizing SAP In-Memory Database

• Note 1589175 - System Copy: Task Content for Task Manager• Note 1589145 - Task Manager for Technical Configuration

• Installation/Operational Guides: http://service.sap.com/hana• TQM/SQL/further Information: http://help.sap.com/hana

http://service.sap.com/hana


System Copy Use Cases

System copywith SAPInst / DB-Tools

SAP NetWeaver ABAP 7.0 or higher

Execution of post copy activities with Post Copy Automation

Execution of post copy activities

SAP NetWeaver ABAP 7.0 or higher

Export und Import of tables with Post Copy Automation

ExportSystem Copy with SAPinst / DB-Tools

Import

System Copy Refresh

Initial System Copy


Option1: System Copy with BW ORANGE new System direct creation (“risky side”)

TransportTransport

TransportTransportBW

ERP

ConsolidationR3Q

ProductionR3P

DevelopmentR3D

DevelopmentBWD

ConsolidationBWQ

ProductionBWP

ALE / RFCALE / RFC ALE / RFC

ORANGEBWx

ALE / RFC

BW 7.30SP05

BW 7.30SP05

copy to “ORANGE” (7.30)heterogeneous systemcopy

UC migration included


Option2: System Copy with BW ORANGE new System creation via Production copy (“safe side”)

Transport

TransportBW

ERP

ProductionBWP

ProductionR3P

ALE / RFC

ORANGEBWx

ALE / RFC

ProductionBWC

copy of Production (7.x)homogeneous systemcopyUpgrade NetWeaver 7.30

BW 7.30SP05

BW 7.30SP05

BW 3.57.0/7.0x7.30

copy to “ORANGE” (7.30)heterogeneous systemcopy

UC migration included


System Copy with HANA DB: consider complete Landscape copy or mixed DB environment

TransportTransport

BW

DevelopmentBWD

ProductionBWP

ConsolidationBWQ

TransportTransport

DevelopmentBHD

ProductionBHP

ConsolidationBHQ

BWwith HANA


Milestones of the System copy/UC Migration (771209)

Restore BW and Source Systems (RSA1)

Install DI with SAPInst based on Abap Export

Install CI with SAPInst

Create Abap Export with SAPInst

BDLS on BW and Source System

Post checks (RS_BW_POST_MIGRATION )

Migrate ODS/DTP-Objects (RSSGPCLA)

Pre checks (SMIGR_CREATE_DDL )

Follow up Actions in the Target System

UC Migration

UC Migration

Migrate DSO/InfoCubeIn-Memory optimized


Checklist - prior to the import to SAP In-Memory DB

System copy pre steps• Check binaries for SAPInst, R3*, import/export tools• Check Version of the source DB, and update if needed, eg. SQL2008R2 has new features• Check for DB specific activities, eg. Report MSSCOMPRESS for MSSQL2008R2• Run report RSUPGRSUM, if needed use „repair InfoObjects“ to repair Objects from RSD1• Check DBACOCKPIT for missing indexes and run SAP_INFOCUBE_INDEXES_REPAIR• Check SE14 for unfinished table conversion• Run Report SAP_DROP_TMPTABLES and RSAN_UT_RESULT_DROP_RESULTS

(interim) to delete all kind of BW specific temporary tables beforehand.• Check ODS objects in RSA1 for correct activation• Optionally: stop any deamon‘s in transaction RSRDA• Run Report SMIGR_CREATE_DDL before export (pre SP5 version needed), check as well

for the latest correction prior to it´s execution.• Choose target database „SAP In-Memory DB“, unicode and the target directory

• Run option export from SAPInst from transfer system• Choose target database „HDB“ (in-Memory DB)• Choose „little endian“ (for OS linux) and unicode option


BW system copy post steps

System copy post steps• Run BTCTRNS1 to prevent the unwanted start of batch job’s• BDLS (check for corrections) Test Run and Productive run• RSA1 source systems BW system restore

• run in background• check for RFC GTADIR_SERVER and Note 1586248 remove RFC connection• run RSAR_PSA_NEWDS_MAPPING_CHECK in advance• check the partner profiles in WE20 for the systems, and check IDoc ports in WE21 for the systems.

• RSSGPCLA reset programs for ODS and DTP• Report RS_BW_POST_MIGRATION (without P_SAVER step)• Function module RSA_LOGICAL_SYSTEM_BIW_GET• Report RSBKDTPREPAIR (input parameter?)• Report RSDG_TRFN_ACTIVATE (object status = ACT)• Report RUTMSJOB use the transaction above to solve inconsistencies• Optional: Report RSUPGRCHECK (check for inactive objects overall)


ODS/DTP migration after BW SystemcopyTransaction RSSGPCLA (not ORANGE related)


Optional: Run Report RSUPGRCHECK for Object concistency overall


POST COPY AUTOMATION 3.0 System Refresh and Initial System Copy

Technical Coverage Initial System Copy

Cleanup of ABAP Basis Tables

Cleanup of Batch Jobs

Cleanup of DBA Cockpit Configuration

Cleanup of RFC In / Outbound Queue

Cleanup of SAPConnect Data

Cleanup of Spool Requests

Cleanup of TRUST Manager Config

Configuration of Standard Jobs

Scheduling in DBA Planning Calendar

Configuration of MSSQL

Configuration of Licenses

Configuration of Logon Groups

Configuration of System Profiles

Configuration of Operation Modes

Configuration of Secure Store

Configuration of Spool, TMS

Schedule of job RDDIMPDP

System Refresh

Initial Consistency Check System Profiles

Check for BW system RFC Connections

ALE Configuration Inbound qRFC Configuration

ALE Customizing tRFC and Outbound qRFC Config

Archiving SAPConnect Data Cleanup

Batch Jobs Configuration SLD Data Supplier Configuration

Batch Server Groups SCOT Configuration

CCMS Configuration SICF Configuration

CCMS History SLD Access Data Configuration

Customer defined Tables Update Program Server Groups

DBACOCKPIT Configuration STRUST Configuration

Operating System Commands Last Transport Request Number

Cross-Client File Names/Paths TMS QA Configuration

Licenses Users (all, selected clients, exclude)

Logon Groups Development Versions

Operation Modes Virus Scan Definitions

Printer Config / Spool Cleanup Web Service Configuration


Task Manager FeaturesTask Manager Features

Customizing of SAP preCustomizing of SAP pre--delivered Task Listsdelivered Task Lists

Creation of customer specific Task ListsCreation of customer specific Task Lists

Variant maintenance of Task ListsVariant maintenance of Task Lists

Check mode for all TasksCheck mode for all Tasks

Resume of Task Lists in case of errorResume of Task Lists in case of error

Interrupt of Task List executionInterrupt of Task List execution

Local/Local/decentraldecentral executionexecution

Execution in Dialog/BackgroundExecution in Dialog/Background

Parallel execution on multiple systemsParallel execution on multiple systems

POST COPY AUTOMATION 3.0 Task Manager Features


BW system copy post In-Memory migration steps

for the visualization of the transaction RSMIGRHANADB you can add the following RSADMIN parameter ENBL_HDB_MIGR_DSO = XRun ONLY for selected Cubes and DSOs


In-Memory Optimized DataStore ObjectsUsing In-Memory Computing Technology

Replaced ABAP modules for request activation and rollback by HANA DB implementation

No data processing in ABAP after loading a request into the activation queue

Using in-memory optimized data structures for faster access

No roundtrips to application server needed

Optimization is transparent for the user

HANA DB Implementation


In-Memory Optimized DataStore ObjectsOverview and Design

Delta calculation completely integrated in InMemDB – no data processing in ABAP

Using in-memory optimized data structures for faster access

No roundtrips to application server needed

History Index(column based)

Activation triggered by BW, performed

by InMemDB

Main Index(column based)Delta Index

(column based)

View View


In-Memory Optimized DataStore ObjectsMigration Options in Discussion

After upgrading to BW 7.30 SP5 all DataStore objects remain unchangedIn a tool supported post processing step standard DataStore objects can be selected and converted into in-memory optimized DataStore objectsDataflow doesn‘t need to be adjusted

During conversion DataStore objects are not available for reporting / staging

Active data gets converted, history in change log gets lost

Fast conversion stepDelta requests to be updated to data targets before migrationRequests activated before migration cannot be rolled back

Option 1 - Simple Migration

Active data gets converted, history will be restored out of old change log data

No functional restrictions (rollback and delta update for old requests supported)Complex algorithm with high database load (active data gets rolled back and re-activated)

Option 2 – Full Migration


HANA optimized InfoCube Design in BW

Physical schema of BW InfoCube tailored towards traditional RDBMS

Benefits:Fast data loads (no DIMIDs) up to 80% time reductionDimensions not physically present simpler modeling and faster structural changesAll processes, all Queries and MultiProviders can remain unchanged

HANA can work with “flat” structures and doesn’t need E- and F-fact tables!

FactsD

D

MD MD

MD MD

Migration / NewFacts

MD

MD

MD

MD

F FE


Standard InfoCube with Migration Option

FactsD

D

MD MD

MD MD

F E


In-Memory Optimized InfoCube

Facts

MD

MD

MD

MD

F


Migration Steps and Log Overview

Create temporary fact table with “flat” structure Z0<InfoCube>Read data out of the original fact tables dissolving the starschema and save data in temporary fact tableRename package dimension database table TP<InfoCube>Rename validity table (in case inventory mgmt InfoCube) TL<InfoCube>Empty the InfoCube tablesSet InfoCube subtype to “flat”Activate the InfoCube - As it is empty the structures and their DDIC description can be adjustedDelete Fact DB-table and rename the temporary oneDelete PDIM and rename the temporary oneDelete validity table and rename the temporary oneDelete temporary DDIC objectsCreate logical index

(This can be done with transaction RSMIGRHANADB)

Thank You!

Contact information:

Roland KramerPM BW/In-Memory


No part of this publication may be reproduced or transmitted in any form or for any purpose without the express permission of SAP AG. The information contained herein may be changed without prior notice.Some software products marketed by SAP AG and its distributors contain proprietary software components of other software vendors.Microsoft, Windows, Excel, Outlook, and PowerPoint are registered trademarks of Microsoft Corporation. IBM, DB2, DB2 Universal Database, System i, System i5, System p, System p5, System x, System z, System z10, System z9, z10, z9, iSeries, pSeries, xSeries, zSeries, eServer, z/VM, z/OS, i5/OS, S/390, OS/390, OS/400, AS/400, S/390 Parallel Enterprise Server, PowerVM, Power Architecture, POWER6+, POWER6, POWER5+, POWER5, POWER, OpenPower, PowerPC, BatchPipes, BladeCenter, System Storage, GPFS, HACMP, RETAIN, DB2 Connect, RACF, Redbooks, OS/2, Parallel Sysplex, MVS/ESA, AIX, Intelligent Miner, WebSphere, Netfinity, Tivoli and Informix are trademarks or registered trademarks of IBM Corporation.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.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.Citrix, ICA, Program Neighborhood, MetaFrame, WinFrame, VideoFrame, and MultiWin are trademarks or registered trademarks of Citrix Systems, Inc.HTML, XML, XHTML and W3C are trademarks or registered trademarks of W3C®, World Wide Web Consortium, Massachusetts Institute of Technology.

© 2011 SAP AG. All rights reserved.

SAP, ERP, SAP NetWeaver, Duet, PartnerEdge, 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 AG in Germany and other countries.

Business Objects and the Business Objects logo, BusinessObjects, Crystal Reports, Crystal Decisions, Web Intelligence, Xcelsius, and other Business Objects products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of Business Objects Software Ltd. Business Objects is an SAP company.

Sybase and Adaptive Server, iAnywhere, Sybase 365, SQL Anywhere, and other Sybase products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of Sybase, Inc. Sybase is an SAP company.

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.

The information in this document is proprietary to SAP. No part of this document may be reproduced, copied, or transmitted in any form or for any purpose without the express prior written permission of SAP AG.

0300 u03 bw system copy orange

Documents