Removing a service from a tenant database in SAP HANA


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:

  1. You are logged on to the system database.
  2. You have the system privilege DATABASE ADMIN.

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'
raja
Published on 25-Apr-2018 20:21:31
Advertisements