Skip to Content

Over the last few months, I’ve been trying out various scenarios involving the new multitenant database containers in SAP HANA SPS 09, and I thought it might be helpful to share my findings and examples with others who want to get their feet wet with this new feature. So here goes…

“Multitenant database containers” is a bit of a mouthful, so for the rest of this article I’m going to use the abbreviation MDC.

The first scenario I tested was the installation of SAP HANA SPS 09 with MDC, followed by the installation of two ABAP systems on two HANA tenants: 

Scenario_1_MDC_install_2_ABAP_systems_corrected_cropped.jpg

Installing SAP HANA with multitenancy

I started by installing HANA with MDC using hdblcmgui. The installation procedures are well documented on SAP Help Portal, so I won’t go into all the details here. The only thing you do differently from a standard installation is change the database mode from single_container (the default) to multiple_containers:

HANA_installation_with_MDC.jpg

The result is a system database but no tenant databases inside a HANA system that supports multiple database containers. For the distinction between a tenant database and the system database, see the SAP HANA Master Guide.

I then added my system database to the Systems view in the SAP HANA studio:

Add_system_MDC_system_DB.jpg

Once I was logged on as the administrator of the system database, I was able to create a tenant database in the SQL console using the CREATE DATABASE statement:

Creating_tenant_DB.jpg

Created_tenant_DB_confirmation.jpg

I added the tenant database in the Systems view:

Add_system_MDC_tenant_DB.jpg

Then I created and logged on to a second tenant. The Systems view in the SAP HANA studio then looked like this:

Added_systems_in_studio_MDC.jpg

The system database had an additional SYS_DATABASES schema:

SYS_DATABASES_schema_in_system_DB.jpg

The SYSTEM user of the system database has the privilege DATABASE ADMIN for the execution of operations on tenant databases.

DATABASE_ADMIN_privilege.jpg

Installing NetWeaver on a HANA database tenant

The software provisioning manager SP 7 provided with SL Toolset 1.0 SPS 12 supports MDC, so I was able to install an SAP NetWeaver 7.4 SR 2 on each of the tenants. This involved specifying the name of the tenant database with the tenant database’s administrator password, as well as the password of the system database administrator. These steps are described in detail, with screenshots, in Stefan Seemann’s blog: http://scn.sap.com/community/it-management/alm/software-logistics/blog/2014/12/02/software-provisioning-manager-and-hana-multi-tenant-database-containers

Installation of the HANA client was part of the same procedure.

Stopping and starting tenant databases

Having backed up the tenant databases, I then stopped one of them from the SQL console of the system database:

Stopping_tenant_DB.jpg

To open the administration console of the stopped tenant, I was prompted to log on with the credentials of the operating system user:

Logging_on_as_sidadm_user.jpg

It baffled me somewhat that the administration console of the stopped tenant database (DB2) should show the index server of the tenant (DB1), but it’s because the operating system user (the “SID user”) can currently see the processes of all database containers in this view.

Tenant database DB2 in the process of stopping:

Tenant_DB_DB2_stopping.jpg

Tenant database DB2 when stopped:

Tenant_DB_DB2_stopped.jpg

Development has told us that improved visibility and transparency of the processes for different database containers is in the pipeline.

Enabling HTTP access to tenant databases

I also enabled HTTP access to the individual tenants, but more about that in my next blog.

To report this post you need to login first.

4 Comments

You must be Logged on to comment or reply to a post.

    1. Joerg Hoffmeister

      @Pravan: You can do so. Use additive sizing and refer to notes describing restrictions and constraints for ECC, BW and MDC. (2096000 and its references, 2121768, 1825774, …)

      All the best

      Jörg (PM HANA)

      (0) 

Leave a Reply