Download the sap hana dynamic tiering software

Installation Guide | PUBLIC

Content

4.1 Landscape Storage Architecture. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11

5 SAP HANA Dynamic Tiering Hardware and Operating System Requirements . . . . . . . . . . . . . . 14

7.1 Download the SAP HANA Dynamic Tiering Software. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17

7.2 Prepare the SAP HANA Dynamic Tiering Software. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18

Installing with a Console Interface (Dedicated). . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 29

Migrate a Dedicated Host Deployment to a Same Host Deployment. . . . . . . . . . . . . . . . . . . . . . 37

Configure CPU Affinity for Dynamic Tiering Processes. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .46

Migrating a Same Host Deployment. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .47

How Large Should Extended Store Be?. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 54

Modify Delta on Extended Storage. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .54

Configure Resources Using SAP HANA Studio. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 58 Configure Resources Using SQL. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 58 9.4 Verify that the Dynamic Tiering Service is Installed and Running. . . . . . . . . . . . . . . . . . . . . . . . . . . 59 Verify Using HANA Studio. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .59 Verify Using the Dynamic Tiering Host. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 59 9.5 License Dynamic Tiering. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 60

10 Updating SAP HANA Dynamic Tiering. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .61 10.1 Supported Update Scenarios. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .62 10.2 Regular Update. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 64 Updating with the Graphical Interface. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 64 Updating with a Console Interface. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 69 10.3 Optimized Update. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 74 Phase 1 – Prepare an Update Using a Graphical Interface. . . . . . . . . . . . . . . . . . . . . . . . . . . . . .75 Phase 1 – Prepare an Update Using a Console Interface. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 77 Phase 2 – Resume an Update Using a Graphical Interface. . . . . . . . . . . . . . . . . . . . . . . . . . . . . 79 Phase 2 – Resume an Update Using a Console Interface. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 81 10.4 Post-Update Tasks. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 82 Perform a Full Data Backup. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .83 Rebuild Indexes. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 83 Enhanced Query Performance . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 84 10.5 Migrate to New Hardware. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 85

13.5 Uninstall Dynamic Tiering Using Graphical Interface. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .97

13.6 Uninstall Dynamic Tiering Using a Console Interface. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 98

14.3 Installation of Dynamic Tiering Fails on an IBM Power Systems Platform. . . . . . . . . . . . . . . . . . . . .102

14.4 Generating New SystemPKI Certificates to Use SHA-2. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 103

SAP HANA Dynamic Tiering: Installation and Update Guide

2 When to Use This Guide

When dynamic tiering is part of the SAP HANA landscape, some SAP HANA functionality stops working or

When dynamic tiering is installed, you cannot convert SAP HANA from low to high isolation.

• Although you cannot perform following when dynamic tiering is installed, theycan be accomplished via a

• Change the SID or instance number of an SAP HANA system.

When dynamic tiering is installed, the following functionality is available, but with some functional restrictions:

SAP HANA Dynamic Tiering: Installation and Update Guide

4 SAP HANA Dynamic Tiering Architecture

The SAP HANA host and SAP HANA dynamic tiering worker communicate over a secure, encrypted internal connection. For network and communication security information, see the SAP HANA Security Guide.

SAP HANA dynamic tiering only supports low tenant isolation. Any attempt to provision the dynamic tiering service (esserver) to a tenant database with high-level tenant isolation fails. If you raise the isolation level to high for an existing installation, the dynamic tiering service stops working. To lower the isolation level, see Decrease the System Isolation Level in the SAP HANA Administration Guide.

Figure 1: Components of SAP HANA Dynamic Tiering - Dedicated Host Deployment

SAP HANA Dynamic Tiering: Installation and Update Guide

SAP HANA Dynamic Tiering: Installation and Update Guide

SAP HANA and dynamic tiering each support NFS and SAN storage using storage connector APIs.

If you plan to use storage connector APIs, configure the multipath.conf and global.ini files before installation.

Configuration 1: SAP HANA and Dynamic Tiering Each Use Storage

Connector APIs

• You need a shared file system (for example, /HANA/shared) for installation.

• The backup directories for both SAP HANA and dynamic tiering reside on a shared file system, allowing

• The SAP HANA worker and standby hosts have access to the HANA data and log volumes through NFS.

• The dynamic tiering worker and standby hosts have access to the dynamic tiering data volume (data_es)

SAP HANA Dynamic Tiering: Installation and Update Guide

Related Information

Ensure that you are installing the version of dynamic tiering that is compatible with your version of SAP HANA. For a list of compatible versions, see SAP Note – SAP HANA Dynamic Tiering 2.0 SP 04 Release Note.

SAP HANA Dynamic Tiering Host Operating System Requirements

Dynamic Tiering Installation Workflow [page 15]
The workflow to install SAP HANA dynamic tiering on an existing SAP HANA system consists of four steps.

Applying the Dynamic Tiering License Key [page 16]
SAP HANA dynamic tiering requires its own license, separate from the SAP HANA license.

*You only need to provision the SAP HANA dynamic tiering service in the following scenarios:

• The single tenant instance previously contained additional tenants.• The SAP HANA instance contains multiple tenant databases.

Consistent with SAP HANA, a new installation of dynamic tiering includes a temporary license allowing dynamic tiering to run without a permanent license for 90 days. After 90 days, a permanent license is required. If a temporary license expires without a permanent license being installed, dynamic tiering ceases to function until you install a valid permanent license. If an installed permanent license expires, a temporary license is issued, valid for 28 days.

Depending on whether SAP HANA and dynamic tiering were installed together or at different times, the expiration dates of the individual temporary licenses may differ.

7 Preinstallation Tasks

Complete these tasks before starting the installation process.

7.1 Download the SAP HANA Dynamic Tiering Software

The SAP HANA dynamic tiering installation and update packages are available as individual packages on the SAP Software Download Center (https://support.sap.com/software.html).

SAP HANA Dynamic Tiering: Installation and Update Guide

Related Information

Some installation and update packages (*.SAR files) for SAP HANA dynamic tiering require the SAPCAR

archiving tool to unpack; download it from the SAP Software Download Center.

Related Information

Download the SAP HANA Dynamic Tiering Software [page 17]

SAP HANA Cockpit is not installed as part of a core installation.

It still uses the SAP HANA database lifecycle management tool hdblcm(gui), but requires a separate downloadable package, and cannot be installed in conjunction with other packages, such as SAP HANA and dynamic tiering.

Install, update, or configure SAP HANA dynamic tiering using the SAP HANA platform lifecycle management tool, for a dedicated or same host deployment, using either a graphical or console interface.

You can install SAP HANA and SAP HANA dynamic tiering each on a dedicated server (referred to as a dedicated host deployment) or on the same server (referred to as a same host deployment).

• Installation of SAP HANA dynamic tiering on an existing SAP HANA system• Addition of SAP HANA dynamic tiering worker and standby (optional) hosts• Creation of extended storage

In this section:

For a dedicated host deployment, use the SAP HANA platform lifecycle management tool to install SAP HANA and dynamic tiering, and add or remove the dynamic tiering hosts.

SAP HANA Dynamic Tiering: Installation and Update Guide