Skip to Content

Stopping and Restarting the Extended Storage Service

Beginner
10 min.
SAP HANA dynamic tiering, SAP HANA, Beginner, SQL, SAP HANA studio, Tutorial, Big Data
Occasionally you will need to stop your extended storage service. One case where this will be required is when you change a configuration parameter, you will need to manually stop the service and then do a restart, in order for the change to take place.
You will learn
  • Stopping the Extended Storage Service using SAP HANA Studio and a SSH session
  • Restarting the Extended Storage Service using a SSH session

Prerequisites

  • Step 1

    The easiest way to stop the esserver process 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 esserver process by using the “HDB info” command. One benefit of this method is that you know immediately when the stop operation has completed.

    Stopping Extended Storage Service

    Another way to stop the extended storage service is through SAP HANA Studio. Open a SQL console and execute the following:

    sql
    Copy
    ALTER SYSTEM STOP SERVICE '<your.machine.name:port.number>';
    Stopping Extended Storage Service

    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 esserver and click “Stop”.

    Stopping Extended Storage Service

    Note: The screenshots above illustrate stopping the esserver process when connected through SAP HANA Studio as the SYSTEM user. 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 esserver process. 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.

    Restarting Extended Storage Service

    With SAP HANA Studio, there is no need to manually restart the extended storage service since it automatically restarts after you stop it.

Back to Top
Back to top