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.
- A new tenant database becomes a new service.
- indexserver is missing on the System DB.
Connection:
- to the SYSTEMDB is done through Nameserver which serves as SQL port.
- a tenant databases is done throughl the indexserver port
Articles Related
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;
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
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:
- Version ⇐ SPS10
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;