Setting Up Elastic Compute Nodes for SAP HANA Cloud

To set up ECNs, you need the following roles and privileges:

• To add, edit, or remove ECNs, you need the SAP HANA Cloud Instance Administrator role.

• To configure ECNs, you need the Space Developer role for the subaccount in which you will create the node, for example, SAP Business Technology Platform (BTP) or Cloud Foundry space.

• To view the ECN configuration, you need the SAP HANA Cloud Viewer role.

• To route workload to an ECN using workload classes, you need the WORKLOAD ADMIN and the INIFILE ADMIN role.

• To replicate tables to an ECN, you need the TABLE ADMIN system privilege.

• To monitor workload classes, you need the CATALOG READ system privilege.

1. Add an ECN
   1. In the instance Overview page, select Manage Configuration.
   2. In the Additional Nodes section, select Add ECN.
2. Provision the ECN
   1. Enter a name for the ECN.

      We recommend you use the acronym "ecn" in the name, for easy identification in location lists.

   2. Define performance class, memory, and storage for the ECN.

      In the Add Elastic Compute Node window, select a Performance Class for the ECN. Use the plus (+) and minus (-) symbols to modify the values for Memory and Storage for the ECN.

      The range of available values is based on your landscape configuration. You can modify memory capacity later and increase ECN storage but you can’t reduce the ECN storage after provisioning. If you modify the memory after provisioning, SAP HANA Cloud Central checks if the storage value is still within range; if not, the system corrects the value.

3. Set up workload classes to route to ECN
   1. If the workload class already exists, in the Workload Classes Management page, in the row for the workload class, check that an ECN is selected in the Routing Location column.
   2. If the workload class doesn’t yet exist, in the Workload Classes Management page, select Create and define the workload class properties. As Routing Location, select the ECN you want to route workload to.
4. Set up table replication (optional)
5. Define table placement and table redistribution (optional)

• You must have created an SAP HANA database instance using SAP HANA Cloud Central (multi-environment).

  Note

  Instances provisioned in Cloud Foundry cannot be updated with the SAP BTP command-line interface.

• You must have installed the SAP BTP command-line interface.

The SAP BTP command-line interface processes commands in sequence and the system is blocked for other operations until the command completes.

The data parameters are typically submitted as an appended json file - see the example code snippets below.

123456789101112
{
   "data": {
       "computeNodes": [
	       {
			 "name": <ECN name>,
			 "vcpu": <Number of vCPUs>,
			 "memory": <ECN memory in GB>,
			 "storage: <Size of the storage in GB>
		   }
		]
	},
}

1. Use the list command to see the available instances:
   Code Snippet

   Copy codeSwitch to dark mode

   1
   btp.exe list services/instance

2. Use update services/instance to add an ECN to an existing instance. The parameters for the computeNodes option can be submitted on the command line or attached in a json file.

   In the following example, an ECN named ecn1 is provisioned for the instance with two vCPUs, 32 GB memory, and 120 GB storage:

   Code Snippet

   Copy codeSwitch to dark mode

   1
   btp.exe update services/instance --id <myInstanceGUID> --parameters add_ecn.json

   Parameters in file 'add_ecn.json':

   JSON

   Copy codeSwitch to dark mode

   1
   {"data":{"computeNodes":[{"name":"ecn1","vcpu":2,"memory":32,"storage":120}]}}

3. Once a request has been submitted you can use the following commands to track the status of the last operation. Check for status value 'update succeeded'.
   Code Snippet

   Copy codeSwitch to dark mode

   1
   btp.exe get services/instance <myInstanceGUID> --subaccount <mySubaccountGUID>

   Or include the --name parameter to get detailed information about the service.

   Code Snippet

   Copy codeSwitch to dark mode

   1
   btp.exe get services/instance --name <myInstanceGUID> --subaccount <mySubaccountGUID> --show-parameters

4. Use the monitoring view M_LANDSCAPE_HOST_CONFIGURATION to check the status of the newly created ECNs in the landscape.
   SQL

   Copy codeSwitch to dark mode

   1
   SELECT * FROM M_LANDSCAPE_HOST_CONFIGURATION;

• You must have an SAP HANA database instance created in the Cloud Foundry runtime environment.

• You must have installed the Cloud Foundry command-line interface.

• You must have space developer authorizations in the Cloud Foundry space where you want to create the service.

This example uses update-service with the computeNodes parameter to add two ECNs with different sizes to an existing instance named my_hana.

1. The resource-version value (10842) is included to avoid the possibility of a concurrent modification.
   Code Snippet

   Copy codeSwitch to dark mode

   12345678910111213141516171819
   cf update-service my_hana -c '{                      \
     "data":{                                           \
       "computeNodes":[                                 \
         {                                              \
           "memory":120,                                \
           "name":"ecn1",                               \
           "storage":360,                               \
           "vcpu":4                                     \
         },                                             \
         {                                              \
           "memory":30,                                 \
           "name":"ecn2",                               \
           "storage":120,                               \
           "vcpu":2                                     \
         }                                              \
       ]                                                \
     },                                                 \
     "resource_version": "10842"                        \
   }'               			           	     

2. Once a request has been submitted you can use the following commands to track the status of the last operation. Check for status value 'update succeeded'.
   Code Snippet

   Copy codeSwitch to dark mode

   1
   cf get services

   Get detailed info about the service.

   Code Snippet

   Copy codeSwitch to dark mode

   1
   cf service <instance name>

3. Use the monitoring view M_LANDSCAPE_HOST_CONFIGURATION to check the status of the newly created ECNs in the landscape.
   SQL

   Copy codeSwitch to dark mode

   1
   SELECT * FROM M_LANDSCAPE_HOST_CONFIGURATION;