Removing a service from a tenant database in SAP HANA

In SAP HANA multi-tenant environment, is it possible to remove server component- an index server or XS server? How this can be done?

0 0

1 Answer

SAP Developer

Answered on 25th Apr, 2018

Yes, it is possible to remove a server component, which are no longer required. This can be performed using ALTER DATABASE SQL command.

Following perquisites should be met to perform this task:

To remove a service, you need to open SQL console of the SAP HANA studio and run “ALTER DATABASE” statement.

ALTER DATABASE DB1 REMOVE '<service name>' AT LOCATION 'HOST_A:30XXX'

0 0