Create A Tenant Database

  • Syed Hussim
  • 25 July 2017
  • 21098
This article describes how to create a tenant database in HANA DB. To create a tenant database, first login to SystemDB using the SYSTEM user either by using hdbsql or HANA Studio. Execute the following SQL statement to create the database DB1.

Listing 1

CREATE DATABASE DB1 SYSTEM USER PASSWORD "your password"

The above create statement will create a new database using the SYSTEM user. Once the database has been created, you can verify its status by executing the following SQL.

Listing 2

SELECT * FROM SYS.M_DATABASES

Take note of the ACTIVE_STATUS field, if the value for this field is NO, it means the database is not running and must be started. To the start the database, execute the following SQL statement.

Listing 3

ALTER SYSTEM START DATABASE DB1

You can now connect to the database using hdbsql or HANA Studio. For hdbsql, use the following command parameters.

hdbsql=> \c -n hostname:39013 -u SYSTEM -p password -d DB1
In HANA Studio, you will need to add a New System, select the Multiple containers mode and specify the tenant database name.
HANA DB Articles
Recent Articles
  • Stock Transfer Part 2

    In the previous article I exaplined how to transfer stock between warehouses and bin enabled warehouses. In this article, I discuss how to transfer batch enabled items.

    07 August 2020 - 238 views
  • Logo Programming Sample Code

    This article details the usage of the CSharpLogo program, which is a basic port of the iconic Logo programming language.

    29 July 2020 - 114 views
  • A JavaScript Implementation Of The Logo Programming Language - Part 2

    Part 2 of A Javascript Implementation Of The Logo Programming Language. In the previous article I explained how to develop a simple lexer. In this part we develop a TokenCollection class to help traverse the array of tokens returned from the lexer.

    10 June 2020 - 640 views
  • A JavaScript Implementation Of The Logo Programming Language - Part 1

    In this four part article, I explain how to develop the iconic Logo programming language in JavaScript. In this part, we discuss how to take a source input and convert it into a series of tokens.

    06 June 2020 - 903 views
  • Generating Web API Keys

    If you're building a REST API, chances are you're going to need to generate secure random API keys. In this article, I explain how to use the Node.js crypto module to generate random secure API keys.

    29 May 2020 - 1744 views
  • Port Scanner

    A simple port scanner to scan a range of ports.

    31 January 2020 - 1068 views
  • Stock Transfer Part 1

    The SAP B1 Service Layer provides an API to move stock between warehouses. This article explains the construction of the JSON payload data that is posted to the StockTransfers API.

    12 December 2019 - 1732 views