Performance Techniques for Unicode Conversion of Single ...

1 PerformanceTechniques for UnicodeConversion of SingleCode Page SystemsRichard Bernat, Chevron CorporationTheodore Duong, Chevron Corporation SAP TechEd 05 / Session ID / SPC204 Learning ObjectivesAs a result of this workshop, you willbe able to: Select an appropriate environment strategy for your project Understand the Unicode Conversion process Use SAP tools and Techniques for high performanceconversion to reduce downtime Use Oracle features to enable continuous processing due tospace consumptionChevron CorporationSAP LandscapeConversionPlanningEnvironment StrategyProcessTips and TricksQ & AAgendaAgenda SAP TechEd 05 / Session ID / SPC204 One of the world s largest global energy companiesActive in more than 180 countries47,000 employees worldwide$150 billion in revenue for 2004 Chevron About Our CompanyChevron CorporationSAP LandscapeConversionPlanningEnvironment StrategyProcessTips and TricksQ & AAgendaAgenda SAP TechEd 05 / Session ID / SPC204 SAP Landscape HPUX PA-RISC &IA64 Hitachi 7 Productionenvironments 500 GB - 4TB 40+ Environments Oracle + SAP TechEd 05 / Session ID / Landscape Prior to The Conversion HPUX PA-RISC SAP Enterprise 5 App.

2 Servers 2 ITS servers 500 GB DB Timesheet access via ESS and Portal 24,000 users SAP TechEd 05 / Session ID / Landscape After The Conversion HPUX IA64 SAP R/3 Enterprise Unicode 3 Application servers 2 ITS servers 450 GB DB Timesheet access via ESS and Portal 24,000 usersChevron CorporationSAP LandscapeConversionPlanningEnvironment StrategyProcessTips and TricksQ & AAgendaAgenda SAP TechEd 05 / Session ID / SPC204 Conversion Planning - Documentation Unicode Conversion Guide SAP Installation Guide System Copy Guide Migration Monitor Guide Read OSS Notes SAP TechEd 05 / Session ID / SPC204 Conversion Planning - Hardware Change platform to Itanium Need OS skills to patch and certify new platform making existing scripts work on new platform While HR is relatively small, need to make sure tohave enough disk space for export Given a 24 hour window for data movement downtime SAP TechEd 05 / Session ID / SPC204 Conversion Planning - Downtime Understand what customers are willing to endure foroutage duration Downtime started on Friday Evening Go/No-Go decision on Sunday MorningChevron CorporationSAP LandscapeConversionPlanningEnvironment StrategyProcessTips and TricksQ & AAgendaAgenda SAP TechEd 05 / Session ID / SPC204 Conversion Environment Strategy All prior experience based on upgrade strategy Identified that Unicode Conversion doesNOTneed touse the same strategy as an upgrade Dual support stack not needed, although may bepreferred ( it s up to you) Key learning development environment does notneed to be unicoded immediately Fix ABAP code prior to converting an environment.

3 SAP TechEd 05 / Session ID / SPC204 Conversion Environment Strategy Continued Chose to apply ABAP Unicode changes via transportbundles after Conversion Needed a separate environment to transport and testABAP Unicode ( can not use existing Staging / QA) Sand box for initial learning Even though this was for technical learning, users wanted to seeit. SAP TechEd 05 / Session ID / Itanium / Unicode Environment Strategy / TimelineChevron CorporationSAP LandscapeConversionPlanningEnvironment StrategyProcessTips and TricksQ & AAgendaAgenda SAP TechEd 05 / Session ID / SPC204 Conversion Process Have a rock solid detailed plan Understand the environment architecture Create sand box for learning Apply OSS notes Far fewer OSS notes to apply than SAP R/3 EnterpriseUpgrade SAP TechEd 05 / Session ID / SPC204 Conversion Process - Know Your FilesImport/Export package logsLOGM igration Monitor Between Exportand Import ProcessesSGNDDL Statement Template forObject Size of file ( Extension)Type of file ( Extension)

4 TaskTSKC ommandCMDT able of ContentTOCS tructure/Table DefinitionSTRI nitial extent for tablesEXT SAP TechEd 05 / Session ID / SPC204 Conversion Process - Create DB/Central Inst. Create a skeleton DB with locally managed tablespace(LMTS) and automatic segment space management(ASSM) Improve Performance Easier to manage disk space Run SAPINST to create central instance Since the DB was created earlier (to fit our standards), chose MCOD tobypass DB creation Extract R/3 Kernel, but not Oracle Client Client already installed in our Shared Oracle_Home May need to run CROCLLNK script from OSS Note # s 521230,539922 SAP TechEd 05 / Session ID / SPC204 Conversion Process - Prepare Export/Import Run INSTALL executable non- Unicode version forexport After initial media extract, run sapinst version if youneed to restart Run INSTALL executable Unicode version for import Get familiar with file Change ORACLE_HOME references Acknowledge steps that have been performed Change status from ERROR to OK ( ie.)

5 After Migration Monitor) Terminate the export/import when R3load is running SAP TechEd 05 / Session ID / SPC204 Conversion Process Setup Migration Monitor Move your split table files into place. Wait for scheduled downtime Bring down SAP R/3 Take the last backup Start Migration Monitor Have plenty of snacks availableChevron CorporationSAP LandscapeConversionPlanningEnvironment StrategyProcessTips and TricksQ & AAgendaAgenda SAP TechEd 05 / Session ID / SPC204 Configure Resumable Query for SAP SchemaCreate a logon trigger to set resumable when SAP WP sstart or connections are made to SAPR3 (R3load)CREATE OR REPLACE TRIGGER logon_set_resumableAFTER LOGONON immediate 'alter session enable resumabletimeout &&TIMEOUT_VAL';END;The TIMEOUT_VAL is one of your choose 7200 (seconds) in PRD and 1800 in all others. SAP TechEd 05 / Session ID / SPC204 Enable Autoextend on your tablespace datafilesSet all your datafiles to autoextendSELECT 'ALTER DATABASE DATAFILE '||file_id||' AUTOEXTENDON NEXT ${EXTNDSIZE}M MAXSIZE ${MAXDFSIZE}M;'FROM dba_data_files a, dba_tablespaces bWHERE = NOT IN ('UNDO','TEMPORARY')AND NOT IN('PSAPTEMP','PSAPROLL','SYS_AUDIT');Th is was used in conjunction with a script that periodically checksto add disk space from a pool and extends file PSAPTEMP separately.

6 With Resumable query, you havetime to analyze usage and extend if needed. SAP TechEd 05 / Session ID / SPC204 Favorite monitoring queries tablespace format a10;column osuser format a10;column machine format a10;column bytes format 999,999,999,990break on tablespace skip 1compute sum of bytes on tablespaceset linesize 180 SELECT , #, #, , *8192 as bytes, , #, , , , , v$session a,v$sort_usage bWHERE = BY , #, #, ; SAP TechEd 05 / Session ID / SPC204 Favorite monitoring queries pagesize 60set linesize 130set long 1000column sql_text format A50 word_wrappedselect , , NumExec, BuffGets,( ) GetsPer, ,rpad( ,8) usernm, v$session a, v$sqlarea bwhere = = <> 'SYS'and > 0and > 0and != 'INACTIVE'order by buffer_gets; SAP TechEd 05 / Session ID / SPC204 Tips and Tricks - Continued (MigrationMonitor) Use mounted file system - nfs vs.

7 Ftp Saves on space and no need to enable ftp (security risk) Use explicit export order to force large packages earlier and getthem importing (and indexing) (OrderBy=<filename>) ExportNumJobs=16 ( on an 8-CPU system) Restarting export/import process Know your tools R3load and status( ) Know how to reset an export/import package (LOG, TSK, files) SAP TechEd 05 / Session ID / SPC204 Tips & Tricks - Continued Splitting large tables into multiple packages Very worthwhile, need to know your tables & indexes to determinewhere/how to split ( where clause generation). Query to define boundaries for split table where clause select min(DOCNUM), max(DOCNUM), pcntile from (selectDOCNUM, ntile(10) over (order by DOCNUM) pcntile where mandt='002')group by pcntile; Where clause bypasses export sort!!! Where clause for export/import MUST be identical ( including whitespace) Custom indexes need to be rebuilt (if not in SAP DD) Great opportunity to upgrade & reduce hardware The move to IA64 and faster CPU s yielded a reduction in app serversfrom 5 to 3.

8 SAP TechEd 05 / Session ID / SPC204 Summary Unicode is not to be don t believe all the myth/horror! Outage can be reduced using parallel/concurrent processingtechniques Oracle resumable query is a key to a successful migration It s vital to have in-depth knowledge of your files and status forrestarting specific packages/phases practice makes perfect! Technical downtime for data movement (R3load/MigMon) 450GB instance Export time:4h:40m, Import time:7h:45m Last hour of import was just one package Concurrent Export and Import using MigMon SAP TechEd 05 / Session ID / SPC204 Further Information Public Americas SAP Users Group (ASUG) Related Workshops/Lectures at SAP TechEd 05 SPC204 Performance Techniques for Unicode Conversion of Single Code PageSystemsTue, 4:00 5:00 , 253B, Thu, 5:15 6:15 , 258 BSPC202, Conversion of SAP Systems to UnicodeWed, 1:45 3:45 , 258C, Fri, 8:00 10:00 , 258 ASPC250 making programs Unicode EnabledWed, 10:30 12:30 , 103, Thu, 1:45 3:45 , 103 SPC251 Unicode Interfaces Data Exchange Between Unicode and non-UnicodeSystemsWed, 4:15 6:15 , 103, Thu, 4:15 6.

9 15 , 103 SAP TechEd 05 / Session ID / SPC204Q&AQuestions? SAP TechEd 05 / Session ID / SPC204 Please complete your session courteous deposit your trash,and do not take the handouts for the following kind to You ! SAP TechEd 05 / Session ID / SPC204 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 informationcontained 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, Outlook, and PowerPoint are registered trademarks of Microsoft Corporation. IBM, DB2, DB2 Universal Database, OS/2, Parallel Sysplex, MVS/ESA, AIX, S/390, AS/400, OS/390, OS/400, iSeries, pSeries, xSeries, zSeries, z/OS, AFP,Intelligent Miner, WebSphere, Netfinity, Tivoli, and Informix are trademarks or registered trademarks of IBM Corporation in the United States and/or othercountries.

10 Oracle is a registered trademark of Oracle Corporation. 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. Java is a registered trademark of Sun Microsystems, Inc. JavaScript is a registered trademark of Sun Microsystems, Inc., used under license for technology invented and implemented by Netscape. MaxDB is a trademark of MySQL AB, Sweden. SAP, R/3, mySAP, , xApps, xApp, SAP NetWeaver and other SAP products and services mentioned herein as well as their respective logos aretrademarks or registered trademarks of SAP AG in Germany and in several other countries all over the world.