SQL Ports for HANA 2.0 to connect system database and tenant database

 in MDC, hdbuserstore keys need to be set based on the SQL port.

• Keys for Systemdb must be set using SQL port 3<02>13
• Keys for Tenant DB must be set using SQL port 3<02>13@<Tenant_DB>

here <02> is instance number.

Conversion of HANA DB from single container to combination of system DB and tenant DB.

 The system can be installed on one or multiple system hosts, which are configured to operate as worker or standby hosts. As of SAP HANA 2.0 Support Package Stack (SPS) 01, the SAP HANA system can only be installed or configured to be a tenant database system. A tenant database system contains one system database and can contain multiple tenant databases. A single-container system will be automatically converted to a tenant database system during the upgrade to SPS 01.

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>

                 

SAP HANA COCKPIT NOTES 28: creating NEW tenant Database in HANA

Article About:

how to create new tenant database in HANA DB through HANA COCKPIT.

Content:

here are the steps to create new tenant database in HANA cockpit,

1.connect to system database --> navigate to overview page.

2. on the overview page, click the overall tenant statuses tile to open manage databases.

3.click on create tenant button.

3b. then click on create empty tenant option.

4. provide inputs 

• tenant database name: SID
• system user password: 
• conform system user password: 
• in Advanced settings:

                start Automatically  is enable by default.

Note: will have option to defined HOST and port details in case of distributive

          environment.

Have an option to add additional services based on tenant Database technical and business requirements.

5. Finally click on Create tenant database.

6.conformation screen is as below.                                                                                                             

7. the new tenant database need to add in resource groups by administrator through cockpit manager.      

open cockpit manager -->register resources-->register resource--> provide inputs like host name, instance name & number.

                                                                     OR 
create a tenant database using SQL query in HANA studio.with 3 steps.


step1:  open SQL cmd window from HANA studio.
step2:  Run the SQL query as shown in the below screenshot.
step3: finally execute it.

SAP HANA NOTES 16: HOW to check multi-tenant databases list in HANA studio(HDBSQL console)

1. login to HANA studio.
2. open the HDBSQL console.
3. run the below command.

enjoy...