Multi-container database mode is the new default

Multi-tenancy features, also known as “multiple database containers” or MDC have been available in SAP HANA for several years already. With the new SAP HANA 2.0 SPS 01 release, all systems now run in multi-container database mode. All new systems are installed in multi-container database mode, and existing single-container systems are converted during the upgrade to SAP HANA 2.0 SPS 01.

Advantages of multi-container database mode

Systems running in multi-container database mode can very easily be extended by adding new tenant databases. Being able to run and manage multiple tenant databases in one system helps you to lower capital expenditure, simplify database management, or for example build multi-tenant cloud applications.

Adjust SLT connection to HANA MCD

After convert HANA to MCD (MultiTenant) some tasks must to be executed in SLT to connect with MCD Database.

In addition to Note 2101084 please check the SAP Note relevant for your DMIS version from the list below and ensure all corrections are applied to both source and SLT server where indicated in the note.

• 2016511 - Installation/Upgrade SLT - DMIS 2011 SP7
• 1958809 - Installation/Upgrade SLT - DMIS 2011 SP6 / DMIS 2010 SP10
• 1882433 - Installation/Upgrade SLT - DMIS 2011 SP5
• 1824710 - Installation/Upgrade SLT - DMIS 2011 SP4 / 2010 SP9
• 1759156 - Installation/Upgrade SLT - DMIS 2011 SP3 / 2010 SP8
• 1709225 - Installation/Upgrade SLT - DMIS 2010 SP7 / 2011 SP2
• 2191214 - Installation/Upgrade SLT - DMIS 2011 SP9 & SP10 

SAP HANA Multitenancy Multi-tenant Database encryption with change of encryption root key for SYSTEMDB

Why This Blog:

In this case, the high level security measure is to enable Data Volume Encryption on the Hana system.

This is the first time I have enabled Data Volume Encryption with a Hana Multitenant Database.

After we have executed steps described in SAP HANA Administration guide, for enabling Data Volume Encryption, the alert '57' was raised in our SYSTEMDB reporting "Inconsistent SSFS". At this point our tenant DB was working without issues including backup. For system DB we were experiencing all symptoms reported by SAP Note 2097613.