Skip to Content

S/4 on a multitenant Hana

Hi,

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


Regards.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Oct 06, 2016 at 03:06 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Ganimede Dignan

      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