on 10-05-2016 6:58 PM
Hi,
is hana in multitenant supported for S/4 installation? Is it possible convert from single to multitenant and existing single installation?
Regards.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
91 | |
8 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.