Stopping a SAP HANA Cloud Database

Objectives
After completing this lesson, you will be able to:

After completing this lesson, you will be able to:

  • Stop your SAP HANA Cloud database instance

SAP HANA Cloud Database Instance Stop

Lesson Overview

In this lesson, you'll learn how to stop your SAP HANA Cloud database instance that you previously created in your SAP Business Technology Platform (BTP) account.

Business Case

As a database administrator, you need to stop your company's SAP HANA Cloud database deployed in the SAP Business Technology Platform.

Note
The steps to stop your SAP HANA Cloud database instance also apply to an SAP HANA Cloud database instance that was created in an SAP Business Technology Platform (BTP) enterprise account.

Stop an SAP HANA Cloud Database Instance

Your SAP HANA Cloud database instance is part of the SAP Business Technology Platform. To find your SAP HANA Cloud database instance, you need to perform the following steps.

  1. Log on to the SAP Business Technology Platform account, and navigate to the SAP HANA Cloud database area by following one of these paths:
    • For a BTP account: <your BTP home page><your global account><your subaccount><your development space>. From the navigation pane, select SAP HANA Cloud button. Then select the button Manage HANA Cloud.
    • For a BTP enterprise account: <your BTP home page>your enterprise global account>select the Subaccounts link<your subaccount><your development space>. From the navigation pane, select SAP HANA Cloud button. Then select the button Manage HANA Cloud.
  2. A sign-in tab opens, select your e-mail address to continue the sign in process.
  3. In the new tab, you are now logged on to the SAP HANA Cloud Central application.

You're now in the SAP HANA Cloud Central application where you get an overview of all the SAP HANA Cloud database instances that you've deployed in this development space.

The following steps show you how to stop your SAP HANA Cloud database instance:

  1. In the SAP HANA Cloud Central application, locate your SAP HANA Cloud database instance that you want to stop, and select the °°° (More) button.
  2. From the drop-down menu, select the Stop option.

Your SAP HANA Cloud database instance is now being stopped. The whole shutdown process takes around 30 seconds.

Stop a Database Instance Using Cloud Foundry CLI

It's also possible to stop an SAP HANA Cloud database instance using the Cloud Foundry CLI. Before you can stop a database instance, you need to install the Cloud Foundry CLI and log on to the SAP BTP as previously explained.

To Stop an SAP HANA Cloud database using the Cloud Foundry CLI, execute the following steps:

  1. Open a Linux Terminal or Windows PowerShell.
  2. Log in to the SAP BTP using the command cf login -o <organisation> -s <space> -a <API endpoint> and enter your credentials.
  3. To create a new database service, execute the command:
    Code snippet
    cf update-service <service name> -c
    '{"data":
        {
          "serviceStopped": true
        }
     }'
    Expand

    Example:

    Code snippet
    cf update-service HC200-Demo-Database -c '{ "data": {"serviceStopped": true}}'
    Expand

    The above command will stop the started database.

Have a look at the Start and Stop an Instance Using the CLI page to have a complete list of parameters that can be used to stop a database instance.

Stop an SAP HANA Cloud Database Instance

Log in to track your progress & complete quizzes