Deleting Existing Permanent License Keys of SAP HANA Database

It is possible to delete all existing license keys in an SAP HANA database. This can be helpful if permanent license keys with an incorrect installation number or incorrect system number were installed on the database. Deleting existing license keys results in a lockdown of the database. The

installation of a new, valid permanent license key is required to unlock the database.

Make sure you have system privilege LICENSE ADMIN before proceeding.

Procedure

1. In the navigator, right-click the system and choose Properties.

2. Choose License.

3. Choose Delete License Key.

Alternatively, you can use SQL to delete all installed license keys by executing the following SQL command: UNSET SYSTEM LICENSE ALL

Installing Permanent Licenses for SAP HANA Database

Make sure you have system privilege LICENSE ADMIN.

Procedure

1. To request the first permanent license key for a newly installed SAP HANA database, you need to provide the hardware key and the system ID. To request a subsequent permanent license key, you have to enter the installation number and system number of your SAP HANA database. 

You can get the required information from the SAP HANA studio as follows:

a. In the navigator, right-click the system and choose Properties.

b. Choose License.

If the database is currently running on a temporary license key, the Request License Key screen area displays the hardware key and the system ID. If the database already has a valid permanent license key, the installation number and system number are displayed.

Alternatively, you can use SQL to access the required information from the M_LICENSE system view.

2. In the license key request on SAP Service Marketplace, enter all necessary information. If you have the installation number and system number, then enter them first so that the other input fields are auto-completed. When you have finished, choose Submit.

Permanent licenses are sent by e-mail attachment.

3. To install the license key, you have the following options:

a. In the Request License Key screen area in the SAP HANA studio, choose Install License Key and select the file that you received by e-mail.

b. Execute the following SQL command: SET SYSTEM LICENSE '<license file content>'.

Note: A subsequent permanent license key must have the same system-identification data as the permanent license key previously installed in the database. In particular, the system ID, hardware key, installation number, and system number must be the same. If any difference is detected in this data, the installation of the license key fails and no change is made to the license key in the database.

Checking the Current License Key of SAP HANA Database

Make sure you have system privilege LICENSE ADMIN.

1. In the navigator, right-click the system and choose Properties.

2. Choose License.

In the Current License Key screen area, the following information is displayed:

. License type

. Start date of the license key

. Expiration date of the license key

Managing Licenses of SAP HANA Databases

License keys are required to use SAP HANA databases.

The SAP HANA database supports two kinds of license keys: temporary license keys and permanent license keys. While temporary license keys are automatically installed in an SAP HANA database, permanent license keys have to be requested on the SAP Service Marketplace and applied to the individual SAP HANA database.

Temporary License Keys 

A temporary license key, which is valid for 90 days, is automatically installed with a new SAP HANA database. During this period, you should request and apply a permanent license key.

Permanent License Keys 

You can request a permanent license key on the SAP Service Marketplace at https://service.sap.com/support under Keys & Requests. Permanent license keys are valid until the predefined expiration date. Furthermore, they specify the amount of memory licensed to the target SAP HANA database. Before a permanent license key expires, you should request and apply a new permanent license key. If a permanent license key expires, a temporary license key valid for 28 days is automatically installed. During this time, you can request and install a new permanent license key.

There are two types of permanent license key available for the SAP HANA database: unenforced and enforced. If an unenforced license key is installed, the operation of the SAP HANA database is notaffected if its memory consumption exceeds the licensed amount of memory. However, if an enforced license is installed, the system is locked down when the current memory consumption of the SAP HANA database exceeds the licensed amount of memory plus some tolerance. If this happens, either the SAP HANA database needs to be restarted, or a new license key that covers the amount of memory in use needs to be installed. 

The two types of permanent license key differ from each other in the following line in the license key file:

. Unenforced license key: SWPRODUCTNAME=SAP-HANA

. Enforced license key: SWPRODUCTNAME=SAP-HANA-ENF

Note: Although enforced license keys currently only apply to SAP Business One, it is technically possible to install such a license in an SAP HANA instance with a regular, unenforced permanent license. In this case, the unenforced license key has priority. That is, if a valid unenforced license key is found, no memory consumption check is enforced. However, if one license key expires and becomes invalid, the other one, if valid, becomes the valid license key of the instance. If the latter is an enforced license key, then the memory consumption check is enforced.

In the following situations, the system goes into lockdown mode:

. The temporary license key has expired.

. You were using a temporary license key and the hardware key has changed.

. The permanent license key has expired and you did not renew it within 28 days.

. The installed license key is an enforced license key and the current memory consumption exceeds the licensed amount plus the tolerance.

. You deleted all license keys installed in your database.

. The system ID and/or hardware key of your database have changed, for example, after system copy or renaming.

In lockdown mode, no queries are possible. Only a user with the system privilege LICENSE ADMIN can connect to the database and execute license-related queries, such as, obtain previous license data, install a new license key, and delete installed license keys. Note that the database cannot be backed up if it is lockdown mode.

Monitoring SAP HANA During System Startup and Stop

The SAP HANA studio normally collects information about the system using SQL statements.

However, when the system has not yet started, no SQL connection is available. Therefore, while the system is starting up or is stopped, the SAP HANA studio collects information about the database using the sapstartsrv connection. You can view this information in the Adminstartion Editor "diagnosis mode". In this way, you analyze any problems that may occur during startup or while the system is stopped. You can also read diagnosis files even when the system is stopped.

When you open the Administration Editor for a non-running system, it opens automaically in diagnosis mode. The Administration Editor also opens automatically in diagnosis mode when you initiate the start or stop of a system.

You can manually open diagnosis mode for a system by choosing Open Diagnosis Mode from the drop-down menu of the (Administration) button.

Note : To be able to open the Administration Editor of a system in diagnosis mode, you must be able to log on using the credentials of the operating system user (user <sid>adm).

Starting and Stopping SAP HANA Systems

Starting  System 

Login as <sid>adm user

Procedure

1. In the navigator, right-click the system to be started and choose Start...

2. Optional: Specify a start timeout.

The start timeout defines how long to wait for an instance to start. If the end of the timeout period is reached, the remaining instances are not started.

3. Enter the user name and password of the operating system administrator that was defined when the system was installed (that is, <sid>adm).

Result : The system is started. A green icon appears in the system icon in the navigator.

Note: You can stop and start a system in one step by right-clicking the system and choosing Restart…

Stopping  System 

Login as <sid>adm user

Procedure

1. In the navigator, right click the system to be stopped and choose Stop...

2. Select how you want to stop the system:

. Hard

Forces all components to stop immediately.

Caution : This may lead to data loss.

. Soft

Waits for all components to stop. You can specify a timeout after which a hard shutdown is to be triggered.

. Stop wait timeout (sec)

If the timeout expires, the operation continues stopping the remaining instances.

3. Enter user name and password of the system administrator.

Result : The system is stopped. A red icon appears in the system icon in the navigator.

Exporting & Importing SAP HANA Systems

Exporting Systems

You can export a list of SAP HANA system from the SAP HANA studio to files and then use these to import the data into another instance of the SAP HANA studio.

Procedure

1. From the main menu, choose File  -> Export...

2. Expand the SAP HANA Studio folder and then choose Landscape.

3. Choose Next.

4. Select the systems to be exported and enter a target file location.

5. Choose Finish.

Importing Systems 

You can import a list of systems that you previously exported from another instance of the SAP HANA

studio.

Procedure

1. From the main menu, choose File  ->  Import...

2. Expand the SAP HANA Studio folder and then choose Landscape.

3. Choose Next.

4. Choose Browse... and select the file containing the list of systems that you want to import.

5. Select the folder into which you want to import the file.

6. Choose Finish.

How to Manage Multiple SAP HANA Systems

You can manage multiple SAP HANA database systems in the SAP HANA studio.

Systems are displayed in the navigator, where they are labeled with their system ID (SID) and description (if one was specified). When you expand a system node in the navigator, you see the default catalog, which contains public synonyms, schemas with column views (info cubes), functions, indexes, procedures, sequences, (private) synonyms, tables, and views.

Adding Systems 

Before you can carry out administrative tasks on an SAP HANA database, you must add it to the navigator. Note that the hostname of the server that hosts the database must be accessible from the client where the SAP HANA studio runs, even if the system is added by means of its IP address.

Prerequisites : All the relevant ports in the firewall should be opened.

Procedure

1. In context menu of the navigator, choose Add System.

Note : You can also import existing systems. More information: Importing Systems

2. Enter the following data:

 . Hostname

Name of the host where the system is installed

 . Instance Number

Instance number of the system

Note : To add a distributed system, you specify the host of one of its index servers (that is, instances). Every index server in a system has information about all the other index servers within the same system.

 . Description

You can enter a description for the system, which is displayed next to the system name in the navigation structure.

 . Folder

If you have already created a system landscape in the navigator, choose the folder to which you want to add the system.

 . Locale

Your location

3. Choose Next.

4. If required, choose your authentication type and enter your user information.

5. If you want to use a secure connection, choose Connect using SSL.

6. To enter advanced connection properties, choose Next. The following options are available:

 . Connection URL: Defines the properties of the connection to the database.

 . Auto-Reconnect: If you select this option, the SAP HANA studio automatically

reconnects after the connection to the system has broken.

7. Choose Validate SSL Certificate to ensure that the SSL connection is secure.

To override the system hostname in the certificate, enter a hostname with a defined certificate.

8. Choose Use user key store as trust store to validate the server certificate's validity (whether signed by a known certificate issuer) using the user key store.

The trust store property configures the trust store for SSL connect, which is used to validate that the SSL certificate of the server is issued by a trusted entity. Each user can to import certificates into his or her own user key store in Java using the "keytool" option (part of JRE).

The set of root certificates delivered with the JRE from well-known issuers (for example, Verisign, Thawte, Deutsche Telekom) is used when this option is not selected.

9. Choose Finish.

Result : The system is added in the navigator.

Note : Systems that you added using a secure connection are shown with a padlock icon.

How to Start Administration Console of the SAP HANA Studio

1. From your file explorer, start hdbstudio[.exe].

2. On the Welcome page, choose Open Administration Console.

Once you have closed the Welcome page, you can always change from another perspective to the Administration Console perspective by choosing Window -> Open Perspective -> Administration Console or by selecting the perspective in the upper-right corner of the screen.

How to update SAP HANA Studio

Prerequisite : You have to specify the site from which the SAP HANA studio is to download updates

1. From the main menu, choose Window -> Preferences -> Install/Update -> Available Software Sites.

2. Choose Add... and specify the update server settings:

Name: Optional entry, name of the location of the update repository

Location: Update repository location (for example http://<host_name>:<port_number>/tools/hdb.studio.update or file:////update_server/hdbstudio/repository/)

Updating the SAP HANA Studio Manually 

1. From the main menu, choose Help -> Check for Updates.

The system checks if there is an update available.

2. If an update is available, follow the onscreen instructions.

Configuring Automatic Updates of the SAP HANA Studio 

1. From the main menu, choose Window -> Preferences -> Install/Update -> Automatic Updates.

2. Specify your update settings.

You are automatically notified if an update is available in line with your settings.

What is the SAP HANA Database?

The SAP HANA database is a relational database that has been optimized to leverage state-of-the-art hardware. It provides all of the SQL features of a standard relational database along with a featurerich set of analytical capabilities and an SAP-specific programming language for stored procedures

called SQLScript. With these facilities, the SAP HANA database is capable of embedding application logic within the database itself. This allows complex queries to be executed directly inside the database, thus reducing the requirement of data transfer to and from the database. This enables SAP HANA-based applications to process vast amounts of data whilst operating in a responsive, real-time manner.

From the administrator's perspective, the SAP HANA database is conceptually about leveraging modern hardware system landscapes to increase database performance and reliability. Traditionally, databases have been designed to operate in a situation where there are limited memory and CPU resources. Currently however, servers can provide in excess of 1TB of memory and up to 80 CPU cores on a single system.

The SAP HANA studio is a collection of tools that allows database administrators and developers to manage data and monitor the SAP HANA database. The SAP HANA studio runs on the Eclipse platform, which presents these tools in the form of "perspectives".