HANA - Database (multiple-container|multitenant )

About

The database object of HANA.

Since SPS 09 (Revision 90),, SAP HANA system can be installed in multiple-container mode, which means it is capable of containing multitenant database containers.

A multiple-container system always has exactly one system database (SYSTEMDB) and any number of multitenant database containers (including zero), also called tenant databases.

Connection:

  • to the SYSTEMDB is done through Nameserver which serves as SQL port.
  • a tenant databases is done throughl the indexserver port

Management Tenant Database

During the installation of a multiple-container system, only the system database (SYSTEMDN) is initially created. You create and configure tenant databases afterward.

Basic administration of tenant databases is possible using the SAP HANA cockpit. However, the SAP HANA studio and command-line tools are required for some tasks.

Create

CREATE DATABASE DbName SYSTEM USER PASSWORD Manager1;

See create database statement

In case of scaleout landscape and you want to create a tenant DB on a specific host

CREATE DATABASE <DATABASE NAME> AT LOCATION 'HOST_A:30147' SYSTEM USER PASSWORD <PASSWORD>

Start

ALTER SYSTEM START DATABASE DbName

ALTER SYSTEM START DATABASE

List

SELECT * FROM "PUBLIC"."M_DATABASES";

Alter

Example:

ALTER DATABASE <database_name> ADD 'dpserver' AT LOCATION '<hostname>[:<port_number>]'

Drop

ALTER SYSTEM STOP DATABASE <dbname>;
DROP DATABASE <dbname>;

Configure

Privilege

DATABASE ADMIN only available on SYSTEM DB.

Memory

You can use allocationlimit in memory manager to limit the maximum amount of memory that can be allocated to all processes of a tenant database. For example, execute below command from the system database:

ALTER SYSTEM ALTER CONFIGURATION ('indexserver.ini', 'DATABASE', 'MYDB') SET ('memorymanager', 'allocationlimit') = '8192' WITH RECONFIGURE;
  • >= SPS11
ALTER SYSTEM ALTER CONFIGURATION ('global.ini', 'DATABASE', 'MYDB') SET ('memorymanager', 'allocationlimit') = '8192' WITH RECONFIGURE;

Documentation / Reference


Powered by ComboStrap