SAP Hana Administration Tutorial on Lunix/Linux

What is SAP HANA ?

SAP HANA came to market in just few years back (might be around 2011). It’s still under testing in many companies. So it pretty new to the market. But the performance of the SAP HANA is comparatively 1000 times faster than the other RDBS like db2,oracle etc.
We need a client to administer SAP HANA. That client is named as SAP HANA studio. So for administrating SAP HANA we need a client name SAP Hana studio. It can be used for various purposes. SAP HANA studio is used for various purposes. It can be used by a developer, Design consultant, SAP HANA administrator etc



 

SAP HANA ARCHITECTURE

SAP HANA runs on Linux SUSE Server. SAP HANA database consists of multiple servers and the most important component is the Index Server. SAP HANA database consists of Index Server, Name Server, Statistics Server, Pre-processor Server and XS Engine.
SAP HANA runs on Linux SUSE Server. SAP HANA database consists of multiple servers and the most important component is the Index Server. SAP HANA database consists of Index Server, Name Server, Statistics Server, Pre-processor Server and XS Engine.
 

SAP Hana architecture
SAP Hana architecture

 
Persistence Layer:
The database persistence layer is used for durability of the required/performed transactions.
It is used for restoring data in a database with the latest modifications which are committed after the restart and transactions are saved or undone.
 
Index Server:
Index server is the main SAP HANA database component
It contains the actual data stores and the engines for processing the data.
The index server processes incoming SQL or MDX statements in the context of authenticated sessions and transactions.
Pre-processor Server:
The pre-processor server is used by the index server for analysing the text datas and retrieving the information based on the text search capabilities.
Name Server:
The name server owns the information about the topology of SAP HANA system. The server contains all the information about its components and knows where the data is actually located. So this server contains information about the sap Hana components and its location.
Statistic Server:
As the name tells, this server will contain the statistical datas. It will contain the status, performance and resources from other systems in the system. It is also used for historical analysis. Only based on this report we can tune the sap Hana system performance.
Session and Transaction Manager:
The main purpose of this component is to track the database transactions. Also it will track the transactions which are closed and running. Whenever a transaction is saved or committed, it will inform the storage engines about this transaction which had happened.
XS Engine:
It’s not actually used efficiently. But its primary use is for connecting ot the sap HANA databases to fetch data via HTTP.
 



 

SAP HANA STUDIO

 
The SAP HANA studio is a collection of applications for SAP HANA. It enables technical users to manage the SAP HANA database, to create and manage user authorizations, and to create new or modify existing models of data in the SAP HANA database. It is a client tool, which can be used to access local or remote SAP HANA databases.
On Linux
SAP HANA will be installed under the below path:
Linux x86, 64-bit 64-bit /usr/sap/hdbstudio
Below are the features of the SAP HANA studio:

  • SAP HANA Studio Administration
  • SAP HANA Studio Database Development
  • SAP HANA Studio Application Development




 

SAP HANA INSTALLATION

 
You can install the SAP HANA studio with one of the following methods:

  • Using installation manager
  • Using command line

 
Using Installation manager
Use the GUI-based Installation Manager to install SAP HANA. It’s based on hdbsetup
For SAP HANA Installation you should first download and extract the software to your system. This can be downloaded from the sap website.

  • Run ./hdbsetup
  • Follow the instructions displayed by the Installation Manager

Using command line
Use the hdbinst program at the command line.

  • Download and extract the software to a directory.
  • Run ./hdbinst
  • Follow the instructions displayed by the installation tool.

 



 
START HANA STUDIO ON LINUX
 
How to start SAP HANA studio in Linux?

  1. Open a shell and go to the installation directory, such as /usr/sap/hdbstudio
  2. Execute the following command “./hdbstudio”.

This will start the SAP HANA STUDIO.
 
STOP/START SAP HANA DB
How to start/ stop the sap hana database ?
Stop HANA DB can be done via two methods,

  • Using the SAP HANA STUDIO
  • Using command line.

Using the SAP HANA STUDIO

  • Right click on the HDB(hana database, where you want to perform stop)
  • This will shut down the SAP Hana processes running in the server.

Using the command line

  • Login to the server.
  • Login as sap sid admin.
  • HDB stop

Starting HANA DB can be done via two methods,

  • Using the SAP HANA STUDIO
  • Using command line.

Using the SAP HANA STUDIO

  • Right click on the HDB(hana database, where you want to perform stop), click on the Start server option.
  • This will start all the processes related to SAP HANA DB.

Using the command line

  • Login to the server.
  • Login as SAP SID admin.
  • HDB start.

Hope the document would have given you a basic touch on SAP HANA ADMINISTRATION.