Cockpit

This is an administration tool to manage your SAP HANA system and is based on SAP Fiori
Launchpad based navigation to access long range of HANA applications. SAP HANA cockpit
can be accessed via a web browser.
You can also use SAP HANA Cockpit in an offline mode to perform administration tasks -
starting HANA system to fix performance-related issues.
SAP HANA Cockpit with Fiori-based Launchpad shows the content in the form of tiles arranged
in groups. Using these tiles, you can access individual applications and can also access app-
specific data for immediate review.
You can also perform a drill on these tiles to see the detailed information about specific
applications.
Following roles are required to open and access tile-based SAP HANA Cockpit −
sap.hana.admin.roles:: Monitoring or sap.hana.admin.roles:: Administrator
To open SAP HANA Cockpit via a web browser, you need to have browser support SAPUI5
library sap.m.
You can also open SAP HANA Cockpit via HANA Studio. Navigate on HANA system →
Configuration and Monitoring → Open SAP HANA Cockpit.

A single-container system is accessed through the following URLs −

https://<host_FQDN>:43<instance>/sap/hana/admin/cockpit
https://<host_FQDN>:80<instance>/sap/hana/admin/cockpit
Host name is SAP HANA system name and Instance number is SAP HANA system Instance
number.
SAP HANA Cockpit for Offline Administration
You can also open HANA Cockpit in an offline mode using a web browser or via standard SAP
HANA Cockpit tool. This is used to perform administration tasks - starting SAP HANA system,
other offline administration activities.
To login to SAP HANA Cockpit for offline administration, following perquisites should be met
−
 You need to have credentials for Operating System user <sid> admuser created at
the time of installation.
 Port 1129 should be open for communication.
 You need to have browser support SAPUI5 library sap.m.
There are two ways to open SAP HANA Cockpit in an offline mode −
Using the Web Browser
Enter the following URL in the web browser.
https://<host>:1129/lmsl/hdbcockpit/<sid>/index.html
You can directly enter the above URL in the web browser and it opens SAP HANA Cockpit for
offline administration. You have to authenticate via Operating system user <sid> admuser.
This method is not recommended as it transfers the password in plain text via HTTP.
Using the Standard SAP HANA Cockpit
You can open SAP HANA cockpit by entering the following URL.
https://<host_FQDN>:43<instance>/sap/hana/admin/cockpit
Navigate to SAP HANA Database Administration group → Select SAP HANA Cockpit for
offline administration as shown in the 2nd last box of the following screenshot.

There are various options under SAP HANA Cockpit for offline mode, when you click on the
options as shown in the following screenshot −

Start, Restart and Stop

This tile shows the status of your SAP HANA system. Following are the most common status
messages you can see −

 Running
 Stopping
 Stopped
 Initializing
When you click on this tile, it allows you to start, stop, and restart a server.
Diagnosis Files
This is used to open the log files, trace results and other diagnosis files. You can use this tile to
get the diagnosis files in zip format and it can be attached to support messages.
It is also possible to search diagnosis files to find specific words and phrases.
Troubleshoot Unresponsive System
This tile is used to access the information required for troubleshooting performance issues.
SAP HANA Documentation Tile
Using this tile, you can see the documentation of all the administrative tasks that you can
perform in SAP HANA Cockpit for offline administration.
SAP HANA Cockpit
This tile is used to access the main window where you can access all applications for performing
SAP HANA administration online. In case of system replication, this option is only available
with primary system.
Note − In multitenant database containers, when you use Start option under SAP HANA Cockpit
offline administration → Star, Restart, Stop tile → Footer bar, Start System - this options restarts
all the tenant database systems.
When you stop a system, the status of the system under Start, Restart, and Stop tile is changed to
Stopped (red) as seen in the following screenshot.

SAP HANA Studio is an Eclipse-based tool. SAP HANA Studio is both,

the central development environment and the main administration tool for HANA
system. Additional features are −
 It is a client tool, which can be used to access local or remote HANA
system.
 It provides an environment for HANA Administration, HANA Information
Modeling, and Data Provisioning in HANA database.
There are various administration tasks that can be performed using SAP HANA Studio −

 To start and stop service

 To perform monitoring of SAP HANA system
 To perform user management and authorization
  To perform backup and recovery
 To perform Audit policy and Security configuration
 To perform license management
 To perform other configurations in HANA system
 To perform SQL development tasks - HANA Information Models, SQL
Stored Procedures
In SAP HANA Studio, you will find a long list of perspectives, which can be considered
as separate tools in HANA Studio. All these perspectives can be used for performing
various administrative tasks, system monitoring, and data provisioning.
To see list of all Perspectives in HANA Studio, navigate to Window tab → Perspective
→ Open Perspective → Other.

When you click on “Other…”, it will open the list of all the perspectives that can be used
to manage and perform system administration.
SAP HANA Administration Console in HANA Studio
Using this feature, you can open HANA database administration and monitoring
features in HANA Studio. By default, it opens in System View.
To open SAP HANA Administration, you can select SAP HANA Administration Console
Perspective default option. You can also access it via Administration button at the top.
When you click the Administration button as shown in the following screenshot, it opens
SAP HANA Administration Console. The console contains all database administration
and monitoring features of the SAP HANA studio.

Following tabs are available under SAP HANA Administration Console −

 Overview
 Landscape
 Alerts
 Performance
 Volumes
 Configuration
 System Information
 Diagnosis Files
 Trace Configuration
These tabs are used to perform monitoring and administration tasks in your SAP HANA
system.

Adding a System in HANA Studio

Single or multiple systems can be added to HANA Studio for administration and
information modeling purposes. To add new HANA system, host name, instance
number and database user name and password is required.

 Port 3615 should be open to connect to Database

 Port 31015 Instance No 10
 Port 30015 Instance No 00
  SSh port should also be open
Following are the steps to add a system to HANA Studio.
Step 1 − Right-click the Navigator space and click Add System. Enter HANA system
details, i.e. Host name & Instance number and click Next.

Step 2 − Enter Database user name and password to connect to SAP HANA database.
Click Next and then Finish.

Once you click on Finish, HANA system will be added to System View for administration
and modeling purposes. You can see the hierarchical structure of HANA system under
HANA Studio.
Each HANA system has two main sub-nodes, Catalog and Content.
Catalog Tab − It contains all available Schemas, i.e. all data structures, tables and
data, column views, procedures that can be used in the Content tab.
Content Tab − The Content tab contains design time repository, which holds all
information of data models created with the HANA Modeler. These models are
organized in Packages. The content node provides different views on the same physical
data.
Executing SQL Statements in SAP HANA Studio
SQL Console can be opened by selecting the Schema name, in which, a new table has
to be created using System View SQL Editor option or by a right-clicking the Schema
name as shown in the following screenshot.

Once SQL Editor is opened, Schema name can be confirmed from the name written on
the top of SQL Editor. You can create database objects using SQL statement.
To create a table −
Create column Table Test1 (
ID INTEGER,
NAME VARCHAR(10),
PRIMARY KEY (ID)
);
In this SQL statement, we have created a Column table “Test1”, defined data types of
the table and the Primary Key.
Once you write Create table SQL query, click the Execute option on top of SQL editor
on the right side of the screen. Once the statement is executed, we will get a
confirmation message as follows −
Statement 'Create column Table Test1 (ID INTEGER,NAME VARCHAR(10), PRIMARY
KEY (ID))' successfully executed in 13 ms 761 μs (server processing time: 12 ms 979
μs) − Rows Affected: 0

Insert statement is used to enter the data in the Table using SQL editor.
Insert into TEST1 Values (1,'ABCD')
Insert into TEST1 Values (2,'EFGH');
Click Execute.
You can right-click the Table name and use Open Data Definition to see the data type of
the table. Open Data Preview/Open Content to see the table contents.

Using Log Off /Log On in SAP HANA Studio

Using SAP HANA Studio, you can also log off from a SAP HANA system and end all the
connections. To login to HANA system again, click Logon.
To logoff from a system, right-click the System name in HANA Studio → Log Off.
To login again, right-click on HANA system in System Pane → Log On. You will be
prompted to enter the password. Enter the password and click OK. You will be logged in
to HANA system under HANA Studio. You can view all the folders and objects in HANA
system.

You can also define the user logon behavior in SAP HANA Studio startup. It allows you
to save the password for the users when HANA Studio or other user settings is open.
Go to Preferences → SAP HANA → Global Settings.
If you wish automatic logon takes place when the Studio is started and also to allow
explicit logon when HANA studio starts, uncheck the first option.

SAP HANA Admin - System Management

When SAP HANA system is installed, there are various components that get installed with
HANA system. It includes −
Mandatory Components of SAP HANA −

 SAP HANA Server

 SAP HANA Client system
Additional Components −

 SAP HANA Studio

 SAP HANA Smart Data Access SDA
 SAP HANA XS Runtime environment
 SAP Live Cache Applications
When the installation is complete, you may need to perform various tasks in SAP HANA system,
such as −

 Backup and Recovery Management

  User Management
 Starting HANA System
 Stopping HANA System
 License Keys
 System INI Files
 Monitoring HANA System
 Data Replication using SMART data access
 SAP HANA integration with BusinessObjects Reporting environment
These tasks can be performed using various SAP HANA admin tools. Most common tools to
perform SAP HANA system management - HANA Cockpit, SAP HANA Studio.