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:
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 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>
ALTER SYSTEM START DATABASE DbName
SELECT * FROM "PUBLIC"."M_DATABASES";
Example:
ALTER DATABASE <database_name> ADD 'dpserver' AT LOCATION '<hostname>[:<port_number>]'
ALTER SYSTEM STOP DATABASE <dbname>;
DROP DATABASE <dbname>;
DATABASE ADMIN only available on SYSTEM DB.
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;
ALTER SYSTEM ALTER CONFIGURATION ('global.ini', 'DATABASE', 'MYDB') SET ('memorymanager', 'allocationlimit') = '8192' WITH RECONFIGURE;