HANA Studio Flashcards

1
Q

Main tabs of HANA Studio Administration editor.

A

Overview

Landscape

Alerts

Performance

Volumes

Configuration

System Information

Diagnosis Files

Trace Configuration

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Important editors available in the SAP HANA Administration Console

A

The System Monitor
The Administration editor
The Backup editor
The Security editor
The SQL console

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Important views available in the SAP HANA Administration Console

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Systems view description

A

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.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

System Monitor (editor) description

A

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.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Administration editor description

A

The Administration editor the main tool for performing administration and monitoring activities.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Administration Editor (Diagnosis Mode)

A

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
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Monitoring Dashboard description

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Backup editor description

A

The Backup editor is the main tool for performing administration and monitoring activities related to backup.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Security editor description

A

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.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

SQL Console description

A

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.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Subtabs of Landscape tab in Administration editor

A

Services

Hosts

Redistribution

System Replication

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Subtabs of Performance tab in Administration editor

A

Threads

Sessions

Blocked Transactions

SQL Plan Cache

Expensive Statements Trace

Job Progress

Load

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Tools for system administration

A
  • SAP HANA Studio / Administration Console perspective
  • SAP HANA Lifecycle Manager Tools
  • SAP Solution Manager
  • SAP HANA HW Configuration Check Tool
  • SAP HANA XS apps
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Prerequisites of adding an SAP HANA System in Studio

A
  • 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.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Prerequisites of adding an SAP HANA System with a Different User

A
  • 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
17
Q

What is a link to a Centrally-Stored Archive of SAP HANA Systems?

A

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.

18
Q

What are the prerequisits for a link to a Centrally-Stored Archive of SAP HANA Systems?

A
  • 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.
19
Q

How do you Log Off From a SAP HANA System?

A

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.

20
Q

How do you Log On To an SAP HANA System?

A

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.

21
Q

How do you export a List of SAP HANA Systems?

A
  • 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.
22
Q

How do you import a List of SAP HANA Systems?

A
  • 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.
23
Q

What is the procedure of starting a SAP HANA system from HANA Studio?

A
  • 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).
24
Q

What are the prerequisities of starting a SAP HANA system from HANA Studio?

A

You have the credentials of the operating system user (adm user) that was created when the system was installed.

25
Q

What are the prerequisites of stopping a HANA system from HANA studio?

A

You have the credentials of the operating system user (adm user) that was created when the system was installed.

26
Q

What is the procedure of stopping a HANA system from HANA studio?

A
  • 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).
27
Q

What are the prerequisites of restarting a HANA system?

A

You have the credentials of the operating system user (adm user) that was created when the system was installed.

28
Q

What is the procedure of restarting a HANA system?

A
  • 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).
29
Q
A