CUSTOMER SAP HANA Data Warehousing Foundation 1.0 Document Version: 1.0 – 2015-03-06 SAP HANA Data Warehousing Foundation - Data Distribution Optimizer Installation Guide Content 1 Introduction. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3 1.1 About the Data Distribution Optimizer. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3 1.2 Overview of Data Distribution Optimizer Architecture. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4 1.3 Supported Browsers. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4 1.4 Software Download. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 2 Planning and Preparation. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6 2.1 Verify Installation of Delivery Units. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6 3 Installing Data Distribution Optimizer. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8 4 Configuring Data Distribution Optimizer. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9 4.1 Configure SAP HANA System Properties. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9 4.2 Configure Database Traces. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .10 4.3 User Authorization. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11 4.4 Create and Authorize Users. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13 4.5 Configure Scheduling Properties. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14 4.6 Check Configuration. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .15 2 CUSTOMER © 2015 SAP SE or an SAP affiliate company. All rights reserved. SAP HANA Data Warehousing Foundation - Data Distribution Optimizer Installation Guide Content 1 Introduction This installation guide describes how to install the SAP HANA Data Warehousing Foundation - Data Distribution Optimizer (Data Distribution Optimizer). The Data Distribution Optimizer is delivered with delivery units (DU). A DU is used to deliver one or more software components from SAP (or a partner) to a customer. A DU is contained in a delivery unit archive (*.tgz file) for distribution using export/import and deployment. For more information on delivery units, see the SAP HANA Master Guide. Related Information SAP HANA Master Guide on http://service.sap.com/hana 21, 2014, Revision 82) 1.1 -> SAP HANA SPS 08 Documentation (ZIP) - (August About the Data Distribution Optimizer The Data Distribution Optimizer is part of SAP HANA Data Warehousing Foundation, which provides packaged tools for large scale SAP HANA use cases to support data management and distribution within a SAP HANA landscape more efficiently. With the Data Distribution Optimizer, SAP HANA Data Warehousing Foundation provides an SAP HANA XS Engine based tool to plan, adjust and analyze landscape redistribution. The main purpose of the Data Distribution Optimizer is to help the SAP HANA administrator to manage the distribution of tables and optimize the allocation of SAP HANA memory in a SAP HANA scale-out landscape (multiple-host system). The redistribution algorithm has to reflect the relationship between single tables as well as constraints given by the landscape itself, such as allocation limits and server roles (e.g. master or slave). The end-to-end process for distributing data consists of the following main steps: 1. Getting a system landscape overview 2. Configuring the redistribution of table partitions 3. Comparing redistribution plans with current distribution and executing the redistribution when the requirements are met SAP HANA Data Warehousing Foundation - Data Distribution Optimizer Installation Guide Introduction CUSTOMER © 2015 SAP SE or an SAP affiliate company. All rights reserved. 3 1.2 Overview of Data Distribution Optimizer Architecture Data Distribution Optimizer is composed of the components shown in the graphic below. The Data Distribution Optimizer user interfaces are based on SAPUI5 technology and run in a Web browser. The SAP HANA Data Warehousing Foundation Core component (HCO_HDM) provides base services, such as scheduling, that can be used by any of the SAP HANA Data Warehousing Foundation tools. The SAP HANA Data Warehousing Foundation Data Distribution Optimizer component (HCO_HDM_DDO) contains Data Distribution Optimizer specific logic, such as the logic for generating redistribution plans. The SAP HANA Core Distribtuion Services contain modules that SAP HANA Data Warehousing Foundation calls in the SAP HANA core, such as database procedures REORG_GENERATE and REORG_EXECUTE. 1.3 Supported Browsers Data Distribtion Optimizer is based on SAPUI5 1.22.4. For an overview of the supported browsers, see the Product Availability Matrix for SAP HANA Data Warehousing Foundation 1.0. 4 CUSTOMER © 2015 SAP SE or an SAP affiliate company. All rights reserved. SAP HANA Data Warehousing Foundation - Data Distribution Optimizer Installation Guide Introduction Related Information SAP HANA Data Warehouse Foundation 1.0 - Planning Product Availability Matrix 1.4 Software Download In the SAP Software Download Center, you have access to the installation media for Data Distribution Optimizer. You can find the installation media under Index H SAP HANA DW FOUNDATION SAP Software Download Center Installations and Upgrades A-Z SAP HANA DW FOUNDATION 1.0 Related Information SAP Software Download Center SAP HANA Data Warehousing Foundation - Data Distribution Optimizer Installation Guide Introduction CUSTOMER © 2015 SAP SE or an SAP affiliate company. All rights reserved. 5 2 Planning and Preparation You need to perform a number of planning and preparation steps. 1. Install or upgrade to SAP HANA revision 83 or a higher SP8 revision. For more information about supporting SAP HANA versions, see SAP Note 2092669 - Release Note SAP HANA Data Warehousing Foundation. 2. Provide a user for the installation and configuration tasks, and grant the necessary roles and privileges to this user. We recommend using the SYSTEM database user for this purpose. 3. There are specific SAP HANA delivery units of type automated content that have to be installed before importing Data Distribution Optimizer delivery units. Check if these delivery units have been installed on the SAP HANA system. Related Information ● 2092669 - Release Note SAP HANA Data Warehousing Foundation ● SAP HANA Master Guide on http://service.sap.com/hana (August 21, 2014, Revision 82) -> SAP HANA SPS 08 Documentation (ZIP) - ● Section SYSTEM User in the SAP HANA Administration Guide on http://service.sap.com/hana HANA SPS 08 Documentation (ZIP) - (August 21, 2014, Revision 82) -> SAP ● Verify Installation of Delivery Units [page 6] 2.1 Verify Installation of Delivery Units Before importing Data Distribution Optimizer delivery units, you need to verify that specific delivery units (type: automated content) have already been installed. Procedure 1. In the SAP HANA Modeler, select the SAP HANA system from the Quick Launch tab. 2. Choose Delivery Units. 3. A dialog box appears. Check the availability of the following delivery units: ○ SAPUI5_1 ○ HANA_ADMIN ○ HANA_XS_IDE ○ HANA_XS_BASE 6 CUSTOMER © 2015 SAP SE or an SAP affiliate company. All rights reserved. SAP HANA Data Warehousing Foundation - Data Distribution Optimizer Installation Guide Planning and Preparation ○ HANA_IDE_CORE 4. Deploy the missing delivery units by importing the delivery unit archive files and retain the following order: Table 1: 1 SAPUI5_1.tgz 2 ZHANA_ADMIN.tgz 3 HANA_IDE_CORE.tgz 4 HANA_XS_BASE.tgz 5 HANA_XS_IDE.tgz 1. In the SAP HANA Modeler, choose 2. In the following wizard, choose File Import . SAP HANA Content Delivery Unit and choose Next. 3. Select the target system in which you want to import the files and choose Next. 4. Select Server and from the File dropdown list, choose the file to import. 5. Choose Finish to start the import. 6. Repeat the steps above for all missing delivery units and retain the specified order. SAP HANA Data Warehousing Foundation - Data Distribution Optimizer Installation Guide Planning and Preparation CUSTOMER © 2015 SAP SE or an SAP affiliate company. All rights reserved. 7 3 Installing Data Distribution Optimizer You install the Data Distribution Optimizer by importing the delivery unit archive files (*.tgz files containing the delivery units) to the SAP HANA repository. Procedure 1. Download the software from the SAP Support Portal and extract the software to your local machine. The Data Distribution Optimizer content is delivered in two delivery units (type: independent delivery units): 1. sap.com/HCO_HDM 2. sap.com/HCO_HDM_DDO 2. Manually import the .tgz files from your local machine to the SAP HANA repository and retain the order of delivery units given in step 1: 1. In the SAP HANA Modeler, choose 2. A wizard opens. Choose File Import . SAP HANA Content Delivery Unit and choose Next. 3. Select the target system in which you want to import the files and choose Next. 4. Select Client and from the File dropdown list, choose the file that you want to import. 5. Choose Finish to start the import. 8 CUSTOMER © 2015 SAP SE or an SAP affiliate company. All rights reserved. SAP HANA Data Warehousing Foundation - Data Distribution Optimizer Installation Guide Installing Data Distribution Optimizer 4 Configuring Data Distribution Optimizer After the installation has finished, you need to perform configuration tasks to set up the system for using Data Distribution Optimizer. 4.1 Configure SAP HANA System Properties You change specific system properties in the configuration file of the SAP HANA XS engine, in order to configure Data Distribution Optimizer. Prerequisites You have the system privilege INIFILE ADMIN. Procedure 1. In the Administrator editor of the SAP HANA Administration Console, choose the Configuration tab. A list of all configuration files appears. 2. Expand the xsengine.ini file and maintain the following parameters: Table 2: Section Parameter Key Parameter Value httpserver embedded true Note To activate the embedded mode, you need to restart the SAP HANA system. In the Systems view, choose Configuration and Monitoring Restart System from the context menu of the system. SAP HANA Data Warehousing Foundation - Data Distribution Optimizer Installation Guide Configuring Data Distribution Optimizer CUSTOMER © 2015 SAP SE or an SAP affiliate company. All rights reserved. 9 Section Parameter Key Parameter Value jsvm max_runtime_bytes at least 268435456 Note This is the minimum volume that is needed to run the Data Distribution Optimizer application. scheduler enabled true Trace xsa:sap.hdm info If a section and/or parameter is not available, you can add it to the xsengine.ini file. Sections can be added from the context menu of the xsengine.ini file, parameters can be added from the context menu of the section. Related Information Sections Configuring SAP HANA System Properties, and SAP HANA XS Configuration Parameters in the SAP HANA Administration Guide on http://service.sap.com/hana -> SAP HANA SPS 08 Documentation (ZIP) (August 21, 2014, Revision 82) 4.2 Configure Database Traces You can change the trace level of specific trace components, in order to configure Data Distribution Optimizer. Prerequisites ● In the Administrator editor of the SAP HANA Administration Console on the Configuration tab, the parameter with key xsa:sap.hdm and value info must have been added to the Trace section of the xsengine.ini file. ● You have been assigned the system privilege TRACE ADMIN. Procedure 1. In the Administrator editor of the SAP HANA Administration Console, choose the Trace Configuration tab. 2. Choose the Edit Configuration button for the database trace. The Trace Configuration dialog box appears. 3. Select Show all Components. 10 CUSTOMER © 2015 SAP SE or an SAP affiliate company. All rights reserved. SAP HANA Data Warehousing Foundation - Data Distribution Optimizer Installation Guide Configuring Data Distribution Optimizer 4. In the INDEXSERVER service, for the trace component landscapereorg, select INFO from the dropdown menu of the System Tracel Level column. 5. In the XSENGINE service, for the trace component xsa:sap.hdm, select INFO from the dropdown menu of the System Tracel Level column. Related Information Sections Database Trace, and Configure Traces in the SAP HANA Administration Guide on http:// service.sap.com/hana -> SAP HANA SPS 08 Documentation (ZIP) - (August 21, 2014, Revision 82) 4.3 User Authorization Every user who is required to work with Data Distribution Optimizer (DDO) must have a database user. To perform tasks in the Data Distribution Optimizer, the database user must have the required privileges. Data Distribution Optimizer is delivered with a set of roles containing the required privileges for specific tasks. The following table describes the roles for Data Distribution Optimizer: Table 3: Role Type Task sap.hdm.ddo.roles::Viewer application This role provides read-only access to view redistribution plans. It also allows you to view configurations. The role does not allow you to view all data for all tables in the Data Distribution Optimizer however, as this would require ex pansive authorizations that are not appropriate for a viewer role. The following information is not visible for the viewer role for example: ● Information on the last run will not be visible on the Home screen. ● The system landscape information will not be dis played on the System Landscape screen. ● Most of the system catalog will not be displayed on the System Landscape screen (only the SAP_HDM_DDO schema). sap.hdm.ddo.roles::Configurator application This role has to be granted to the database user who cre ates Data Distribution Optimizer configurations. It also al lows importing and exporting of plans. sap.hdm.ddo.roles::Scheduler application This role has to be granted to the database user who schedules redistribution plan execution. SAP HANA Data Warehousing Foundation - Data Distribution Optimizer Installation Guide Configuring Data Distribution Optimizer CUSTOMER © 2015 SAP SE or an SAP affiliate company. All rights reserved. 11 Role Type Task sap.hdm.ddo.roles::Planner technical/application This role has to be granted to the (technical) database user who generates the redistribution plan. While this role is primarily designed to be used as a techni cal role, it can also be used for triggering the creation of a new plan. Note This role uses the CATALOG READ and SERVICE AD MIN system privileges, which allow reading of database catalog metadata for example, and restarting the SAP HANA system. Caution should be exercised when grant ing this role. For more information, see the SAP HANA Security Guide. sap.hdm.ddo.roles::Administrator composite This role includes all application roles for Data Distribution Optimizer tasks (Viewer, Planner, Scheduler, Configura tor). sap.hdm.ddo.roles::Executor technical This role has to be granted to the technical database user who executes the redistribution plan. Note This role uses the RESOURCE ADMIN and SERVICE AD MIN system privileges, which allow management of data volumes for example, and restarting the SAP HANA sys tem. Caution should be exercised when granting this role. For more information, see the SAP HANA Security Guide. In addition to the privileges provided with this role, this user needs to have ALTER, EXECUTE and UPDATE priv ileges for all schemas that a redistribution plan should be generated for. sap.hdm.ddo.roles::Support SAP internal This role is used for support purposes. Related Information Sections Roles and User Types in the SAP HANA Security Guide on http://service.sap.com/hana SPS 08 Documentation (ZIP) - (August 21, 2014, Revision 82) 12 CUSTOMER © 2015 SAP SE or an SAP affiliate company. All rights reserved. -> SAP HANA SAP HANA Data Warehousing Foundation - Data Distribution Optimizer Installation Guide Configuring Data Distribution Optimizer 4.4 Create and Authorize Users Every user required to work with Data Distribution Optimizer (DDO) must have a database user. To perform data distribution tasks, specific roles must be granted to the database user(s) by a user administrator. Prerequisites ● You have the system privilege USER ADMIN. ● You have the privileges required to grant specific privileges and roles to the new user. For more information, see Prerequisites for Granting and Revoking Privileges and Roles in the SAP HANA Administration Guide. ● If you are integrating SAP HANA database users into a single-sign on (SSO) environment using one or more of the supported mechanisms, the necessary infrastructure must be in place and configured. Procedure 1. If the database user that you want to authorize does not exist yet, create the user: Note For generating redistribution plans (role sap.hdm.ddo.roles::Planner) and for executing redistribution plans (role sap.hdm.ddo.roles::Executor), we recommend creating technical users. 1. In the Systems view, choose Security Users . 2. From the context menu, choose New User. 2. Specify the user name and properties. 3. Authorize the user by granting the required roles. 4. Save the user by choosing the (Deploy) button. The user is created and appears in the Users folder. A new schema is also created for the user in the catalog. This schema has the same name as the user. 5. Grant the system privilege DATA ADMIN to the user with the role sap.hdm.ddo.roles::Scheduler. 6. Grant the following object privileges to the user with the role sap.hdm.ddo.roles::Executor on all database schemas that redistribution plans should be generated for. If you only want to generate redistribution plans for SAP BW on SAP HANA for example, grant the following privileges on <BW DB Schema Name> : Table 4: object privilege SQL-ALTER-Statement ALTER GRANT ALTER ON SCHEMA <DB-SCHEMA NAME> TO DDO_EXECUTOR; UPDATE GRANT UPDATE ON SCHEMA <DB-SCHEMA NAME > TO DDO_EXECUTOR; EXECUTE GRANT EXECUTE ON SCHEMA <DB-SCHEMA NAME > TO DDO_EXECUTOR; SAP HANA Data Warehousing Foundation - Data Distribution Optimizer Installation Guide Configuring Data Distribution Optimizer CUSTOMER © 2015 SAP SE or an SAP affiliate company. All rights reserved. 13 7. Save the user. Related Information Sections Prerequisites for Granting and Revoking Privileges and Roles, and Create and Authorize a User in the SAP -> SAP HANA SPS 08 Documentation (ZIP) HANA Administration Guide on http://service.sap.com/hana (August 21, 2014, Revision 82) 4.5 Configure Scheduling Properties To set up Data Distribution Optimizer, you need to perform the XS job's runtime configuration for generating and executing redistribution plans in the SAP HANA XS Administration Tool. Prerequisites You have been granted the SAP HANA user role sap.hana.xs.admin.roles::JobAdministrator. Procedure 1. Start the SAP HANA XS Administration Tool. Depending on whether the HTTP or HTTPS port has been configured, the SAP HANA XS Administration Tool is available on the SAP HANA XS Web server at one of the following URLs: ○ http://<WebServerHost>:80<SAPHANAinstance>/sap/hana/xs/admin//index.html? package=sap.hdm.ddo.xsjobs&type=xsjob ○ https://<WebServerHost>:43<SAPHANAinstance>/sap/hana/xs/admin//index.html? package=sap.hdm.ddo.xsjobs&type=xsjob 2. Edit the details for the XS jobs plan-execute.xsjob and plan-generate.xsjob. You need to specify the following details: ○ User The user account in which the job runs. For the XS job plan-execute.xsjob this is the user with role sap.hdm.ddo.roles - Executor. For the XS job plan-generate.xsjob this is the user with role sap.hdm.ddo.roles - Planner. ○ Password For security reasons, you must enter a password for the specified user. 14 CUSTOMER © 2015 SAP SE or an SAP affiliate company. All rights reserved. SAP HANA Data Warehousing Foundation - Data Distribution Optimizer Installation Guide Configuring Data Distribution Optimizer Note If you do not enter a user password, you cannot save the changes to the runtime configuration of the XS job object. ○ Start/Stop time An optional value to set the time during which the job runs. You must enter the values using the syntax used for the SAP HANA data type LocalDate and LocalTime, for example, 2013-11-05 00:30:00 (thirty minutes past midnight on the 5th of November 2013). ○ Active Enable the job schedule. Related Information Section Maintain XS Job Details in the SAP HANA Administration Guide on http://service.sap.com/hana SAP HANA SPS 08 Documentation (ZIP) - (August 21, 2014, Revision 82) 4.6 -> Check Configuration Before you start working with the Data Distribution Optimizer, you can check if the system has been configured properly. Procedure 1. Log on to the Data Distribution Optimizer with a user that has the sap.hdm.ddo.roles - Administrator role assigned. Depending on whether the HTTP or HTTPS port has been configured, the Data Distribution Optimizer is available on the SAP HANA XS Web server at one of the following URLs: ○ http://<WebServerHost>:80<SAPHANAinstance>/sap/hdm/ddo/index.html or ○ https://<WebServerHost>:43<SAPHANAinstance>/sap/hdm/ddo/index.html 2. In the header area of the screen, a button indicates if the system has been configured correctly. Click the button to view the configuration details. The following dialog box lists the configuration parameters with their statuses in the RESULT column. If the configuration is incorrect, the RESULT column displays the entry false. SAP HANA Data Warehousing Foundation - Data Distribution Optimizer Installation Guide Configuring Data Distribution Optimizer CUSTOMER © 2015 SAP SE or an SAP affiliate company. All rights reserved. 15 Important Disclaimers and Legal Information Coding Samples Any software coding and/or code lines / strings ("Code") included in this documentation are only examples and are not intended to be used in a productive system environment. The Code is only intended to better explain and visualize the syntax and phrasing rules of certain coding. SAP does not warrant the correctness and completeness of the Code given herein, and SAP shall not be liable for errors or damages caused by the usage of the Code, unless damages were caused by SAP intentionally or by SAP's gross negligence. Accessibility The information contained in the SAP documentation represents SAP's current view of accessibility criteria as of the date of publication; it is in no way intended to be a binding guideline on how to ensure accessibility of software products. SAP in particular disclaims any liability in relation to this document. This disclaimer, however, does not apply in cases of wilful misconduct or gross negligence of SAP. Furthermore, this document does not result in any direct or indirect contractual obligations of SAP. Gender-Neutral Language As far as possible, SAP documentation is gender neutral. Depending on the context, the reader is addressed directly with "you", or a gender-neutral noun (such as "sales person" or "working days") is used. If when referring to members of both sexes, however, the third-person singular cannot be avoided or a gender-neutral noun does not exist, SAP reserves the right to use the masculine form of the noun and pronoun. This is to ensure that the documentation remains comprehensible. Internet Hyperlinks The SAP documentation may contain hyperlinks to the Internet. These hyperlinks are intended to serve as a hint about where to find related information. SAP does not warrant the availability and correctness of this related information or the ability of this information to serve a particular purpose. SAP shall not be liable for any damages caused by the use of related information unless damages have been caused by SAP's gross negligence or willful misconduct. All links are categorized for transparency (see: http://help.sap.com/disclaimer). 16 CUSTOMER © 2015 SAP SE or an SAP affiliate company. All rights reserved. SAP HANA Data Warehousing Foundation - Data Distribution Optimizer Installation Guide Important Disclaimers and Legal Information SAP HANA Data Warehousing Foundation - Data Distribution Optimizer Installation Guide Important Disclaimers and Legal Information CUSTOMER © 2015 SAP SE or an SAP affiliate company. All rights reserved. 17 www.sap.com/contactsap © 2015 SAP SE or an SAP affiliate company. All rights reserved. No part of this publication may be reproduced or transmitted in any form or for any purpose without the express permission of SAP SE or an SAP affiliate company. The information contained herein may be changed without prior notice. Some software products marketed by SAP SE and its distributors contain proprietary software components of other software vendors. National product specifications may vary. These materials are provided by SAP SE or an SAP affiliate company for informational purposes only, without representation or warranty of any kind, and SAP or its affiliated companies shall not be liable for errors or omissions with respect to the materials. The only warranties for SAP or SAP affiliate company products and services are those that are set forth in the express warranty statements accompanying such products and services, if any. Nothing herein should be construed as constituting an additional warranty. SAP and other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP SE (or an SAP affiliate company) in Germany and other countries. All other product and service names mentioned are the trademarks of their respective companies. Please see http://www.sap.com/corporate-en/legal/copyright/ index.epx for additional trademark information and notices.
© Copyright 2024