what are HANA Service and its types?

 In this glob we will see the process below to the HANA database, there are different processes and different uses. 

In the below snap, we can different process of HANA Database

whats use of hdbrsutil in HANA Database?

 We are going to see the use and importance of hdbrsutil tool in the HANA Database. We all know about hdbnsutil but we might not come across or see tool hdbrsutil. 

But in HANA database performance it plays an important role by keeping the ROW store table in memory when the HANA database gets restart or shutdown. this service helps us to keep the row store table in memory so when the database getting the start, there is no need to load a row store table in memory.

in the below snap, we can see Core Hana services 

 

Note: if the Host on which Hana database installed is restarted then hdbrsutil will stop and when HANA DB starts it will start again with database services. 

How to install HANA Database Client on Windows OS

 We will see how to upgrade or install the HANA database client on Windows OS in this blog

Please follow the steps.

1; Download the HANA database client as per OS and bits from SAP Market and keep it in the software folder.

2. Now execute hdbinst (Command ) or hdbsetup ( GUI)  and select default option for an upgrade from the old version and select 2 for installation 

we can select the default option by pressing enter or enter 1. 

Error: 

Processes are locked. it's asking to terminate the process. 

Resolution: 

This error occurred because SAP application is running. First, stop SAP application before doing SAP HANA client upgrade 

To sum up: Whenever a client application wants to connect to SAP HANA, it needs to use the SAP HANA client software.

Now try again for the upgrade of the HANA database client. and it completed successfully 

Check HANA HANA database client version check 

Thanks :)