cancel
Showing results for 
Search instead for 
Did you mean: 

S/4 on a multitenant Hana

ganimede_dignan
Contributor
0 Kudos

Hi,

is hana in multitenant supported for S/4 installation? Is it possible convert from single to multitenant and existing single installation?


Regards.

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member205280
Active Participant
0 Kudos

Hi,

Yes the HANA multi-tenant database is supported for S/4HANA.

It's also possible to convert an single system to support multi-tenant database, you can either use the HDBCLM or the python support script convertMDC.py.

For example the HDBCLM command line tool:

hdblcm --action=convert_to_multidb

What the tool will do is move the SYSTEM related data to the new SYSTEMDB database, then create a new tenant database with the name <SID>, move your non SYSTEM data or schema into this new tenant database.

Regards,

Michael

ganimede_dignan
Contributor
0 Kudos

Hello,

how many hours does it need?

Thank you so much.

Regards.

former_member205280
Active Participant
0 Kudos

Hi,

You're welcome!

It's hard to say how long it will take, it depends on your hardware and the size of your database, generally it can take from a few minutes to half hour (I guess) if your database's not at TB level (disk size), of cause you system will be temporary shutdown during the period of time.

I've done conversion of 130 GB HANA just about 5 minutes in a 256 GB RAM appliance, you can use the following SQL query to "estimate" your schema size, the result may not very accurate but it'll give you a general idea.

SELECT SCHEMA_NAME, ROUND(SUM(DISK_SIZE)/1024/1024/1024, 3) AS SIZE_GB FROM SYS.M_TABLE_PERSISTENCE_STATISTICS WHERE SCHEMA_NAME='SAPHANADB' GROUP BY SCHEMA_NAME;

Regards,

Michael