HANA Studio Flashcards
Main tabs of HANA Studio Administration editor.
Overview
Landscape
Alerts
Performance
Volumes
Configuration
System Information
Diagnosis Files
Trace Configuration
Important editors available in the SAP HANA Administration Console
The System Monitor
The Administration editor
The Backup editor
The Security editor
The SQL console
Important views available in the SAP HANA Administration Console
Systems: which is the central access point for performing system administration and monitoring activities
Error Log: which contains error and information messages
Properties: which shows the detailed properties of the active resource (for example, the SAP HANA system selected in the Systems view)
Job Log
Systems view description
The Systems view provides you with a hierarchical view of all the SAP HANA systems managed in the SAP HANA studio and their contents. It is the central access point for performing system-specific administration and monitoring activities using the other available editors.
System Monitor (editor) description
The System Monitor is an editor that provides you with an overview of all your SAP HANA systems at a glance. From the System Monitor, you can drill down into the details of an individual system in the Administration editor.

Administration editor description
The Administration editor the main tool for performing administration and monitoring activities.
Administration Editor (Diagnosis Mode)
The Administration editor diagnosis mode allows you to monitor and perform emergency operations on systems to which either no SQL connection is available or the SQL connection is overloaded.
The Administration editor opens automatically in diagnosis mode in the following situations:
- When you open the Administration editor for a system that cannot be reached by SQL
- When you initiate the start, stop, or restart of a system
Monitoring Dashboard description
The Monitoring Dashboard visualizes key aspects of system health and configuration on a single screen with the option to drill down to more detailed views.
From the Systems view, choose Configuration and Monitoring / Open Dashboard
Backup editor description
The Backup editor is the main tool for performing administration and monitoring activities related to backup.
Security editor description
The Security editor is the main tool for managing the following aspects of security administration:
- Password policy
- Auditing
- Data volume encryption
You can access the Security editor in several ways:
- Expand the system in the Systems view and choose the Security entry
- In the context menu of the Systems view, choose Security/Open Security Console.
SQL Console description
Some tasks may require you to work with SQL statements, for example, certain administration tasks can only be performed using SQL. You can enter, execute, and analyze SQL statements in the SQL console.
Subtabs of Landscape tab in Administration editor
Services
Hosts
Redistribution
System Replication
Subtabs of Performance tab in Administration editor
Threads
Sessions
Blocked Transactions
SQL Plan Cache
Expensive Statements Trace
Job Progress
Load
Tools for system administration
- SAP HANA Studio / Administration Console perspective
- SAP HANA Lifecycle Manager Tools
- SAP Solution Manager
- SAP HANA HW Configuration Check Tool
- SAP HANA XS apps
Prerequisites of adding an SAP HANA System in Studio
- The relevant ports in your firewall are open.
- If you want to secure communication between the SAP HANA server and the SAP HANA studio using the Secure Sockets Layer (SSL) protocol, you have configured the server for SSL and imported the trust store file that contains the server root certificate into either the Java keystore or your user keystore on the client.
- You must have a database user, or the necessary infrastructure for Kerberos-based user authentication must be in place.
Prerequisites of adding an SAP HANA System with a Different User
- The system has already been added once in the Systems view.
- If you want to secure communication between the SAP HANA server and the SAP HANA studio using the Secure Sockets Layer (SSL) protocol, you have configured the server for SSL and imported the trust store file that contains the server root certificate into either the Java keystore or your user keystore on the client.
- The relevant ports in your firewall are open.
- You must have a database user, or the necessary infrastructure for Kerberos-based user authentication must be in place
What is a link to a Centrally-Stored Archive of SAP HANA Systems?
To allow users who work in the SAP HANA studio to connect efficiently to multiple SAP HANA systems, you can manage a list of all systems in a centrally-accessible archive. Users can then simply link to this archive.
What are the prerequisits for a link to a Centrally-Stored Archive of SAP HANA Systems?
- An XML file containing a list of all SAP HANA systems and their connection information exists at a centrally-accessible location, for example, a network file server.
- You can create this file by exporting a list of systems from your installation of the SAP HANA studio to the required location.
How do you Log Off From a SAP HANA System?
To log off from a system right-click it in the Systems view and choose Log Off.
All open connections to the system are closed, and in the Systems view, the system appears disabled. No information regarding its operational status is available; you cannot expand it and browse its contents.
How do you Log On To an SAP HANA System?
To log on to a system, simply double click it in the Systems view or from the context menu, choose Log On.
If your password is saved in the Eclipse secure store, you are logged on to the system immediately and can connect to it again. If have disabled the storing of passwords in the Eclipse secure store, you must re-enter your password.
How do you export a List of SAP HANA Systems?
- From the main menu, choose File/Export….
- Expand the SAP HANA folder and choose Landscape
- Choose Next.
- Select the systems you want to export and enter a target file location.
- Choose Finish.
How do you import a List of SAP HANA Systems?
- From the main menu, choose File/Import…..
- Expand the SAP HANA folder and then choose Landscape.
- Choose Next.
- Choose Browse… and select the file containing the list of systems that you want to import.
- Select the folder into which you want to import the file.
- Choose Finish.
What is the procedure of starting a SAP HANA system from HANA Studio?
- In the Systems view, right-click the system you want to start and choose Configuration and Monitoring/Start System…
- Optional: Specify a start timeout. The start timeout defines how long the SAP start service waits for an instance of the system to start. If the timeout is exceeded, the remaining instances are not started.
- Enter the user name and password of the operating system administrator that was created when the system was installed (that is, adm user).
What are the prerequisities of starting a SAP HANA system from HANA Studio?
You have the credentials of the operating system user (adm user) that was created when the system was installed.
What are the prerequisites of stopping a HANA system from HANA studio?
You have the credentials of the operating system user (adm user) that was created when the system was installed.
What is the procedure of stopping a HANA system from HANA studio?
- In the Systems view, right-click the system you want to stop and choose Configuration and Monitoring/Stop System.
- Specify how you want to stop the system: soft or hard
- Optional: Specify a stop wait timeout. If the system does not shut down gracefully before the specified timeout, the system is shut down forcefully.4.
- Enter the user name and password of the operating system user that was created when the system was installed (that is, adm user).
What are the prerequisites of restarting a HANA system?
You have the credentials of the operating system user (adm user) that was created when the system was installed.
What is the procedure of restarting a HANA system?
- In the Systems view, right-click the system you want to start and choose Configuration and Monitoring/Restart System.
- Specify how you want to stop the system: soft/hard
- Optional: Specify a stop wait timeout. If the system does not shut down gracefully before the specified timeout, the system is shut down forcefully.
- Enter the user name and password of the operating system user that was created when the system was installed (that is, adm user).