How to stop EC2 instance in AWS

From the EC2 instance launching page (AWS console --> services-->compute --->EC2--> Running instances --> select the correct instance which need to Stop) perform the below navigation.

 click on stop option as highlighted below. Actions -->instance state -->stop.                                                            

then the screen prompts for conformation screen. conform it to stop EC2 instance.

How to stop , Start and drop tenant Database in HANA database

1. open one putty session.
2. $ su  - <SID>adm
3. make sure that the present word directory ($ pwd) is /usr/sap/hana/HDB<XX>
4. issue the below command:

                               hdbsql -U system -p <password>  -n vh<xxx><xxx><db>:3<XX>13

       Note: issue the below OS command to make sure the sid

df -h in the DB host, which will give DB<sid>

df -h in the application host,which will give Application <sid>

   5. To check for list of tenant databases available:

                     select * from M_DATABASES
   6.To stop the tenant DB issue the below command:

                 alter system stop database <SID>                     Note: choose one <sid> from step 5 query


   7.To start the tenant DB issue the below command:

                                        alter system start database <sid>

   8. To delete the tenant database permanently along with data in it, issue the below command:
        Make sure of your Tenant DB sid, which executing the below command, As it will delete every thing.

                                  

                                                drop database <SID>