Stopping and Restarting the Extended Storage Service
- Stopping the Extended Storage Service using SAP HANA Studio and a SSH session
- Restarting the Extended Storage Service using a SSH session
- Tutorials: Creating and Removing Extended Storage
- Credentials: Connection details to initially connect as the “SYSTEM” user and access to “
<SID>adm” for a SSH session
- Step 1
The easiest way to stop the
esserverprocess is to use the “
HDB stop” command from a SSH session. The “
HDB stop” command will not just shut down the
esserver/Dynamic Tiering process but it will shut down the entire HANA system. After the “
HDB stop” command completes, you can verify the status of the
esserverprocess by using the “
HDB info” command. One benefit of this method is that you know immediately when the stop operation has completed.
Another way to stop the extended storage service is through SAP HANA Studio. Open a SQL console and execute the following:sqlCopy
ALTER SYSTEM STOP SERVICE '<your.machine.name:port.number>';
Another way to stop the extended storage service is by double clicking on “
(SYSTEM)” and then navigating to the “Landscape” tab. Right click on the
esserverand click “Stop”.
Note: The screenshots above illustrate stopping the
esserverprocess when connected through SAP HANA Studio as the
SYSTEMuser. You would need to allocate an additional permission (SERVICE ADMIN) for the TPCH user to have the same privilege. Make sure to close the Administration window for the TPCH user if you already had it open and then open the Administration window again after you assign the new permissions. This is an example where a database developer would typically not have the same permissions as an administrator and hence cannot do the same functionality. So it is better to stop the services by the SYSTEM user, if you are using Studio to stop the service.
After the "stop" operation completes, you check the status of the esserver service by running which command?
- Step 2
To restart the extended storage service from a SSH session, use the “
HDB start” command. After the command completes, use the “
HDB info” command to verify the status of the
esserverprocess. Just as with using a SSH session to stop the extended storage service, this method lets you immediately know when the start operation has completed.
With SAP HANA Studio, there is no need to manually restart the extended storage service since it automatically restarts after you stop it.