Sap La Ha200 en 14 Ex

HA200 SAP HANA 2.0 SPS02 - Installation and Administration

. .

EXERCISES AND SOLUTIONS . Course Version: 14

SAP Copyrights and Trademarks

© 2018 SAP SE

or an SAP affiliate company. All rights reserved.

No part of this publication may be reproduced or transmitted in any form or for any purpose without the express permission of SAP SE or an SAP affiliate company. SAP and other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP SE (or an SAP affiliate company) in Germany and other countries. Please see http://global12.sap.com/ corporate-en/legal/copyri corporate-en/ legal/copyright/index.epx ght/index.epx for for additional trademark information and notices. Some software products marketed by SAP SE and its distributors contain proprietary software components of other software vendors. National product specifications may vary. These materials are provided by SAP SE or an SAP affiliate company for informational purposes only, without representation or warranty of any kind, and SAP SE or its affiliated companies shall not be liable for errors or omissions with respect to the materials. The only warranties for SAP SE or SAP affiliate company products and services are those that are set forth in the express warranty statements accompanying accompanying such products and services, if any. Nothing herein should be construed as constituting an additional warranty. In particular, SAP SE or its affiliated companies have no obligation to pursue any course of business outlined in this document or any related presentation, or to develop or release any functionality functionality mentioned therein. This document, or any related presentation, and SAP SE’s or its affiliated companies’ strategy and possible future developments, products, and/or platform directions and functionality functionality are all subject to change and may be changed by SAP SE or its affiliated companies at any time for any reason without notice. The information in this document is not a commitment, promise, or legal obligation to deliver any material, code, or functionality. functionality. All forward-looking statements statements are subject to various risks and uncertainties that could cause actual results to differ materially from expectations. Readers are cautioned not to place undue reliance on these forward-looking statements, which speak only as of their dates, and they should not be relied upon in making purchasing decisions. decisions.

SAP Copyrights and Trademarks

© 2018 SAP SE

or an SAP affiliate company. All rights reserved.

No part of this publication may be reproduced or transmitted in any form or for any purpose without the express permission of SAP SE or an SAP affiliate company. SAP and other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP SE (or an SAP affiliate company) in Germany and other countries. Please see http://global12.sap.com/ corporate-en/legal/copyri corporate-en/ legal/copyright/index.epx ght/index.epx for for additional trademark information and notices. Some software products marketed by SAP SE and its distributors contain proprietary software components of other software vendors. National product specifications may vary. These materials are provided by SAP SE or an SAP affiliate company for informational purposes only, without representation or warranty of any kind, and SAP SE or its affiliated companies shall not be liable for errors or omissions with respect to the materials. The only warranties for SAP SE or SAP affiliate company products and services are those that are set forth in the express warranty statements accompanying accompanying such products and services, if any. Nothing herein should be construed as constituting an additional warranty. In particular, SAP SE or its affiliated companies have no obligation to pursue any course of business outlined in this document or any related presentation, or to develop or release any functionality functionality mentioned therein. This document, or any related presentation, and SAP SE’s or its affiliated companies’ strategy and possible future developments, products, and/or platform directions and functionality functionality are all subject to change and may be changed by SAP SE or its affiliated companies at any time for any reason without notice. The information in this document is not a commitment, promise, or legal obligation to deliver any material, code, or functionality. functionality. All forward-looking statements statements are subject to various risks and uncertainties that could cause actual results to differ materially from expectations. Readers are cautioned not to place undue reliance on these forward-looking statements, which speak only as of their dates, and they should not be relied upon in making purchasing decisions. decisions.

Typographic Conventions American English is the standard used in this handbook. The following typographic conventions are also used.

This information is displayed in the instructor’s presentation

Demonstration

Procedure

Warning or Caution

Hint

Related or Additional Information

Facilitated Discussion

User interface control

Example text

Window title

Example text

© Copyright. All rights reserved.

Contents Unit 1:

SAP HANA Introduction No exercises

Unit 2:

Installation Preparations No exercises

Unit 3:

SAP HANA Installation

1

Exercise 1: Install a Single-Host SAP HANA System

Unit 4:

SAP HANA Architecture No exercises

Unit 5:

SAP HANA Cockpit 2.0

7

Exercise 2: Install SAP HANA Cockpit 2.0

12

Exercise 3: Configure and Open SAP HANA Cockpit 2.0

22

Exercise 4: Update SAP HANA Cockpit 2.0

Unit 6:

SAP HANA Scenarios and Deployment Options No exercises

Unit 7:

Post Installation Tasks

28

Exercise 5: Update SAP HANA

33

Exercise 6: Reconfigure SAP HANA cockpit

43

Exercise 7: Install the SAP HANA Interactive Education (SHINE) Content

Unit 8:

Adminstration Tools

50

Exercise 8: Work with HDBSQL

55

Exercise 9: Monitor SAP HANA with DBACockpit

64

Exercise 10: Connect to the SAP HANA Database Using SAP HANA Studio


Unit 9:

Database Administration Tasks

70

Exercise 11: Use Different Methods to Start and Stop the SAP HANA Database

77

Exercise 12: Change SAP HANA Configuration Parameters with SAP HANA Cockpit

82

Exercise 13: Monitor SAP HANA Using SAP HANA Cockpit 2.0

87

Exercise 14: Configure SAP HANA Traces

95

Exercise 15: Work with Diagnosis Files

100

Exercise 16: Analyze Queries

103

Exercise 17: Administer a Table

109

Exercise 18: Transport Changes

114

Exercise 19: Optional: Implement Mini Checks in SAP HANA studio

Unit 10:

Backup and Recovery

117

Exercise 20: Backup and Recovery

Unit 11:

Security

126

Exercise 21: Configure Data Volume and Log VolumeEncryption

128

Exercise 22: Enable Audit Policy

Unit 12:

Maintaining Users and Authorization

132

Exercise 23: Maintaining Administrative Users and Authorization



Unit 3 Exercise 1 Install a Single-Host SAP HANA System

Business Example The SAP HANA implementation project was started on SAP HANA 1.0 SPS12. With the release of SAP HANA 2.0 SPS02 , the project team wants to investigate the new features to see if SAP HANA 2.0 requires and update. To facilitate this request, you will create a sandbox system. In this sandbox you will install a Single-Host SAP HANA 1.0 SPS12 system. In later exercises you will configure and upgrade this system to SAP HANA 2.0 SPS02. Use the Microsoft Remote Desktop application to connect to the Linux desktop, and use hdblcmgui to install the single-host SAP HANA database. Note: is the placeholder for the group number that the instructor has assigned to you.

Use Remote Desktop to connect to the WTS training landscape using the credentials provided in the following table:

Note: If you are working in an with the next step.

session, skip this step and continue

Provided by your instructor


train-01

train-02

initial

initial

Use Remote Desktop to connect to the SAP HANA database server using the credentials provided in the following table:



wdflbmt7195

ha200root


ha200root

Unit 3: SAP HANA Installation

W3lcome123

W3lcome123

Install the SAP HANA database with hdbclmgui using the following data:

wdflbmt7194

wdflbmt7195

/hana/shared

/hana/shared

H94

H95

00

00

single_container

single_container

Custom

Custom

Deselect

Deselect

Deselect

Welcome1

Welcome1

Use the command line tool HDB to check that all the SAP HANA services are running.


Unit 3 Solution 1 Install a Single-Host SAP HANA System

Business Example The SAP HANA implementation project was started on SAP HANA 1.0 SPS12. With the release of SAP HANA 2.0 SPS02 , the project team wants to investigate the new features to see if SAP HANA 2.0 requires and update. To facilitate this request, you will create a sandbox system. In this sandbox you will install a Single-Host SAP HANA 1.0 SPS12 system. In later exercises you will configure and upgrade this system to SAP HANA 2.0 SPS02. Use the Microsoft Remote Desktop application to connect to the Linux desktop, and use hdblcmgui to install the single-host SAP HANA database. Note: is the placeholder for the group number that the instructor has assigned to you.

Use Remote Desktop to connect to the WTS training landscape using the credentials provided in the following table:

Note: If you are working in an with the next step.

session, skip this step and continue



train-01

train-02

initial

initial

On the Windows Desktop, open the Microsoft Windows Start menu and search for Remote Desktop Connection. Open the Microsoft Remote Desktopapplication. On the Remote Desktop Connection window, in the Computer field, enter the name provided by the instructor, and choose Connect. In the Windows Security screen, choose More choices and select the option Use a different account. Enter the and credentials from the preceding table, and choose OK. On the Remote Desktop Connection dialog box, choose Yes.



Note: You are now connected to the WTS training landscape desktop with a gray background.




wdflbmt7195

ha200root

ha200root

W3lcome123

W3lcome123

In the , open the Microsoft Windows Start menu and search for Remote Desktop Connection. Open the Microsoft Remote Desktop application. On theRemote Desktop Connection window, in the Computer field, enter the name provided by the instructor, and choose Connect. On the Remote Desktop Connection dialog box, choose Yes. On theLogin to xrdp window, enter your and credentials from the preceding table, and choose OK.

Note: You are now connected to the SAP HANA database server desktop with a green background.

Install the SAP HANA database with hdbclmgui using the following data:

wdflbmt7194

wdflbmt7195

/hana/shared

/hana/shared

H94

H95

00

00

single_container

single_container

Custom

Custom

Deselect

Deselect


Deselect

Solution 1: Install a Single-Host SAP HANA System

Welcome1

Welcome1

In the green Remote Desktop session, double-click the Training button. In the opened file explorer, double-click theInstall folder. Open the DATA_UNITS folder. Double-click the HDB_LCM_LINUX_X86_64 folder. To start the SAP HANA database installation program, double-click hdblcmgui. The Select Software Components Location window shows an overview of the detected Software Components. To continue the installation, choose Next. In the Install new SAP HANA System window, choose Install New System, and choose Next. In the Select additional components for installation window, you can install additional components during the installation. Accept the default options, and choose Next. In the Choose System Type window, select the Single-Host System option, and choose Next. In the Specify the System Properties window, enter the input data from the preceding table, and choose Next. In the Specify the Data and Log Area window, accept the default locations, and choose Next. In the Enter Certificates Hosts Properties window, accept the default option, and choose Next. In the Specify the Properties for the System Administrator window, enter and confirm the from the preceding table, and choose Next. In the Specify Password of Database User SYSTEM window, enter and confirm the from the preceding table, and choose Next. In the Specify the Properties of the SAP Host Agent User window, enter and confirm the from the preceding table, and choose Next. In the Summary window, check the installation parameters that you provided, and choose Install.

Note: The installation takes around 15 minutes.

After the installation has finished, check the logs by choosing one of the View Log buttons in the SAP HANA System installed screen. To close the opened log file, choose the Close button. Close the SAP HANA Lifecycle Managementtool by choosing the Finish button.



Use the command line tool HDB to check that all the SAP HANA services are running. To open a Terminal, right click on the green Linux desktop, and from the Context menu, choose Open in Terminal. Only for Group94: In the Terminal, execute the command su – h94adm . Only for Group95: In the Terminal, execute the command su – h95adm . In the Terminal, execute the command HDB info. This process shows an overview of the running of SAP HANA database services. To leave the adm user session, enter exit. To close the Terminal, enter exit.


Unit 5 Exercise 2 Install SAP HANA Cockpit 2.0

Business Example You have several SAP HANA database systems installed in your landscape. You want to use SAP HANA cockpit 2.0 to monitor and manage all these databases centrally. Install SAP HANA cockpit 2.0 on a central server.

Caution: SAP HANA cockpit 2.0 is a central monitoring and administration tool. In the training landscape, the SAP HANA cockpit will be installed only once on a central server. To accomplish this, Group94 and Group95 must work together on the central SAP HANA cockpit server to install and configure SAP HANA cockpit 2.0 correctly. The installation and upgrade tasks should be divided as follows: ●

Group94 will install SAP HANA cockpit 2.0

●

Group95 will update SAP HANA cockpit 2.0

Note: is the placeholder for the group number that the instructor assigned to you.

Use Remote Desktop to connect to the WTS training landscape using the data in the following table:

Note: If you are working in a with the next step.

session skip this step, and continue


Please work together with Group94

train-01


initial


Use Remote Desktop to connect to the SAP HANA cockpit server using the credentials provided in the following table:


Unit 5: SAP HANA Cockpit 2.0



wdflbmt7285


ha200root


W3lcome123


Install the SAP HANA cockpit 2.0 with hdbclmgui using the following data:

Welcome1

Write down the URLs for the SAP HANA cockpit manager and SAP HANA cockpit as shown at the end of the installation on the screen SAP HANA Cockpit System installed. SAP HANA cockpit manager URL:

SAP HANA cockpit URL:

Review the installation log files and close the SAP HANA cockpit installer.


Unit 5 Solution 2 Install SAP HANA Cockpit 2.0

Business Example You have several SAP HANA database systems installed in your landscape. You want to use SAP HANA cockpit 2.0 to monitor and manage all these databases centrally. Install SAP HANA cockpit 2.0 on a central server.



●

Group95 will update SAP HANA cockpit 2.0







train-01


initial


Skip to step 2. if you are still connected to the .



On the Windows Desktop, open the Microsoft Windows Start menu and search for Remote Desktop Connection. Open the Microsoft Remote Desktop application. On the Remote Desktop Connection window, in the Computer field, enter the name provided by the instructor, and choose Connect. In the Windows Security screen, choose More choices and select the option Use a different account. Enter the user name and password credentials from the previous table, and choose OK. On the Remote Desktop Connection dialog box, choose Yes.


Use Remote Desktop to connect to the SAP HANA cockpit server using the credentials provided in the following table:



wdflbmt7285


ha200root


W3lcome123


In the , open the Microsoft Windows Start menu and search for Remote Desktop Connection. Open the Microsoft Remote Desktop application. On the Remote Desktop Connection window, in the Computer field, enter the SAP HANA cockpit server name provided by the instructor, and choose Connect. On the Remote Desktop Connection dialog box, choose Yes. On the Login to xrdp window, enter your username and password credentials from the above table, and choose OK.

Note: You are now connected to the SAP HANA cockpit server desktop with a gray background.

Install the SAP HANA cockpit 2.0 with hdbclmgui using the following data:


Solution 2: Install SAP HANA Cockpit 2.0

Welcome1

In the gray Remote Desktop session, double-click the Training button. In the opened file explorer, choose the install folder. To start the installation, double-click hdblcmgui.sh. In the Install new SAP HANA Cockpit System window, select Install New System, and choose the Next button. In the Specify the System Properties window, review and accept the default setting, and choose the Next button. In the Specify Master Password window, in both input fields, enter the provided in the above table, and choose the Next button. In the Summary window, review the installation parameters, and choose the Install button.

Note: The installation takes approximately 30 minutes.

Write down the URLs for the SAP HANA cockpit manager and SAP HANA cockpit as shown at the end of the installation on the screen SAP HANA Cockpit System installed. SAP HANA cockpit manager URL:

SAP HANA cockpit URL:

Write down the URLs for the SAP HANA cockpit manager and SAP HANA c ockpit. Review the installation log files and close the SAP HANA cockpit installer. In the SAP HANA Cockpit System installed window, review the installation log by choosing the View Log button. To close the SAP HANA Cockpit – XML Log Viewer window, choose the Close button. To close the SAP HANA Lifecycle Management tool, choose the Finish button.


Unit 5 Exercise 3 Configure and Open SAP HANA Cockpit 2.0

Business Example You have installed SAP HANA cockpit 2.0 on a central server and want to use it for monitoring the SAP HANA databases in your landscape. Connect your SAP HANA database as a resource to the SAP HANA cockpit 2.0.

Caution: SAP HANA cockpit 2.0 is a central monitoring and administration tool. In our training landscape, SAP HANA cockpit is installed once on a central server. Both Group94 and Group95 will use this central SAP HANA cockpit 2.0 server system for system administration and monitoring.







train-01

train-02

initial

initial

From the WTS training landscape environment, open a session to your SAP HANA database server using PuTTY, and create the user account to register the SAP HANA database in SAP HANA cockpit 2.0

h94

h95

h94adm

h95adm


Exercise 3: Configure and Open SAP HANA Cockpit 2.0

wdflbmt7195

As the adm user, use the hdbsql tool to create the database user COCKPIT_MONITOR and assign the required permissions. Start SAP HANA cockpit manager and connect your SAP HANA database for monitoring and administration, using the following credentials of your SAP HANA cockpit user:

COCKPIT_ADMIN

COCKPIT_ADMIN

Welcome1

Welcome1

Register your SAP HANA database as a resource in SAP HANA cockpit manager, using the following data:

Resource screen

wdflbmt7194

wdflbmt7195

00

00

Single container

Single container

Database H94

Database H95

Technical User screen

COCKPIT_MONITOR

COCKPIT_MONITOR

Welcome1

Welcome1

Resource Groups

No groups to select

No groups to select

Contact screen

User94

User95

User94@exam ple.com H94 User


Add your Registered Resource to a Resource Group, using the following data:

General Information screen

Group94

Group95

Group for H94 databases


Resources screen

H94

H95

Cockpit Users screen

No users to select

No users to select

Create a SAP HANA cockpit user and add your Resource Group to this user account.



User Information screen

USER94

Init1234

USER95

User94@exam ple.com

Init1234 User95@exam ple.com

Cockpit Roles screen

Keep the default selection


Resource Groups screen

Group94

Group95

Use an incognito window in Google Chrome to logon to the SAP HANA cockpit and change the initial password.

USER94

USER95

Init1234

Init1234

Welcome1

Welcome1

Check the overall status of your SAP HANA database. Add the required database user credentials to get an detailed view the running SAP HANA database services.

Enter database user logon credentials for ...

SYSTEM

SYSTEM

Welcome1

Welcome1

Enter SAP Control logon credentials for ...

h94adm

h95adm

Welcome1

Welcome1

Resource Directory

H94

H95


Unit 5 Solution 3 Configure and Open SAP HANA Cockpit 2.0

Business Example You have installed SAP HANA cockpit 2.0 on a central server and want to use it for monitoring the SAP HANA databases in your landscape. Connect your SAP HANA database as a resource to the SAP HANA cockpit 2.0.








train-01

train-02

initial

initial

Skip to step 2. if you are still connected to the . On the Windows Desktop, open the Microsoft Windows Start menu and search for Remote Desktop Connection. Open the Microsoft Remote Desktop application. On the Remote Desktop Connection window, in the Computer field, enter the name provided by the instructor, and choose Connect. In the Windows Security screen, choose More choices and select the option Use a different account. Enter the user name and password c redentials from the above table, and choose OK.



On the Remote Desktop Connection dialog box, choose Yes.


From the WTS training landscape environment, open a session to your SAP HANA database server using PuTTY, and create the user account to register the SAP HANA database in SAP HANA cockpit 2.0

h94

h95

h94adm

h95adm

wdflbmt7195

To start PuTTY, in the gray Remote Desktop, open the Microsoft Windows Start menu and search for HA200_putty. In the search results, choose the option HA200_putty. From the menu options in the HA200_Putty window, choose the number for your . Press any key to start the PuTTY session. In the PuTTY Security Alert window, choose Yes to continue. You are now connected to the Linux command line on your SAP HANA database server. As the adm user, use the hdbsql tool to create the database user COCKPIT_MONITOR and assign the required permissions. Change to the SAP HANA operating system user with the following command: su — Connect to your SAP HANA database with the following command: hdbsql -n -i 00 -u SYSTEM -p Welcome1 To create the COCKPIT_MONITOR database user, enter the following SQL statement: CREATE USER COCKPIT_MONITOR PASSWORD Welcome1 NO FORCE_FIRST_PASSWORD_CHANGE; To grant the COCKPIT_MONITOR user the required authorization, enter the following SQL statements: ●

GRANT CATALOG READ to COCKPIT_MONITOR;

●

GRANT SELECT on SCHEMA _SYS_STATISTICS to COCKPIT_MONITOR;

To exit the hdbsql tool, enter the command: \q. To close the session, enter the command: exit.


Solution 3: Configure and Open SAP HANA Cockpit 2.0

To close the PuTTY session, enter the command: exit. Start SAP HANA cockpit manager and connect your SAP HANA database for monitoring and administration, using the following credentials of your SAP HANA cockpit user:

COCKPIT_ADMIN

COCKPIT_ADMIN

Welcome1

Welcome1

Use Google Chrome to connect to the SAP HANA cockpit manager via the following URL: https://wdflbmt7285.wdf.sap.corp:51023 Select ADVANCED in the Your connection is not private screen to continue the logon. In the following screen select Proceed to wdflbmt7285.wdf.sap.corp (unsafe). In the SAP HANA XS Advanced window, enter your and credentials from the above table, and choose Log On.

Caution: The user COCKPIT_ADMIN doesn't have the required authorizations for working with the SAP HANA cockpit 2.0. During the first login, the required authorizations are auto-assigned.

To get the required authorizations assigned, in the Not Authorized window, choose Yes. To return to the login screen, in the Success window, choose OK. In the SAP HANA XS Advanced window, enter your and credentials from the above table, and choose Log On. Register your SAP HANA database as a resource in SAP HANA cockpit manager, using the following data:

Resource screen

wdflbmt7194

wdflbmt7195

00

00

Single container

Single container

Database H94

Database H95


COCKPIT_MONITOR

COCKPIT_MONITOR

Welcome1

Welcome1

Resource Groups

No groups to select

No groups to select

Contact screen

User94

User95



User94@exam ple.com

H94 User


To get an overview of the Registered Resources, in the SAP HANA cockpit manager, choose Registered Resources. In the Registered Resources screen, choose the Register Resource button. In the Resource screen, in the , , , and fields, enter the data from the table. To continue, choose the Step 2 button. In the Technical User screen fill the and fields, using the credentials from the above table. To continue, choose the Step 3 button. In the Connection screen, deselect the checkboxes from Encrypt the SAP start service connection and the Encrypt the database connection. To continue, choose the Step 4 button. In the Resource Groups screen, choose the Step 5 button. Optional: In the Contact screen, enter your contact information as shown in the above table. To continue, choose the Review button. In the Register Resource Review screen, check and confirm your input. To continue, choose the Register button. To return to the SAP HANA cockpit manager home screen, choose the Back button. Add your Registered Resource to a Resource Group, using the following data:

General Information screen

Group94

Group95



Resources screen

H94

H95

Cockpit Users screen

No users to select

No users to select

From the SAP HANA cockpit manager home screen, choose Resource Groups. In the Resource Groups screen, choose the Create Group button.



In the General Information screen, enter the data from the above table in the and fields. To continue, choose the Step 2 button. In the Resources screen, choose the Add Resources button. In the dialog box, select your , and choose the OK button. To continue, choose the Step 3 button. In the Cockpit Users screen, choose the Create Group button. To return to the SAP HANA cockpit manager home screen, choose the Back button. Create a SAP HANA cockpit user and add your Resource Group to this user account.

User Information screen

USER94

Init1234

USER95

User94@exam ple.com

Init1234 User95@exam ple.com

Cockpit Roles screen



Resource Groups screen

Group94

Group95

From the SAP HANA cockpit manager home screen, choose Cockpit Users. In the Cockpit Users screen, choose the Create User button. In the User Information screen, enter the data from the above table in the , (twice) and fields. To continue, choose the Step 2 button. In the Cockpit Roles screen, keep the default role selection. To continue, choose the Step 3 button. In the Resource Groups screen, choose the Add Groups button. In the Add User to Groups pop-up windows, select your and press OK. Press the Create User button to create the user account. To return to the SAP HANA cockpit manager home screen, choose the Back button. Use an incognito window in Google Chrome to logon to the SAP HANA cockpit and change the initial password.

USER94

USER95

Init1234

Init1234



Welcome1

Welcome1

In Google Chrome, press CTRL+Shift+N to open an new incognito window. In the incognito window enter the URL to connect to the SAP HANA cockpit. Use the following URL: https://wdflbmt7285.wdf.sap.corp:51021 On the SAP HANA XS Advanced window, enter your and credentials from the above table, and choose the Log On button. In the Your current password has expired screen, enter the , the old and the (twice). To change the password press the Change Password button. Check the overall status of your SAP HANA database. In the My Resources tab, choose the Monitor Aggregated Health link to see the overall status of your SAP HANA database. To return to the SAP HANA cockpit home screen, choose the Back button. Add the required database user credentials to get an detailed view the running SAP HANA database services.

Enter database user logon credentials for ...

SYSTEM

SYSTEM

Welcome1

Welcome1


h94adm

h95adm

Welcome1

Welcome1

Resource Directory

H94

H95

In the SAP HANA cockpit home screen, choose the View resources directory link to get an overview of the resources assigned to your account. Select the Enter Credentials link to enter the database connection credentials. In the Enter database user logon credentials for ... dialog box, enter your and from the above table, and choose OK. Select Connect link to enter the SAP Control Credentials. In the Enter SAP Control logon credentials for ... dialog box, enter your and from the above table, and choose Save. To open a detail overview screen of your SAP HANA database choose your in the Resource Directory screen. The detailed overview screen of your SAP HANA database opens.



To get an overview of the running SAP HANA services choose the Overall Database Status tile. Status tile. To return to the SAP HANA cockpit home screen, choose the Home button. Home button.


Unit 5 Exercise 4 Update SAP HANA Cockpit 2.0

Business Example During the planned data center maintenance window you also need to update your central SAP HANA Cockpit 2.0. The newer version will provide you with additional multitenant features that you require in your S AP HANA 2.0 MDC system landscape.



●

Group95 will upgrade SAP HANA cockpit 2.0


Use Remote Desktop to connect to the WTS training landscape using landscape using the data in the following table:






train-01


initial

Use Remote Desktop to connect to the SAP HANA cockpit server using server using the data in the following table:


Exercise 4: Update SAP HANA Cockpit 2.0




wdflbmt7285


ha200root


W3lcome123

Update SAP HANA cockpit 2.0 to the latest version available on the training landscape. Use the hdblcmgui and the data in the table below.

Welcome1

Welcome1

Review the update log files and close the SAP HANA cockpit hdblcm tool. Check the version number of the updated SAP HANA cockpit.

SAP HANA XS Advanced screen vanced screen


USER94

USER95

Welcome1

Welcome1

Unit 5 Solution 4 Update SAP HANA Cockpit 2.0

Business Example During the planned data center maintenance window you also need to update your central SAP HANA Cockpit 2.0. The newer version will provide you with additional multitenant features that you require in your S AP HANA 2.0 MDC system landscape.



●

Group95 will upgrade SAP HANA cockpit 2.0








train-01


initial

Skip to step 2. if you are still connected to the .


Solution 4: Update SAP HANA Cockpit 2.0

On the Windows Desktop, open the Microsoft Windows Start menu and search for Remote Desktop Connection. Open the Microsoft Remote Desktop application. On the Remote Desktop Connection window, in the Computer field, enter the name provided by the instructor, and choose Connect. In the Windows Security screen, choose More choices and select the option Use a different account. Enter the user name and password c redentials from the above table, and choose OK. On the Remote Desktop Connection dialog box, choose Yes.


Use Remote Desktop to connect to the SAP HANA cockpit server using the data in the following table:




wdflbmt7285


ha200root


W3lcome123

Skip to step 3. if you are still connected to the Remote Desktop session of the SAP HANA cockpit server. In the , open the Microsoft Windows Start menu and search for Remote Desktop Connection. Open the Microsoft Remote Desktop application. On the Remote Desktop Connection window, in the Computer field, enter your name provided by the instructor, and choose Connect. On the Remote Desktop Connection dialog box, choose Yes. On the Login to xrdp window, enter your user name and password credentials from the above table, and choose OK.

Note: You are now connected to the SAP HANA cockpit server desktop with a gray background.

Update SAP HANA cockpit 2.0 to the latest version available on the training landscape. Use the hdblcmgui and the data in the table below.



Welcome1

Welcome1

In the gray Remote Desktop session, on the SAP HANA cockpit server, double-click the Training button. In the opened file explorer, choose the upgrade folder. To start the update, double-click hdblcmgui.sh. In the Choose system to update, or choose installation window, select Update existing system, and choose the SID H4C. To continue the update select the Next button. In the Choose components to be installed or updated for system ‘H4C’ window, review and accept the proposed setting, and choose the Next button. In the Specify authorization data window, enter the password in the field and as provided in the above table, and choose the Next button. In the Specify XS Advanced Runtime Properties window, enter the password in the field as provided in the above table, and choose the Next button. In the Summary window, review the update parameters, and choose the Update button.

Note: The update takes approximately 35 minutes.

Review the update log files and close the SAP HANA cockpit hdblcm tool. In the SAP HANA Cockpit Components updated window, review the update log by choosing the View Log button. To close the SAP HANA Cockpit – XML Log Viewer window, choose the Close button. To close the SAP HANA Lifecycle Management tool, choose the Finish button. Check the version number of the updated SAP HANA cockpit.

SAP HANA XS Advanced screen


USER94

USER95

Welcome1

Welcome1

Solution 4: Update SAP HANA Cockpit 2.0

In the gray Remote Desktop session, close all Google Chrome windows, then open a fresh Google Chrome window to Logon to the SAP HANA cockpit. Connect to the SAP HANA cockpit u sing the following URL: https://wdflbmt7285.wdf.sap.corp:51021 In the SAP HANA XS Advanced window, to log in, enter your and from the above table and press the Log On button. In the SAP HANA Cockpit window, select your in the top right corner. From the drop-down menu select the option About. In the pop-up window About SAP HANA Cockpit, find and write down the SAP HANA Cockpit version number. SAP HANA Cockpit version number:

Close the About SAP HANA Cockpit window by pressing the OK button.


Unit 7 Exercise 5 Update SAP HANA

Business Example The project team members requested an SAP HANA 2.0 sandbox system so that they can learn about the newest SAP HANA 2.0 fe atures. To facilitate this request, you will update the Single-Host SAP HANA SPS12 sandbox system to S AP HANA 2.0. You downloaded the current SAP HANA 2.0 SPS02 version from http://support.sap.com http://support.sap.com and and stored it on the SAP HANA Linux server in the /data/training/setup/upgrade directory. Update the SAP HANA 1.0 system to the SAP HANA 2.0 using the SAP HANA lifecycle management tools. Use the Microsoft Remote Desktop application to connect to the Linux desktop, and use hdblcmgui to update the single-host SAP HANA database that you previously installed. Note: is the placeholder for the group number that the instructor assigned to you.

Use Remote Desktop to connect to the WTS training landscape using landscape using the credentials provided in the following table:



Provid Provided ed by your your instru instructo ctorr


train-01

train-02

initial

initial

Use Remote Desktop to connect to the SAP HANA database server using server using the credentials provided in the following table:



wdflbmt7195

ha200root


ha200root

Exercise 5: Update SAP HANA

W3lcome123

W3lcome123

Update the SAP HANA using the hdblcmgui tool for the following groups:

adm) Password>

H94 Welcome1

H95 Welcome1

SYSTEM

SYSTEM

Welcome1

Welcome1

Welcome1

Welcome1

Welcome1

Welcome1

Use the command line tool HDB to check the new version SAP HANA database for the following groups:


H94

H95

Unit 7 Solution 5 Update SAP HANA

Business Example The project team members requested an SAP HANA 2.0 sandbox system so that they can learn about the newest SAP HANA 2.0 fe atures. To facilitate this request, you will update the Single-Host SAP HANA SPS12 sandbox system to S AP HANA 2.0. You downloaded the current SAP HANA 2.0 SPS02 version from http://support.sap.com http://support.sap.com and and stored it on the SAP HANA Linux server in the /data/training/setup/upgrade directory. Update the SAP HANA 1.0 system to the SAP HANA 2.0 using the SAP HANA lifecycle management tools. Use the Microsoft Remote Desktop application to connect to the Linux desktop, and use hdblcmgui to update the single-host SAP HANA database that you previously installed. Note: is the placeholder for the group number that the instructor assigned to you.

Use Remote Desktop to connect to the WTS training landscape using landscape using the credentials provided in the following table:





train-01

train-02

initial

initial

Skip to step 2. if you are still connected to the . landscape>. On the Windows Desktop, open the Microsoft Windows Start menu and search for Remote Desktop Connection. Connection. Open the Microsoft Remote Desktop application. On the Remote Desktop Connection window, Connection window, in the Computer field, Computer field, enter the name landscape> name provided by the instructor, and choose Connect. Connect. In the Windows Security screen, Security screen, choose More choices and choices and select the option Use a different account. account. Enter the user name and password c redentials from the above table, and choose OK. OK.


Solution 5: Update SAP HANA






wdflbmt7195

ha200root

ha200root

W3lcome123

W3lcome123

In the , open the Microsoft Windows Start menu and search for Remote Desktop Connection. Open the Microsoft Remote Desktop application. On the Remote Desktop Connection window, in the Computer field, enter the name provided by the instructor, and choose Connect. On the Remote Desktop Connection dialog box, choose Yes. On the Login to xrdp window, enter your user name and password credentials from the above table, and choose OK.

Note: You are now connected to the SAP HANA database server desktop with a green background.

Update the SAP HANA using the hdblcmgui tool for the following groups:

adm) Password>

H94 Welcome1

H95 Welcome1

SYSTEM

SYSTEM

Welcome1

Welcome1

Welcome1

Welcome1

Welcome1


Unit 7: Post Installation Tasks

On the green Linux desktop, double-click the Training button. In the file explorer, double-click the upgrade folder. Double-click DATA_UNITS, and choose HDB_LCM_LINUX_X86_64. The SAP HANA 2.0 Lifecycle Management tools directory opens. In the HDB_LCM_LINUX_X86_64 directory, open the context menu (right mouse click) and select the option Open in Terminal. To start the SAP HANA 2.0 Lifecycle Management tool, from the Terminal window type the command ./hdblcmgui and press Enter. On the Select Software Components Location screen, an overview screen shows the detected Software Components. Choose Next to continue the update. On the Choose system to update, or choose installation screen, select your in the Update existing System area. To continue choose Next. On the Choose components to be installed or updated f or system ‘’ screen, accept the default selection, and choose Next. On the Specify authorization data screen, enter the password you used during the installation of the system. Use the default values from the above table for the user name and passwords: Choose Next. On the Summary screen, check your input, and choose Update. The update takes around 25 minutes. When the update finishes, check the logs by choosing the View Log button in the SAP HANA Components updated screen. To close the opened log file, choose the Close button. To close the SAP HANA Lifecycle Management tool, choose Finish. Use the command line tool HDB to check the new version SAP HANA database for the following groups:

H94

H95

To open a Terminal, right-click the green Linux desktop, and choose Open in Terminal from the context menu. In the Terminal, enter the following command: su – adm . In the Terminal, enter the following command: HDB version. The 2.00.020 part of the version number shows that the update to SAP HANA 2.0 was successful. To leave the adm session type: exit To close the Terminal type: exit


Unit 7 Exercise 6 Reconfigure SAP HANA cockpit

Business Example You have updated your SAP HANA 1.0 database to SAP HANA 2.0 SPS02. This update means that the database was automatically converted to Multitenant Database Container (MDC). This change to MDC isn’t yet reflected in your SAP HANA cockpit 2.0 landscape setup. The new SYSTEMDB configuration needs to be added to the SAP HANA cockpit 2.0 landscape configuration.







train-01

train-02

initial

initial

From the WTS training landscape environment, open a session to your SAP HANA database server using PuTTY, and create the user account to register the SAP HANA SYSTEMDB database in SAP HANA cockpit 2.0

h94

h95

h94adm

h95adm

wdflbmt7195

As the adm user, use the hdbsql tool to create the database user COCKPIT_MONITOR and assign the required permissions.



Start Google Chrome and log on to your SAP HANA cockpit manager

COCKPIT_ADMIN

COCKPIT_ADMIN

Welcome1

Welcome1

Register your SAP HANA SYSTEM database as a resource in SAP HANA cockpit manager, using the following data:

Resource screen

wdflbmt7194

wdflbmt7195

00

00

System database

System database

SYSTEMDB H94

SYSTEMDB H95


COCKPIT_MONITOR

COCKPIT_MONITOR

Welcome1

Welcome1

Resource Groups

Group94

Group95

Contact screen

User94

User95



Register your SAP HANA Tenant database as a resource in SAP HANA cockpit manager, using the following data:

Resource screen

wdflbmt7194

wdflbmt7195

00

00

Tenant database

Tenant database

H94

H95

Tenant H94

Tenant H95


COCKPIT_MONITOR

COCKPIT_MONITOR

Welcome1

Welcome1

Resource Groups

Group94

Group95

Contact screen

User94

User95


User94@exam ple.com

User95@exam ple.com

Exercise 6: Reconfigure SAP HANA cockpit

H94 User

H95 User

Unregister the single tenant database. Now that you have converted to a multitenant database you can remove the single tenant that you have registered in a previous exercise.

Resource Details

H94

H95

Use an incognito window in Google Chrome to logon to the SAP HANA cockpit 2.0 and add the required credentials for the SYSTEMDB.

Log On screen

USER94

USER95

Welcome1

Welcome1

Enter database user logon credentials for SYSTEMDB@...

SYSTEM

SYSTEM

Welcome1

Welcome1


h94adm

h95adm

Welcome1

Welcome1

Resource Directory

SYSTEMDB@H94

SYSTEMDB@H95

Add the required credentials for the Tenant database.

Log On screen

USER94

USER95

Welcome1

Welcome1


SYSTEM

SYSTEM

Welcome1

Welcome1


h94adm

h95adm

Welcome1

Welcome1

Resource Directory

H94@H94

H95@H95


Unit 7 Solution 6 Reconfigure SAP HANA cockpit

Business Example You have updated your SAP HANA 1.0 database to SAP HANA 2.0 SPS02. This update means that the database was automatically converted to Multitenant Database Container (MDC). This change to MDC isn’t yet reflected in your SAP HANA cockpit 2.0 landscape setup. The new SYSTEMDB configuration needs to be added to the SAP HANA cockpit 2.0 landscape configuration.







train-01

train-02

initial

initial

Skip to step 2. if you are still connected to the . On the Windows Desktop, open the Microsoft Windows Start menu and search for Remote Desktop Connection. Open the Microsoft Remote Desktop application. On the Remote Desktop Connection window, in the Computer field, enter the name provided by the instructor, and choose Connect. In the Windows Security screen, choose More choices and select the option Use a different account. Enter the user name and password c redentials from the above table, and choose OK. On the Remote Desktop Connection dialog box, choose Yes.


Solution 6: Reconfigure SAP HANA cockpit



h94

h95

h94adm

h95adm

wdflbmt7195

To start PuTTY, in the gray Remote Desktop, open the Microsoft Windows Start menu and search for HA200_putty. In the search results, choose the option HA200_putty. From the menu options in the HA200_Putty window, choose the number for your . Press any key to start the PuTTY session. You are now connected to the Linux command line on your SAP HANA database server. As the adm user, use the hdbsql tool to create the database user COCKPIT_MONITOR and assign the required permissions. Change to the SAP HANA operating system user with the following command: su — Connect to your SAP HANA database with the following command: hdbsql -n -i 00 -d SYSTEMDB -u SYSTEM -p Welcome1 To create the COCKPIT_MONITOR database user, enter the following SQL statement: CREATE USER COCKPIT_MONITOR PASSWORD Welcome1 NO FORCE_FIRST_PASSWORD_CHANGE; To grant the COCKPIT_MONITOR user the required authorization, enter the following SQL statements: ●

GRANT CATALOG READ to COCKPIT_MONITOR;

●

GRANT SELECT on SCHEMA _SYS_STATISTICS to COCKPIT_MONITOR;

To exit the hdbsql tool, enter the command: \q. To close the session, enter the command: exit. To close the PuTTY session, enter the command: exit.



Start Google Chrome and log on to your SAP HANA cockpit manager

COCKPIT_ADMIN

COCKPIT_ADMIN

Welcome1

Welcome1

Use Google Chrome to connect to the SAP HANA cockpit manager via the following URL: https://wdflbmt7285.wdf.sap.corp:51023 In the SAP HANA XS Advanced window, enter your and credentials from the above table, and choose Log On. Register your SAP HANA SYSTEM database as a resource in SAP HANA cockpit manager, using the following data:

Resource screen

wdflbmt7194

wdflbmt7195

00

00

System database

System database

SYSTEMDB H94

SYSTEMDB H95


COCKPIT_MONITOR

COCKPIT_MONITOR

Welcome1

Welcome1

Resource Groups

Group94

Group95

Contact screen

User94

User95

User94@exam ple.com

H94 User


To get an overview of the Registered Resources, in the SAP HANA cockpit manager, choose Registered Resources. In the Registered Resources screen, choose the Register Resource button. In the Resource screen, in the , , , and fields, enter the data from the above table. To continue, choose the Step 2 button. In the Technical User screen fill the and fields, using the credentials from the above table. To continue, choose the Step 3 button. In the Connection screen, deselect the checkboxes from Encrypt the SAP start service connection and the Encrypt the database connection.



To continue, choose the Step 4 button. In the Resource Groups screen, choose the Add Group button. In the Add Resource To Groups window, select your and press the OK button. To continue, choose the Step 5 button. In the Contact screen, enter your contact information as shown in the above table. To continue, choose the Review button. In the Register Resource Review screen, check and confirm your input. To continue, choose the Register button. To return to the SAP HANA cockpit manager home screen, choose the Back button. Register your SAP HANA Tenant database as a resource in SAP HANA cockpit manager, using the following data:

Resource screen

wdflbmt7194

wdflbmt7195

00

00

Tenant database

Tenant database

H94

H95

Tenant H94

Tenant H95


COCKPIT_MONITOR

COCKPIT_MONITOR

Welcome1

Welcome1

Resource Groups

Group94

Group95

Contact screen

User94

User95

User94@exam ple.com

H94 User


To get an overview of the Registered Resources, in the SAP HANA cockpit manager, choose Registered Resources. In the Registered Resources screen, choose the Register Resource button. In the Resource screen, in the , , , and fields, enter the data from the above table. To continue, choose the Step 2 button. In the Technical User screen, fill the and fields, using the credentials from the above table. To continue, choose the Step 3 button.



In the Connection screen, deselect the checkboxes from Encrypt the SAP start service connection and the Encrypt the database connection. To continue, choose the Step 4 button. In the Resource Groups screen, choose the Add Group button. In the Add Resource To Groups window, select your and press the OK button. To continue, choose the Step 5 button. In the Contact screen, enter your contact information as shown in the above table. To continue, choose the Review button. In the Register Resource Review screen, check and confirm your input. To continue, choose the Register button. You will return to the Resource Details screen. In this screen you see al the registered resources. Unregister the single tenant database. Now that you have converted to a multitenant database you can remove the single tenant that you have registered in a previous exercise.

Resource Details

H94

H95

In the Resource Details screen, select your and press the Unregister button. In the Confirm Request screen, press the Yes button. To return to the SAP HANA cockpit manager home screen, choose the Back button. Use an incognito window in Google Chrome to logon to the SAP HANA cockpit 2.0 and add the required credentials for the SYSTEMDB.

Log On screen

USER94

USER95

Welcome1

Welcome1


SYSTEM

SYSTEM

Welcome1

Welcome1


h94adm

h95adm

Welcome1

Welcome1

Resource Directory

SYSTEMDB@H94

SYSTEMDB@H95

In Google Chrome press the keyboard combination Ctrl+Shift+N to open an new incognito window.



In the incognito window, enter the URL to connect to the SAP HANA cockpit. Use the following URL: https://wdflbmt7285.wdf.sap.corp:51021 On the SAP HANA XS Advanced window, enter your and credentials from the above table, and choose Log On button. In the SAP HANA cockpit home screen, choose the View resources directory link to get an overview of the resources assigned to your account. Select the Enter Credentials link for the SYSTEMDB to enter the SYSTEMDB connection credentials. In the Enter database user logon credentials for SYSTEMDB@... dialog box, enter your and from the above table, and choose OK. Select Enter Credentials link for the SYSTEMDB to enter the SAP Control Credentials. In the Enter SAP Control logon credentials for ... dialog box, enter your and from the above table, and choose Save. To open a detail overview screen of your SAP HANA database choose your in the Resource Directory screen. The detailed overview screen of your SAP HANA SYSTEMDB database opens. To get an overview of the running SAP HANA Tenants choose the Overall Tenant Statuses tile. Return to the Resource Directory screen, choose the Back button (twice). Add the required credentials for the Tenant database.

Log On screen

USER94

USER95

Welcome1

Welcome1


SYSTEM

SYSTEM

Welcome1

Welcome1


h94adm

h95adm

Welcome1

Welcome1

Resource Directory

H94@H94

H95@H95

Select the Enter Credentials link for the to enter the Tenant database connection credentials. In the Enter database user logon credentials for dialog box, enter your and from the above table, and choose OK. Select Enter Credentials link for the to enter the SAP Control Credentials. In the Enter SAP Control logon credentials for ... dialog box, enter your and from the above table, and choose Save.



To open a detail overview screen of your SAP HANA database choose your in the Resource Directory screen. The detailed overview screen of your SAP HANA tenant database opens. To get an overview of the running SAP HANA services for this tenant, choose the Overall Database Status tile. To return to the SAP HANA cockpit home screen, choose the Home button.


Unit 7 Exercise 7 Install the SAP HANA Interactive Education (SHINE) Content

Business Example During the SAP HANA implementation project, the SAP HANA developers and modelers need a sandbox system where they can practice using the newest SAP HANA features. Install the SAP HANA Interactive Education (SHINE) demo content on the sandbox system.


Extract the SHINE package from the SAP HANA Installation DVD so that you can import it into the SAP HANA database. Use Remote Desktop to connect to the WTS training landscape using the data in the following table:





train-01

train-02

initial

initial

Copy the SAP HANA SHINE package to your local session in the folder N:\HA200. Unpack the SAP HANA SHINE package HCODEMOCONTENT202_0-20011690.ZIP in the N:\HA200 folder. Assign the Administrator role for the SAP HANA application lifecycle management tool to the SYSTEM user.

USER94

USER95

Welcome1

Welcome1



H94@H94

H95@H94

Use the SAP HANA application lifecycle management to import the SAP HANA SHINE content. Start the SAP HANA application lifecycle management (HALM) application in Google Chrome. Use the following credentials:

wdflbmt7194

wdflbmt7195

SYSTEM

SYSTEM

Welcome1

Welcome1

Import the SHINE Delivery Unit from the HCO_DEMOCONTENT.tgz file.

The demo application includes definitions for two new roles that are required to generate or reload demo data, or to view the demo application. To perform the post-installation step for SHINE, assign the role sap.hana.democontent.epm.roles::Admin to your administrator account. Assign the SAP HANA SHINE Administrator role to the user SYSTEM.

Now that the SHINE content is imported correctly, you need to generate some time data and table synonyms. In a Web browser, go to https://:4300/sap/hana/democontent/epm. Use the following credentials:

wdflbmt7194

wdflbmt7195

SYSTEM

SYSTEM

Welcome1

Welcome1

Check the prerequisites for time data and synonyms.

Explore the SAP HANA SHINE demo application.


Unit 7 Solution 7 Install the SAP HANA Interactive Education (SHINE) Content

Business Example During the SAP HANA implementation project, the SAP HANA developers and modelers need a sandbox system where they can practice using the newest SAP HANA features. Install the SAP HANA Interactive Education (SHINE) demo content on the sandbox system.


Extract the SHINE package from the SAP HANA Installation DVD so that you can import it into the SAP HANA database. Use Remote Desktop to connect to the WTS training landscape using the data in the following table:





train-01

train-02

initial

initial





Copy the SAP HANA SHINE package to your local session in the folder N:\HA200. In the WTS training landscape session, choose the Windows Menu button, and choose the Initialize Course tile. The File Explorer opens. In the File Explorer, choose the HA200 folder. Double-click the Initialize_HA200 file. In the Initialize HA200 dialog box, choose Yes to copy all the required course files to the N:\HA200 folder . All the required course files are located in the N:\HA200 folder. Unpack the SAP HANA SHINE package HCODEMOCONTENT202_0-20011690.ZIP in the N:\HA200 folder. In the WTS training landscape session, choose the Windows Menu button. In the search box, enter the path N:\HA200, and open it. Extract the HCODEMOCONTENT202_0-20011690.ZIP file using the context menu option Extract to HCODEMOCONTENT202_0-20011690. Assign the Administrator role for the SAP HANA application lifecycle management tool to the SYSTEM user.

USER94

USER95

Welcome1

Welcome1

H94@H94

H95@H94

Start Google Chrome and open the SAP HANA cockpit 2.0 using the URL: https:// wdflbmt7285:51021. In the SAP HANA XS Advanced screen, enter your and and press the Log On button. In the Recently Accessed area, choose your . In your SAP HANA cockpit, scroll to the User & Role Management area and choose the Assign role to users link. Search for the SYSTEM user. In the Assign Roles screen, choose the Edit button. Choose the Assign Roles link.


Solution 7: Install the SAP HANA Interactive Education (SHINE) Content

In the Select Roles dialog box, search for the role: sap.hana.xs.lm.roles::Administrator . Mark the sap.hana.xs.lm.roles::Administrator role, and choose OK. Choose Save in the Assign Roles screen. Do NOT close the Assign role to users application. In a later task you need this application again. Use the SAP HANA application lifecycle management to import the SAP HANA SHINE content. Start the SAP HANA application lifecycle management (HALM) application in Google Chrome. Use the following credentials:

wdflbmt7194

wdflbmt7195

SYSTEM

SYSTEM

Welcome1

Welcome1

In Google Chrome, open a new tab by pressing the keyboard combination Ctrl+T. Open the URL https://:4300/sap/hana/xs/lm/index.html. Select ADVANCED in the Your connection is not private screen to continue the logon. In the following screen select Proceed to .wdf.sap.corp (unsafe). In the SAP HANA Logon window, enter your user name and password credentials from the above table, and choose Log On. Import the SHINE Delivery Unit from the HCO_DEMOCONTENT.tgz file. On the HANA Application Lifecycle Management window, choose Delivery Units. Choose Import. In the Import Delivery Unit dialog box, choose Browse. Navigate to the N:\HA200\HCODEMOCONTENT202_0-20011690 folder on your local system. Choose the HCO_DEMOCONTENT.tgz file. Choose Open. In the Import Delivery Unit dialog box, choose Import. In the Confirm Import of Delivery Unit dialog box, choose Import. The SHINE import takes around 2 minutes. Check that the message The import Operation Finished displays. The demo application includes definitions for two new roles that are required to generate or reload demo data, or to view the demo application. To perform the post-installation step for



SHINE, assign the role sap.hana.democontent.epm.roles::Admin to your administrator account. Assign the SAP HANA SHINE Administrator role to the user SYSTEM. Return to the browser tab Assign role to users application in SAP HANA Cockpit. The application Assign Roles for the SYSTEM user should still be open. In the Assign Roles screen, choose the Edit button in the bottom left corner. Choose the Assign Roles link. In the Select Roles dialog box, search for the role:

sap.hana.democontent.epm.roles::Admin Mark the role sap.hana.democontent.epm.roles::Admin, and choose OK. Choose Save in the Assign Roles screen. To return to the SAP HANA cockpit home screen, choose the Home button.

Now that the SHINE content is imported correctly, you need to generate some time data and table synonyms. In a Web browser, go to https://:4300/sap/hana/democontent/epm. Use the following credentials:

wdflbmt7194

wdflbmt7195

SYSTEM

SYSTEM

Welcome1

Welcome1

In Google Chrome, open a new tab by pressing the keyboard combination Ctrl+T. Open the URL https://:4300/sap/hana/democontent/epm. If requested, in the SAP HANA Logon window, enter your user name and password credentials from the above table, and choose Log On.

Check the prerequisites for time data and synonyms. In the SHINE (SAP HANA Interactive Education) dialog box, choose Check Prerequisites. To generate the time data and the synonyms, choose the Generate Time Data and Create Synonyms buttons. Choose OK. When the prerequisites check is complete, choose OK.

Explore the SAP HANA SHINE demo application. On the SHINE (SAP HANA Interactive Education) window, choose Sales Dashboard.


Solution 7: Install the SAP HANA Interactive Education (SHINE) Content

In the Sales Dashboard dialog box, choose Continue. View the data. To return to the main screen, choose the browser Back button. On the SHINE (SAP HANA Interactive Education) window, choose Purchase Order Worklist. In the Purchase Order Worklist dialog box, choose Continue. View the data. To return to the main screen, choose the browser Back button. To view other applications, choose the appropriate tile on the SHINE (SAP HANA Interactive Education) window.


Unit 8 Exercise 8 Work with HDBSQL

Business Example You want to execute statements against your SAP HANA database, but you do not have a graphical user interface available to use the SAP HANA Studio. Perform these activities using HDBSQL. Open PuTTY and connect to the SAP HANA database with user adm. Use Remote Desktop to connect to the WTS training landscape using the data in the following table:





train-01

train-02

initial

initial


h94

h95

h94adm

h95adm

wdflbmt7195

As the adm user, use the hdbsql tool to create the database user COCKPIT_MONITOR and assign the required permissions.

Log on to your SAP HANA database using HDBSQL, specifying the credentials of us er SYSTEM directly. Log on to the SAP HANA database, using the credentials of user SYSTEM.


Exercise 8: Work with HDBSQL

H94

H95 wdflbmt7195

Test whether the connection works by executing a command. Display an overview of the hdbsql c ommands. Display general information about the database Close hdbsql.

Display the content of the hdbuserstore.

H94

H95

wdflbmt7194

wdflbmt7195

Create a user key for database user SYSTEM in the user store, and store the password under this user key.

Connect to your SAP HANA database using the hdbuserstore entry. Log on to the SAP HANA database using the user store key. Test whether the connection works by executing a command. Close hdbsql.


Unit 8 Solution 8 Work with HDBSQL

Business Example You want to execute statements against your SAP HANA database, but you do not have a graphical user interface available to use the SAP HANA Studio. Perform these activities using HDBSQL. Open PuTTY and connect to the SAP HANA database with user adm. Use Remote Desktop to connect to the WTS training landscape using the data in the following table:





train-01

train-02

initial

initial

Skip to step 2. if you are still connected to the . On the Windows Desktop, open the Microsoft Windows Start menu and search for Remote Desktop Connection. Open the Microsoft Remote Desktop application. On theRemote Desktop Connection window, in the Computer field, enter the name provided by the instructor, and choose Connect. In theWindows Security screen, choose More choices and select the option Use a different account. Enter the and credentials from the preceding table, and choose OK. On the Remote Desktop Connection dialog box, choose Yes.



Solution 8: Work with HDBSQL


h94

h95

h94adm

h95adm

wdflbmt7195

To start PuTTY, in the gray Remote Desktop, open the Microsoft Windows Start menu and search for HA200_putty. In the search results, choose the option HA200_putty. From the menu options in the HA200_Putty window, choose the number for your . Press any key to start the PuTTY session. You are now connected to the Linux command line on your SAP HANA database server. As the adm user, use the hdbsql tool to create the database user COCKPIT_MONITOR and assign the required permissions. Change to the SAP HANA operating system user with the following command: su —

Log on to your SAP HANA database using HDBSQL, specifying the credentials of us er SYSTEM directly. Log on to the SAP HANA database, using the credentials of user SYSTEM.

H94

H95 wdflbmt7195

Connect to your SAP HANA database with the following command: hdbsql -n -i 00 -d -u SYSTEM -p Welcome1 Test whether the connection works by executing a command. To test whether the connection works, execute the following command: SELECT * FROM dummy. To leave the result screen, enter q . Display an overview of the hdbsql c ommands. Enter the following command: \h. Display general information about the database


Unit 8: Adminstration Tools

Enter the following command: \s. Close hdbsql. To close the hdbsql, enter the following command: \q .

Display the content of the hdbuserstore.

H94

H95

wdflbmt7194

wdflbmt7195

Enter the following command: hdbuserstore LIST. The result shows that the hdbuserstore is empty, and that the data file is located in the /usr/sap//home/.hdb//SSFS_HDB.DAT directory. Create a user key for database user SYSTEM in the user store, and store the password under this user key. Enter the following command: hdbuserstore SET MYSYSTEM localhost:30015 SYSTEM Welcome1 . To show the content of the hdbuse rstore, enter the following command: hdbuserstore LIST . The new key MYSYSTEM is created, as follows: KEY MYSYSTEM ENV : localhost:30015 USER: SYSTEM Connect to your SAP HANA database using the hdbuserstore entry. Log on to the SAP HANA database using the user store key. Enter the following command: hdbsql -U MYSYSTEM . Test whether the connection works by executing a command. To test whether the connection works, enter the following command: SELECT * FROM dummy. To leave the result screen, enter the following command: q . Close hdbsql. To close the hdbsql, enter the following command: \q .


Unit 8 Exercise 9 Monitor SAP HANA with DBACockpit

Business Example You already use the SAP ABAP transaction DBACOCKPIT to monitor database management systems other than SAP HANA. Now you want to monitor SAP HANA using this tool.






train-01

train-02

initial

initial

Attention: This step only needs to be performed by Group94. From the WTS training landscape environment, open a session to the SAP HANA Cockpit server wdflbmt7285 using PuTTY. Attention: This step only needs to be performed by Group94. Start the SAP HANA database H4H and the SAP NetWeaver system T4H on the Linux Server wdflbmt7285. Log on to the ABAP system T4H using the following credentials:

User Password

STUDENT-01

STUDENT-02

Welcome1

Welcome1

Remember to include the dash when entering STUDENT-## . Using DBACOCKPIT, check the SAP HANA Services. Using DBACOCKPIT, determine the configuration for the SAVEPOINT interval. Using DBACOCKPIT, determine the execution of the SAVEPOINTs. Review the content of the HOST_SAVEPOINTS table in the _SYS_STATISTICS schema.



Using DBACOCKPIT, review the definition of the USR02 table in the SAPT4H schema using the following data:

Schema

Table/View

SAPT4H

USR*

Connect to Linux Server wdflbmt7285 using PuTTY, log on as ha200root, and run su t4hadm . If you are already connected, proceed to the next step. List the entries of the hdbuserstore, and examine the DEFAULT key.

Create a new SYSTEM Connection to your standalone SAP HANA system for the following hostnames and SAP HANA systems:

wdflbmt7194.wdf.sap.c wdflbmt7195.wdf.sap.c orp orp

H94

H95

Connection Name

_DBC

_DBC

Database System

SAP HANA database

SAP HANA database

Connection Maximum

100

100

Connection Optimum

100

100

User Name

SYSTEM

SYSTEM

Welcome1

Welcome1

wdflbmt7194

wdflbmt7195

30015

30015

Password

Database Host SQL Port

Note that 30015 means 3++index server. Test the new DBACOCKPIT connection to SAP HANA. Using DBACOCKPIT, determine the configuration for the SAVEPOINT interval. Using DBACOCKPIT, review the definition of the sap.hana.democontent.epm.data::MD.Products table in the SAP_HANA_DEMO schema using the following data:

Schema


SAP_HANA_DEMO

Exercise 9: Monitor SAP HANA with DBACockpit

Table/View

*

Attention: This step only needs to be performed by Group94. Stop the SAP HANA database H4H and the SAP NetWeaver system T4H on the Linux Server wdflbmt7285. The SAP NetWeaver ABAP system will not be used during the rest of the course, so to reclaim the resources you can shut it down.


Unit 8 Solution 9 Monitor SAP HANA with DBACockpit

Business Example You already use the SAP ABAP transaction DBACOCKPIT to monitor database management systems other than SAP HANA. Now you want to monitor SAP HANA using this tool.






train-01

train-02

initial

initial

Skip to step 2. if you are still connected to the . On the Windows Desktop, open the Microsoft Windows Start menu and search for Remote Desktop Connection. Open the Microsoft Remote Desktop application. On the Remote Desktop Connection window, in the Computer field, enter the name provided by the instructor, and choose Connect. In theWindows Security screen, choose More choices and select the option Use a different account. Enter the and credentials from the above table, and choose OK. On the Remote Desktop Connection dialog box, choose Yes.



Solution 9: Monitor SAP HANA with DBACockpit

Attention: This step only needs to be performed by Group94. From the WTS training landscape environment, open a session to the SAP HANA Cockpit server wdflbmt7285 using PuTTY. To start PuTTY, in the gray Remote Desktop, open the Microsoft Windows Start menu and search for HA200_putty. In the search results, choose the option HA200_putty. From the menu options in the HA200_Putty window, choose the menu option (3) to connect to the server wdflbmt7285. Press any key to start the PuTTY session. You are now connected to the Linux command line on the wdflbmt7285 server. Attention: This step only needs to be performed by Group94. Start the SAP HANA database H4H and the SAP NetWeaver system T4H on the Linux Server wdflbmt7285. Enter the following command: su — h4hadm . Enter the command: HDB start and wait until the SAP HANA database H4H is started. Enter the command: exit to leave the h4hadm session. Enter the following command: su — t4hadm . Enter the command: startsap and wait until the SAP NetWeaver system is started. Enter the command: exit to leave the t4hadm session. Do not close the PuTTY session, you need it again at the end of this exercise. Log on to the ABAP system T4H using the following credentials:

User Password

STUDENT-01

STUDENT-02

Welcome1

Welcome1

Remember to include the dash when entering STUDENT-## . In your WTS session, choose the Windows button, and search for SAP Logon. Start the SAP Logon. Double-click the system entry of the ABAP-System T4H. Enter the credentials from the above table. Using DBACOCKPIT, check the SAP HANA Services. To open DBA Cockpit, use transaction DBACOCKPIT. On the Current Status → Overview screen, choose All services are started. Check the status of each of the SAP HANA services. Using DBACOCKPIT, determine the configuration for the SAVEPOINT interval. From the initial screen of DBA Cockpit, choose Configuration → INI Files.



Navigate to INIFILE PARAMETER LIST → global.ini → persistence → savepoint_interval_s. The parameter savepoint_interval_s is set to 300 s. Using DBACOCKPIT, determine the execution of the SAVEPOINTs. Review the content of the HOST_SAVEPOINTS table in the _SYS_STATISTICS schema. From the initial screen of DBA Cockpit, choose System Information → Data Browser for System Tables. To navigate to the _SYS_STATISTICS schema, double-click Schema_SYS_STATISTICS. The content of the _SYS_STATISTICS schema is displayed. To display the content, double-click on the HOST_SAVEPOINTS entry. The table HOST_SAVEPOINTS shows the start and the duration of the savepoints that were performed. Using DBACOCKPIT, review the definition of the USR02 table in the SAPT4H schema using the following data:

Schema Table/View

SAPT4H

USR*

From the initial screen of DBACockpit, choose Diagnostics → Tables/Views. Enter the data from the table. Choose Display/Find. From the list, double click the USR02 table. Choose theColumns tab. Review the Column names and definitions. Choose the Send to SQL Editor button on the top of the screen. On the Input Query tab, review the following SQL s tatement: SELECT * FROM SAPT4H.USR02 To execute the query, choose the Execute button above the System button. Review the output in theResults tab. Exit transaction DBACOCKPIT, and return to the SAP menu.

Connect to Linux Server wdflbmt7285 using PuTTY, log on as ha200root, and run su t4hadm . If you are already connected, proceed to the next step. In your WTS session, choose the Windows button, and search for ha200_Putty . Start the ha200_Putty script.



To connect a ssh shell to the Linux server, choose option 3. To log on automatically as user ha200root, choose Enter. Enter the following command: su — t4hadm . List the entries of the hdbuserstore, and examine the DEFAULT key. Enter the following command: hdbuserstore LIST. The result shows the values defined for the key DEFAULT, as follows: KEY DEFAULT ENV : wdflbmt7285.wdf.sap.corp:30215 USER: SAPT4H

Create a new SYSTEM Connection to your standalone SAP HANA system for the following hostnames and SAP HANA systems:


H94

H95

Connection Name

_DBC

_DBC

Database System

SAP HANA database

SAP HANA database

Connection Maximum

100

100

Connection Optimum

100

100

User Name

SYSTEM

SYSTEM

Welcome1

Welcome1

wdflbmt7194

wdflbmt7195

30015

30015

Password Database Host SQL Port

Note that 30015 means 3++index server. To open the DBA Cockpit, use transaction DBACOCKPIT. In DBACockpit: System Configuration Maintenance, choose Add System entry. In the System field, enter the of your SAP HANA system. Select the Database Connection field, and choose the Create button. In Database Connection Details, enter the data from the above table. In the DB Connections: Add Connection Entry screen, choose Save. You automatically navigate back to the Add System Entry screen. On the Administration Data tab, enter the following description: HANA . Choose Save.



To confirm your new connection, at the bottom of the screen, the message Database connection has been saved and activated displays. Note: The new connection information is written to the DBCON table. If there are problems, check the entries in the DBCON table using transaction DBCO.

Test the new DBACOCKPIT connection to SAP HANA. Return to the initial screen in the DBA Cockpit. From the dropdown at the end of the SYSTEM button (on the left), choose your . Under the Current Status folder, double-click Overview. Under General System Information, check the Operational State of your SAP HANA Connection. A green light indicates that all services are started. On the Current Status → Overview screen, choose All services are started. Review the status of each of the SAP HANA services. Using DBACOCKPIT, determine the configuration for the SAVEPOINT interval. From the initial screen of DBA Cockpit, choose Configuration → INI Files. Navigate to INIFILE PARAMETER LIST → global.ini → persistence → savepoint_interval_s. Using DBACOCKPIT, review the definition of the sap.hana.democontent.epm.data::MD.Products table in the SAP_HANA_DEMO schema using the following data:

Schema Table/View

SAP_HANA_DEMO *

From the initial screen of DBACockpit, choose Diagnostics → Tables/Views. Enter the data from the table. Choose Display/Find. From the list, select the sap.hana.democontent.epm.data::MD.Products table. Choose theColumns tab. Review the Column names and definitions. Choose the Send to SQL Editor button on the top of the screen. On the Input Query tab delete the generated SQL statement and enter the following SQL statement: select "PRODUCTID", "CATEGORY" from "SAP_HANA_DEMO"."sap.hana.democontent.epm.data::MD.Products"



To execute the query, choose the Execute button above the System button.

Note: You can generate this SQL statement in the SAP HANA Studio, and copy and paste it to this SQL editor in the DBACockpit. In the SAP HANA Studio, navigate to the SAP_HANA_DEMO schema. In the Tables folder, find sap.hana.democontent.epm.data::MD.Products. From the context menu, choose Generate → Select Statement.

Review the output in theResults tab. Exit transaction DBACOCKPIT , and return to theSAP menu.

Attention: This step only needs to be performed by Group94. Stop the SAP HANA database H4H and the SAP NetWeaver system T4H on the Linux Server wdflbmt7285. The SAP NetWeaver ABAP system will not be used during the rest of the course, so to reclaim the resources you can shut it down. In the PuTTY session on server wdflbmt7285, enter the following command: su — t4hadm . Enter the command: stopsap and wait until the SAP NetWeaver system is stopped. Enter the command: exit to leave the t4hadm session. Enter the following command: su — h4hadm . Enter the command: HDB stop and wait until the SAP HANA database H4H is stopped. Enter the command: exit to leave the h4hadm session. Enter command: exit to close the PuTTY session.


Unit 8 Exercise 10 Connect to the SAP HANA Database Using SAP HANA Studio

Business Example After the installation of SAP HANA, you want to perform some postinstallation steps using the SAP HANA Studio. Use the Microsoft Remote Desktop application to connect to the SAP Training WTS landscape assigned to you by the instructor. Note: is the placeholder for the group number that the instructor assigned to you. is the placeholder for the training landscape number the instructor has assigned to you.






train-01

train-02

initial

initial

Start SAP HANA Studio and add your SAP HANA system to SAP HANA Studio using the following data:

wdflbmt7194

wdflbmt7195

00

00

Multiple containers

Multiple containers

H94

H95

SYSTEM

SYSTEM


Exercise 10: Connect to the SAP HANA Database Using SAP HANA Studio

Welcome1

Welcome1

Store user name and password in secure storage

Select

Select

Change the Active Provider from Native to Direct for Network Connection. Open the Administration Editor and check the system resources. Execute a select statement on a large table (for example, the

"SAP_HANA_DEMO"."sap.hana.democontent.epm.data::PO.Item" table in the SAP_HANA_DEMO schema). Determine how many rows are fetched by default, and increase this value to 2000. Add a second SAP HANA system to SAP HANA studio using the following data:

wdflbmt7195

wdflbmt7194

00

00

Multiple containers

Multiple containers

H95

H94

SYSTEM

SYSTEM

Welcome1

Welcome1


Select

Select

If you have already added the system of Group94, then add the system of Group95. If you have already added the system of Group95, then add the system of Group94. Organize the system landscape to identify the systems by datacenter. The SAP HANA system on the host wdflbmt7194 and host wdflbmt7195 are displayed in separate folders.


Unit 8 Solution 10 Connect to the SAP HANA Database Using SAP HANA Studio

Business Example After the installation of SAP HANA, you want to perform some postinstallation steps using the SAP HANA Studio. Use the Microsoft Remote Desktop application to connect to the SAP Training WTS landscape assigned to you by the instructor. Note: is the placeholder for the group number that the instructor assigned to you. is the placeholder for the training landscape number the instructor has assigned to you.






train-01

train-02

initial

initial

Skip to step 2. if you are still connected to the . On the Windows Desktop, open the Microsoft Windows Start menu and search for Remote Desktop Connection. Open the Microsoft Remote Desktop application. On theRemote Desktop Connection window, in the Computer field, enter the name provided by the instructor, and choose Connect. In the Windows Security screen, choose More choices and select the option Use a different account. Enter the and credentials from the above table, and choose OK.


Solution 10: Connect to the SAP HANA Database Using SAP HANA Studio



Start SAP HANA Studio and add your SAP HANA system to SAP HANA Studio using the following data:

wdflbmt7194

wdflbmt7195

00

00

Multiple containers

Multiple containers

H94

H95

SYSTEM

SYSTEM

Welcome1

Welcome1


Select

Select

From the Windows taskbar, choose SAP HANA Studio. In the StartUpTool — HANA Studio window, choose Submit. In the Eclipse Launcher window, choose OK. In the Secure Storage — Password Hint Needed window, choose No. In the Overview menu, choose Open Administration Console. Right-click the Systems tab, and choose Add System.... In the Specify System window, enter the , , and for your from the above table and press Next to continue. In the Connection Properties window, enter your , and select the checkbox to store in the secure store. To add your system to SAP HANA studio, choose Finish. Change the Active Provider from Native to Direct for Network Connection. In SAP HANA Studio, from the menu bar, choose Window → Preferences. Choose General → Network Connections.. In the Active Provider field, enter Direct. Choose Apply, and choose OK. Keep SAP HANA Studio open. Open the Administration Editor and check the system resources.



Select the Context menu of the system, and choose Configuration and Monitoring → Open Administration. Check that all services have started. The message Operational Status: All services started displays. Check the memory allocation (SAP HANA Used Memory). Keep SAP HANA Studio open. Execute a select statement on a large table (for example, the

"SAP_HANA_DEMO"."sap.hana.democontent.epm.data::PO.Item" table in the SAP_HANA_DEMO schema). Determine how many rows are fetched by default, and increase this value to 2000. To open the SQL Editor, choose the context menu of the system, and choose Open SQL Console. Enter the following SQL statement:

select * from "SAP_HANA_DEMO"."sap.hana.democontent.epm.data::PO.Item" By default, the number of rows displayed in the result is restricted to 1000. To change this value, you have to c hange the preference option Maximum Number of Rows Displayed in Result. From the menu bar, choose Window → Preferences. Choose SAP HANA → Runtime → Result. Change the value for Maximum Number of Rows Displayed in Result from 1000 to 2000, choose Apply, and choose OK. To check that the new setting is effective, enter the following SQL statement:

select * from "SAP_HANA_DEMO"."sap.hana.democontent.epm.data::PO.Item" Keep SAP HANA Studio open. Add a second SAP HANA system to SAP HANA studio using the following data:

wdflbmt7195

wdflbmt7194

00

00

Multiple containers

Multiple containers

H95

H94

SYSTEM

SYSTEM

Welcome1

Welcome1


Select

Select


Solution 10: Connect to the SAP HANA Database Using SAP HANA Studio

If you have already added the system of Group94, then add the system of Group95. If you have already added the system of Group95, then add the system of Group94. Right-click the Systems tab, and choose Add System.... In the Specify System window, enter the , , and for your from the above table and press Next to continue. In the Connection Properties window, enter your , and select the checkbox to store in the secure store. To add your system to SAP HANA studio, choose Finish. Organize the system landscape to identify the systems by datacenter. The SAP HANA system on the host wdflbmt7194 and host wdflbmt7195 are displayed in separate folders. Navigate to the Systems tab in the SAP HANA Studio. From the SAP HANA Administration Console perspective, from the menu bar, choose File → New → Folder. Under root (/), enter the name of the folder Group94 . Under root (/), enter the name of the folder Group95 . To organize the systems, move the SAP HANA system H94 on the wdflbmt7194 host user to the Group94 folder. Move the H95 system on the host wdflbmt7195 to the Group95 folder.


Unit 9 Exercise 11 Use Different Methods to Start and Stop the SAP HANA Database

Business Example You have several SAP HANA databases in your landscape and you want to know the best way to start and stop these databases. Test how to start and stop SAP HANA using SAP HANA Cockpit 2.0, HDB, and sapcontrol.

Caution: SAP HANA cockpit 2.0 is a central monitoring and administration tool. In our training landscape, SAP HANA cockpit is installed once on a central server. Both Group94 and Group95 will use this central SAP HANA cockpit 2.0 server system for starting and stopping the database.







train-01

train-02

initial

initial

Start Google Chrome and log on to your SAP HANA cockpit and stop the complete SAP HANA database via the SYSTEMDB.

USER94

USER95

Welcome1

Welcome1


Exercise 11: Use Different Methods to Start and Stop the SAP HANA Database

SYSTEMDB@H94

SYSTEMDB@H95

Use Google Chrome to start the complete SAP HANA database via your database. database.

In this exercise you are going to stop and start your SAP HANA tenant database H9x@H9x. Stop your SAP HANA tenant database using SAP HANA cockpit.

SYSTEMDB@H94

SYSTEMDB@H95

H94

H95

Start your SAP HANA tenant database using SAP HANA cockpit.

HDB command tool to stop and start the SAP HANA database in a SSH (Secure Shell). Use the HDB command From the WTS training landscape environment, landscape environment, open a SSH (Secure Shell) session to your using server> using PuTTY and the following data:

wdflbmt7195

h95adm

h94adm

Stop the SAP HANA database using the HDB stop command. stop command. Start the SAP HANA database using the HDB start command. start command.

Use the sapcontrol command sapcontrol command to stop and start the S AP HANA database in a SSH (Secure Shell). From the WTS training landscape environment, landscape environment, open a SSH (Secure Shell) session to your SAP HANA database server using server using PuTTY and the following data:

wdflbmt7195

h95adm

h94adm

Stop the SAP HANA database using the sapcontrol command. sapcontrol command. Start the SAP HANA database using the sapcontrol command. sapcontrol command.


Unit 9 Solution 11 Use Different Methods to Start and Stop the SAP HANA Database

Business Example You have several SAP HANA databases in your landscape and you want to know the best way to start and stop these databases. Test how to start and stop SAP HANA using SAP HANA Cockpit 2.0, HDB, and sapcontrol.

Caution: SAP HANA cockpit 2.0 is a central monitoring and administration tool. In our training landscape, SAP HANA cockpit is installed once on a central server. Both Group94 and Group95 will use this central SAP HANA cockpit 2.0 server system for starting and stopping the database.


Use Remote Desktop to connect to the WTS training landscape using landscape using the data in the following table:





train-01

train-02

initial

initial

Skip to step 2. if you are still connected to the . landscape>. On the Windows Desktop, open the Microsoft Windows Start menu and search for Remote Desktop Connection. Connection. Open the Microsoft Remote Desktop application. On the Remote Desktop Connection window, Connection window, in the Computer field, Computer field, enter the name landscape> name provided by the instructor, and choose Connect. Connect.


Solution 11: Use Different Methods to Start and Stop the SAP HANA Database

In the Windows Security screen, Security screen, choose More choices and choices and select the option Use a different account. account. Enter the and name> and credentials credentials from the above table, and choose OK. OK. On the Remote Desktop Connection dialog Connection dialog box, choose Yes. Yes.

Note: You are now connected to the WTS training landscape desktop landscape desktop with a gray background.

Start Google Chrome and log on to your SAP HANA cockpit and stop the complete SAP HANA database via the SYSTEMDB.

USER94

USER95

Welcome1

Welcome1

SYSTEMDB@H94

SYSTEMDB@H95

Use Google Chrome to connect to the SAP HANA cockpit via the following URL: https://wdflbmt7285.wdf.sap.corp:51021 In the SAP HANA XS Advanced window, Advanced window, enter your and Username> and credentials Password> credentials from the above table, and choose the Log On button. On button. In the home screen of SAP HANA cockpit, choose the View resource directory link directory link to see all your assigned resources. In the Resource Directory screen, Directory screen, select your database. database. You have now opened the Overview screen Overview screen of the SYSTEMDB from your SAP HANA database. Select the Overall System Database Status tile Status tile to get a detailed overview of the database services. In the Manage the Manage Services screen, Services screen, select the Stop System button System button to stop your SAP HANA database. In the Stop System pop-up System pop-up window , select the Immediately radio Immediately radio button and press the OK button. OK button. The shutdown will take around 1 minute. To get an up to date status overview pre ss the SAP HANA cockpit refresh button on the top right hand side of the screen. Don’t close Google Chrome. As soon as your SAP HANA database is stopped, continue with the next step. Use Google Chrome to start the complete SAP HANA database via your database. database. In the Manage Services screen, Services screen, select the Start System button System button to start your SAP HANA database.


Unit 9: Database Administration Tasks

In the Start System pop-up window , select the Yes button to start the complete SAP HANA database. The startup will take around 2 minutes. To get an up to date status overview pres s the SAP HANA cockpit refresh button on the top right hand side of the screen. Return to your overview screen by pressing the System button. Don’t close Google Chrome. You can continue with the next exercise step.

In this exercise you are going to stop and start your SAP HANA tenant database H9x@H9x. Stop your SAP HANA tenant database using SAP HANA cockpit.

SYSTEMDB@H94

SYSTEMDB@H95

H94

H95

In the overview screen, select the Overall Tenant Statuses tile. In the Manage Databases screen you see an overview of all the tenant databases of your SAP HANA database. In the Manage Databases screen, select the Stop Tenant button from your . In the Stop Tenant Database pop-up window, select the Immediately radio button and press the OK button. The tenant shutdown will take around 30 seconds. To get an up to date status overview press the SAP HANA cockpit refresh button on the top right hand side of the screen. Don’t close Google Chrome. As soon as your SAP HANA tenant database is stopped, continue with the next step. Start your SAP HANA tenant database using SAP HANA cockpit. In the Manage Databases screen, select the Start Tenant button to start your SAP HANA tenant database. The startup will take around 2 minutes. To get an up to date status overview pres s the SAP HANA cockpit refresh button on the top right hand side of the screen. Return to your overview screen by pressing the System button.

Use the HDB command tool to stop and start the SAP HANA database in a SSH (Secure Shell). From the WTS training landscape environment, open a SSH (Secure Shell) session to your using PuTTY and the following data:

wdflbmt7195

h95adm


h94adm

Solution 11: Use Different Methods to Start and Stop the SAP HANA Database

To start PuTTY in your gray WTS training landscape session, choose the Windows Start menu button, and search for HA200_putty . In the search results, choose HA200_putty. From the menu in the HA200_Putty window, choose your . In the HA200_Putty screen, press any key to start your PuTTY session. If the PuTTY Security Alert window appears, choose Yes to continue. Stop the SAP HANA database using the HDB stop command. In your PuTTY session, to change to the SAP HANA operating system user, enter the following command: su — . To check the database status, enter the following command: HDB info. Services like the hdbnameserver and hdbindexserver will be shown. To stop the SAP HANA database, enter the following command: HDB stop. When the database is stopped, check the status of the processes using the following command: HDB info. Only the sapstartsrv service displays. Start the SAP HANA database using the HDB start command. In your PuTTY session, start the SAP HANA database using the following command: HDB start. When the database is started, check the status of the processes using the following command: HDB info. The sapstartsrv, hdbnameserver, and the hdbindexserver services appear. To close the session, enter the following command: exit. Don’t close the PuTTY session, because you need it in the next task. Use the sapcontrol command to stop and start the S AP HANA database in a SSH (Secure Shell). From the WTS training landscape environment, open a SSH (Secure Shell) session to your SAP HANA database server using PuTTY and the following data:

wdflbmt7195

h95adm

h94adm

If your PuTTY session to your SAP HANA database server is still open, then proceed to the next step. To start PuTTY in your gray WTS training landscape session, choose the Windows Start menu button, and search for HA200_putty .



In the search results, choose HA200_putty. From the menu in the HA200_Putty window, choose your . In the HA200_Putty screen, press any key to start your PuTTY session. If the PuTTY Security Alert window appears, choose Yes to continue. Stop the SAP HANA database using the sapcontrol command. As user ha200root, check the SAP HANA database status using the following command: /usr/sap/hostctrl/exe/sapcontrol -nr 00 -function GetProcessList. To stop the SAP HANA database, enter the following command: /usr/sap/ hostctrl/exe/sapcontrol -nr 00 -function Stop. After the database stops, check the status of the processes using the following command: /usr/sap/hostctrl/exe/sapcontrol -nr 00 -function GetProcessList. The hdbdaemon process has the status Stopped . Start the SAP HANA database using the sapcontrol command. As user ha200root, check the SAP HANA database status using the following command: /usr/sap/hostctrl/exe/sapcontrol -nr 00 -function GetProcessList. Start the SAP HANA database using the following command: /usr/sap/ hostctrl/exe/sapcontrol -nr 00 -function Start. After the database starts, check the status of the processes using the following command: /usr/sap/hostctrl/exe/sapcontrol -nr 00 -function GetProcessList. All the processes have status GREEN. To close the PuTTY session, enter the following command: exit.


Unit 9 Exercise 12 Change SAP HANA Configuration Parameters with SAP HANA Cockpit

Business Example After you install the SAP HANA database, you want to change some SAP HANA database configuration parameters. Use SAP HANA cockpit to perform these configuration changes.

Caution: SAP HANA cockpit 2.0 is a central monitoring and administration tool. In our training landscape, SAP HANA cockpit is installed once on a central server. Both Group94 and Group95 will use this central SAP HANA cockpit 2.0 server system to perform these configuration changes.







train-01

train-02

initial

initial

Start Google Chrome and log on to your SAP HANA cockpit.

https://

https:// wdflbmt7285.wdf.sap.cor wdflbmt7285.wdf.sap.cor p:51021 p:51021

USER94

USER95

Welcome1

Welcome1



H94@H94

H95@H95

Execute a select statement on a large table (for example, the "SAP_HANA_DEMO"."sap.hana.democontent.epm.data::PO.Item" table in the SAP_HANA_DEMO schema) and determine the number of returned rows. Increase the number of fetched rows to 2000. To create delivery units for your developers or modelers, check and change the SAP HANA database content_vendor parameter using the following data:

content_vendor sap.training

You now have successfully changed the SAP HANA configuration parameter content_vendor.


Unit 9 Solution 12 Change SAP HANA Configuration Parameters with SAP HANA Cockpit

Business Example After you install the SAP HANA database, you want to change some SAP HANA database configuration parameters. Use SAP HANA cockpit to perform these configuration changes.

Caution: SAP HANA cockpit 2.0 is a central monitoring and administration tool. In our training landscape, SAP HANA cockpit is installed once on a central server. Both Group94 and Group95 will use this central SAP HANA cockpit 2.0 server system to perform these configuration changes.







train-01

train-02

initial

initial

Skip to step 2 if you are still connected to the . On the Windows Desktop, open the Microsoft Windows Start menu and search for Remote Desktop Connection. Open the Microsoft Remote Desktop application. On the Remote Desktop Connection window, in the Computer field, enter the name provided by the instructor, and choose Connect. In the Windows Security screen, choose More choices and select the option Use a different account.



Enter the user name and password c redentials from the above table, and choose OK. On the Remote Desktop Connection dialog box, choose Yes.



https://


USER94

USER95

Welcome1

Welcome1

H94@H94

H95@H95

Skip to step 3 if you are still connected to your . Use Google Chrome to connect to the SAP HANA cockpit via the following URL: https://wdflbmt7285.wdf.sap.corp:51021 In the SAP HANA XS Advanced window, enter your and credentials from the above table, and choose the Log On button. In the home screen of SAP HANA cockpit, choose the View resource directory link to see all your assigned resources. In the Resource Directory screen, select your database. You have now opened the Overview screen of the from your SAP HANA database. Execute a select statement on a large table (for example, the "SAP_HANA_DEMO"."sap.hana.democontent.epm.data::PO.Item" table in the SAP_HANA_DEMO schema) and determine the number of returned rows. In the Overview screen of your database, click Open SQL Console in the top right corner. In the Database Explorer tab, enter the following SQL statement in the SQL editor in the right panel: select * from "SAP_HANA_DEMO"."sap.hana.democontent.epm.data::PO.Item" To execute the SQL, choose the Run (F8) button. Determine the number of rows that are fetched by default.


Solution 12: Change SAP HANA Configuration Parameters with SAP HANA Cockpit

Number of fetched rows:

Increase the number of fetched rows to 2000. In the Database Explorer screen, choose the Preferences button on the left panel. Select the SQL Console link, and change the value for Max number of rows to display to 2000. Choose the Save button. To return to the SQL editor, choose the Database Explorer button. Select your SQL statement, and execute it by choosing the Run (F8) button. Determine the number of rows that are fetched by default. Number of fetched rows:

Close the Database Explorer tab. Keep the SAP HANA cockpit open. To create delivery units for your developers or modelers, check and change the SAP HANA database content_vendor parameter using the following data:

content_vendor sap.training

In your SAP HANA cockpit, scroll down to the DB Administration area, and choose Configure system properties. In the Configuration File Contents area, search for the content_vendor parameter. To change the content_vendor parameter, choose the plus sign (+) in front of the parameter name. In the Add Parameter dialog box, enter in the two fields the and data from the above table. To save the new value, choose OK. To return to the SAP HANA Cockpit home screen, choose the System button. You now have successfully changed the SAP HANA configuration parameter content_vendor.


Unit 9 Exercise 13 Monitor SAP HANA Using SAP HANA Cockpit 2.0

Business Example As a system administrator, one of your most important tasks is to monitor the SAP HANA database and whole landscape. The SAP HANA Cockpit 2.0 provides many tools to help you do this.

Caution: SAP HANA Cockpit 2.0 is a central monitoring and administration tool. In our training landscape, the SAP HANA cockpit is installed once on a central server. Both Group94 and Group95 will use this central SAP HANA cockpit 2.0 server system to monitor the SAP HANA databases.







train-01

train-02

initial

initial


https://



USER94

USER95

Exercise 13: Monitor SAP HANA Using SAP HANA Cockpit 2.0

Welcome1

Welcome1

H94@H94

H95@H95

Check the overall system status and the current alerts of your SAP HANA database systems. Check the detailed status and memory usage per service for your SAP HANA database. Determine the memory usage for the last three hours for your SAP HANA database, and set the refresh rate to 10 seconds. Find the top five tables in the SAP HANA database in terms of disk size. Monitor some Key Performance Indicators (KPIs) from your SAP HANA database, such as CPU, Statements, and Data Write Size.


Unit 9 Solution 13 Monitor SAP HANA Using SAP HANA Cockpit 2.0

Business Example As a system administrator, one of your most important tasks is to monitor the SAP HANA database and whole landscape. The SAP HANA Cockpit 2.0 provides many tools to help you do this.

Caution: SAP HANA Cockpit 2.0 is a central monitoring and administration tool. In our training landscape, the SAP HANA cockpit is installed once on a central server. Both Group94 and Group95 will use this central SAP HANA cockpit 2.0 server system to monitor the SAP HANA databases.







train-01

train-02

initial

initial

Skip to step 2 if you are still connected to the . On the Windows Desktop, open the Microsoft Windows Start menu and search for Remote Desktop Connection. Open the Microsoft Remote Desktop application. On the Remote Desktop Connection window, in the Computer field, enter the name provided by the instructor, and choose Connect.


Solution 13: Monitor SAP HANA Using SAP HANA Cockpit 2.0

In the Windows Security screen, choose More choices and select the option Use a different account. Enter the user name and password c redentials from the above table, and choose OK. On the Remote Desktop Connection dialog box, choose Yes.



https://


USER94

USER95

Welcome1

Welcome1

H94@H94

H95@H95

Skip to step 3 if you are still connected to your . Use Google Chrome to connect to the SAP HANA cockpit via the following URL: https://wdflbmt7285.wdf.sap.corp:51021 In the SAP HANA XS Advanced window, enter your and credentials from the above table, and choose the Log On button. You have now opened the home s creen of your SAP HANA database in SAP HANA cockpit. Check the overall system status and the current alerts of your SAP HANA database systems. In the My Resources screen of SAP HANA cockpit, choose the Monitor aggregate health link. In the Aggregate Health Monitor screen, review the Status of your SAP HANA system. To check for alerts, choose the Alert Counts link. To return to the Aggregate Health Monitor screen, choose the Back button. Check the detailed status and memory usage per service for your SAP HANA database. To see the detailed status information of your SAP HANA system database, in the Aggregate Health Monitor screen, choose your . In the overview screen of SAP HANA cockpit, choose the Overall Database Status tile. In the Manage Services screen, view the Status and Memory usage per service. To return to the SAP HANA cockpit - Overview screen, choose the Back button.



Determine the memory usage for the last three hours for your SAP HANA database, and set the refresh rate to 10 seconds. To get an overview of the current m emory usage for the last hour, in the SAP HANA cockpit - Overview screen, open the Performance Monitor by choosing the Memory Usage tile. To get the memory usage overview for the last three hours, in the Duration field, select the dropdown, and choose 3 Hour. To get the memory usage overview updates every 10 seconds, in the Refresh field, select the dropdown, and choose 10 Sec. To return to the SAP HANA cockpit - Overview screen, choose the Back button. Find the top five tables in the SAP HANA database in terms of disk size. In the SAP HANA cockpit - Overview screen, scroll down to the Monitoring area. To get a graphical overview of the current column tables usage, choose the Monitor table usage link. To show the top five tables, in the Filter Tables area enter the value 5 in the Display: field. In the chart area, change the bubble-chart to table-chart. To execute this query , choose the Go button. To return to the SAP HANA cockpit - Overview screen, choose the Back button. Monitor some Key Performance Indicators (KPIs) from your SAP HANA database, such as CPU, Statements, and Data Write Size. To get an overview of the current CPU usage for the last hour, in the SAP HANA cockpit - Overview screen, open the Performance Monitor by choosing the CPU Usage tile. Choose the Add Chart button. Enter the chart name My New Chart. Select the CPU, Statements, and Data Write Size KPIs, and choose OK. Use the search function to find the KPIs. To return to the SAP HANA cockpit - Overview screen, choose the Back button.


Unit 9 Exercise 14 Configure SAP HANA Traces

Business Example As an SAP HANA system administrator, you need to activate the traces to investigate system issues. Use SAP HANA cockpit 2.0 to activate the Expensive Statement trace and SQL trace.

Caution: SAP HANA cockpit 2.0 is a central monitoring and administration tool. In our training landscape, the SAP HANA cockpit is installed once on a central server. Group94 and Group95 will need to work together on this central SAP HANA cockpit 2.0 server system to activate the SQL trace and Expensive Statement trace.







train-01

train-02

initial

initial


https://


USER94

USER95

Welcome1

Welcome1



H94@H94

H95@H95

In SAP HANA Cockpit, open the Expensive Statements Trace. Activate the Expensive Statements Trace to rec ord all statements with a duration longer than 100 microseconds. Execute a expensive SQL statement using the SQL Console. Analyze the generated Expensive Statements Trace. Deactivate the Expensive Statements Trace.

Configure and activate a SQL Trace for use r SYSTEM, with a table filter on sap.hana.democontent.epm.data::PO.Item, using the following credentials:


SYSTEM

SYSTEM

Welcome1

Welcome1

Active

Active

STUDENT_H94_sqltrace.py


No User Filter

No User Filter

SAP_HANA_DEMO.SAP.HA- SAP_HANA_DEMO.SAP.HA NA.DEMOCONTENT.EPM.DA- NA.DEMOCONTENT.EPM.DATA::PO.ITEM TA::PO.ITEM

All

All

DML, DDL, PROCEDURE, TRANSACTION, SESSION, SYSTEM


16

16

Use the following filters: Execute an expensive SQL statement using the Database Explorer for the following systems:


Exercise 14: Configure SAP HANA Traces

H94@H94 (wdflbmt7194.wdf.sap. corp)

H95 (wdflbmt7195.wdf.sap. corp)

Examine the SQL trace file for the following groups:


H94@H94 (wdflbmt7194)


wdflbmt7194

wdflbmt7195



Unit 9 Solution 14 Configure SAP HANA Traces

Business Example As an SAP HANA system administrator, you need to activate the traces to investigate system issues. Use SAP HANA cockpit 2.0 to activate the Expensive Statement trace and SQL trace.

Caution: SAP HANA cockpit 2.0 is a central monitoring and administration tool. In our training landscape, the SAP HANA cockpit is installed once on a central server. Group94 and Group95 will need to work together on this central SAP HANA cockpit 2.0 server system to activate the SQL trace and Expensive Statement trace.







train-01

train-02

initial

initial

Skip to step 2 if you are still connected to the . On the Windows Desktop, open the Microsoft Windows Start menu and search for Remote Desktop Connection. Open the Microsoft Remote Desktop application. On the Remote Desktop Connection window, in the Computer field, enter the name provided by the instructor, and choose Connect. In the Windows Security screen, choose More choices and select the option Use a different account.


Solution 14: Configure SAP HANA Traces

Enter the user name and password c redentials from the above table, and choose OK. On the Remote Desktop Connection dialog box, choose Yes.



https://


USER94

USER95

Welcome1

Welcome1

H94@H94

H95@H95

Skip to step 3 if you are still connected to your . Use Google Chrome to connect to the SAP HANA cockpit via the following URL: https://wdflbmt7285.wdf.sap.corp:51021 In the SAP HANA XS Advanced window, enter your and credentials from the above table, and choose the Log On button. You have now opened the home s creen of your SAP HANA database in SAP HANA cockpit.

In SAP HANA Cockpit, open the Expensive Statements Trace. In the SAP HANA cockpit - My Resources screen, in the Recently Accessed area select your from the list. In the SAP HANA cockpit - Overview, scroll to the Monitoring area. Choose the Monitor expensive statements link. Activate the Expensive Statements Trace to rec ord all statements with a duration longer than 100 microseconds. In the Expensive Statement Trace screen, choose the Configure Trace button. In the Configure Expensive Statement Trace dialog box, in the Trace Status field, select Active. In the Threshold Duration field, enter 100. Choose the Proceed button. To activate the Expensive Statements Trace, in the Confirm dialog box, choose OK. To return to the SAP HANA Cockpit home screen, choose the System button.



Execute a expensive SQL statement using the SQL Console. In the Overview screen of your database, click Open SQL Console in the top right corner. In the Database Explorer tab, enter the following SQL statement in the SQL editor in the right panel: select * from "SAP_HANA_DEMO"."sap.hana.democontent.epm.data::PO.Item" To execute the SQL, choose the Run (F8) button. Note the time when you execute the SQL statement. Close the Database Explorer tab. Analyze the generated Expensive Statements Trace. In the SAP HANA cockpit - Overview, scroll down to the Monitoring area, and choose the Monitor expensive statements link. On the Expensive Statement Trace screen, in the Statement Filter field, enter select * from "SAP_HANA_DEMO"."sap.hana.democontent.epm.data::PO.Item", and choose Enter. In the Search Result screen, search for your SQL statement by looking at the execution time and date. To display the details of the SQL trace, choose the More link at the end of the row. In the Full SQL Statement dialog box, choose Open in SQL Analyzer. In the Overview tab, select the Dominant Operators tile. At the bottom of the screen select the Operator List tab, review the operators. At the bottom of the screen select the Timeline tab, review the execution timeline. To return to the SAP HANA Cockpit home screen, choose the System button. Deactivate the Expensive Statements Trace. In the SAP HANA cockpit - Overview, scroll to the Monitoring area, and choose the Monitor expensive statements link. In the Expensive Statement Trace screen, choose the Configure Trace button. In the Configure Expensive Statement Trace dialog box, in the Trace Status field, select inactive. Choose Proceed. To activate the Expensive Statement trace, in the Confirm dialog box, choose OK. To return to the SAP HANA Cockpit home screen, choose the System button.

Configure and activate a SQL Trace for use r SYSTEM, with a table filter on sap.hana.democontent.epm.data::PO.Item, using the following credentials:


Solution 14: Configure SAP HANA Traces


SYSTEM

SYSTEM

Welcome1

Welcome1

Active

Active



No User Filter

No User Filter

SAP_HANA_DEMO.SAP.HA- SAP_HANA_DEMO.SAP.HA NA.DEMOCONTENT.EPM.DA- NA.DEMOCONTENT.EPM.DATA::PO.ITEM TA::PO.ITEM

All

All



16

16

Use the following filters: In a browser, open the following URL: https://:4300/sap/ hana/ide/trace In the SAP HANA Logon screen, enter the user name and password from the above table. To open the Trace Configuration tab, choose the Configuration... button. To configure the SQL trace, in the SQL Trace area, choose the Pencil button behind the Status of Index Server. On the SQL Trace Configuration for Index Server screen, enter the filters from the above table. To activate the SQL trace, choose OK. Keep the Trace Configuration tab open. Execute an expensive SQL statement using the Database Explorer for the following systems:


H95 (wdflbmt7195.wdf.sap. corp)

In your SAP HANA cockpit - Overview for the database , select the Open SQL Console area.



To display the tables in the SAP_HANA_DEMO schema, choose your → Catalog → SAP_HANA_DEMO → Tables. Search for the sap.hana.democontent.epm.data::PO.Item table. Right click the sap.hana.democontent.epm.data::PO.Item table, and choose Generate SELECT Statement. Execute the SQL statement twice by choosing the Run (F8) button in the SQL Console tab. Note the time when you executed the SQL statement. Close the Database Explorer tab. In the SAP HANA: Trace tab, deactivate the SQL trace by choosing the Pencil button. In the Trace Status field, select Inactive . Choose the OK button. Examine the SQL trace file for the following groups:



wdflbmt7194

wdflbmt7195



In your SAP HANA cockpit - Overview for the database , scroll down to the Alerting & Diagnostics area, and choose the View trace and diagnostic files link. To display the traces, choose → Database Diagnostic Files → → Other. Choose your trace file from the list. Examine the trace in the Trace Viewer window on the right. In the Trace Viewer, press Ctrl+F on your keyboard. In the search field, enter PO.Item . In the Trace Viewer, the lines containing PO.Item are highlighted. Close the Database Explorer tab Close the Trace Configuration tab.


Unit 9 Exercise 15 Work with Diagnosis Files

Business Example You want to find and display the content of trace and diagnostic files to investigate poss ible system issues. Use SAP HANA cockpit 2.0 to view the trace and diagnostic files.

Caution: SAP HANA cockpit 2.0 is a central monitoring and administration tool. In our training landscape, the SAP HANA cockpit is installed once on a central server. Group94 and Group95 will need to work together on this central SAP HANA cockpit 2.0 server system to activate SQL trace and Expensive Statement traces.







train-01

train-02

initial

initial


https://


USER94

USER95

Welcome1

Welcome1



H94@H94

H95@H95

Open the View trace and diagnostic files link in SAP HANA cockpit using the following information:



wdflbmt7194

wdflbmt7195

Download a trace file.

Open the Manage full system information dumps link in SAP HANA cockpit using the following information:

Generate a full system dump.




wdflbmt7194

wdflbmt7195

Unit 9 Solution 15 Work with Diagnosis Files

Business Example You want to find and display the content of trace and diagnostic files to investigate poss ible system issues. Use SAP HANA cockpit 2.0 to view the trace and diagnostic files.

Caution: SAP HANA cockpit 2.0 is a central monitoring and administration tool. In our training landscape, the SAP HANA cockpit is installed once on a central server. Group94 and Group95 will need to work together on this central SAP HANA cockpit 2.0 server system to activate SQL trace and Expensive Statement traces.







train-01

train-02

initial

initial

Skip to step 2. if you are still connected to the . On the Windows Desktop, open the Microsoft Windows Start menu and search for Remote Desktop Connection. Open the Microsoft Remote Desktop application. On the Remote Desktop Connection window, in the Computer field, enter the name provided by the instructor, and choose Connect. In the Windows Security screen, choose More choices and select the option Use a different account. Enter the user name and password c redentials from the above table, and choose OK.






https://


USER94

USER95

Welcome1

Welcome1

H94@H94

H95@H95

Skip to step 3 if you are still connected to your . Use Google Chrome to connect to the SAP HANA cockpit via the following URL: https://wdflbmt7285.wdf.sap.corp:51021 In the SAP HANA XS Advanced window, enter your and credentials from the above table, and choose the Log On button. You have now opened the home s creen of your SAP HANA database in SAP HANA cockpit.

Open the View trace and diagnostic files link in SAP HANA cockpit using the following information:



wdflbmt7194

wdflbmt7195

In your SAP HANA cockpit - Overview for the database , scroll down to the Alerting & Diagnostics area, and choose the View trace and diagnostic files link. To display the traces, choose → Database Diagnostic Files → → indexserver. All the trace files belonging to the Indexserver are displayed. Select the indexserver__30003.000.trc file. Press Ctrl+F on your keyboard, and s earch for BACKUP DATA


Solution 15: Work with Diagnosis Files

The message NOTE: BACKUP DATA needed to ensure recoverability of the database displays every time a savepoint is executed. This message is a reminder that you still need to perform the initial backup after installation to ensure recoverability of the database. Download a trace file. Right-click the indexserver__30003.000.trc file, and choose Download. The trace file is downloaded to the download folder of your browser. Open the file using Wordpad. Review the content of the trace file. Close Wordpad. Close the Database Explorer tab.

Open the Manage full system information dumps link in SAP HANA cockpit using the following information:



wdflbmt7194

wdflbmt7195

In your SAP HANA cockpit - Overview for the database , scroll down to the Alerting & Diagnostics area, and choose the Manage full system information dumps link. Generate a full system dump. Select the Collect Diagnostics link. From the dropdown menu, select Collect from Existing Files. In the Collect Diagnosis Information screen, select a Date Range that shows the last 4 days and press the Start Collecting button. The generation of the dump takes around 30 seconds. Press the SAP HANA Cockpit refresh button in the top right corner to get an up to date overview. Download the full system dump by selecting the Download button. The full system dump file is downloaded to the download folder of your browser. Open the download folder by selecting the Show in folder option. Double-click the full system info dump file and review the content. WinRAR will open and show the content. Close WinRAR. Close the Downloads window To return to the SAP HANA cockpit - Overview screen, choose the System button.


Unit 9 Exercise 16 Analyze Queries

Business Example When facing a performance issue in the system, especially SQL performance, use the SQL plan cache function for analysis. Find the query in the current system that had the longest execution time. Use Remote Desktop to connect to the WTS training landscape using the data in the following table:





train-01

train-02

initial

initial


https://


USER94

USER95

Welcome1

Welcome1

H94@H94

H95@H95

Open the SQL Plan Trace Find the query with the longest execution time using the Configure Viewer.


Unit 9 Solution 16 Analyze Queries

Business Example When facing a performance issue in the system, especially SQL performance, use the SQL plan cache function for analysis. Find the query in the current system that had the longest execution time. Use Remote Desktop to connect to the WTS training landscape using the data in the following table:





train-01

train-02

initial

initial






https://


USER94

USER95

Welcome1

Welcome1

H94@H94

H95@H95

Skip to step 3 if you are still connected to your . Use Google Chrome to connect to the SAP HANA cockpit via the following URL: https://wdflbmt7285.wdf.sap.corp:51021 In the SAP HANA XS Advanced window, enter your and credentials from the above table, and choose the Log On button. You have now opened the home s creen of your SAP HANA database in SAP HANA cockpit. In the Recently Accessed area, select your . Open the SQL Plan Trace In SAP HANA cockpit - Overview, scroll to the Monitoring area. Choose the Open SQL plan cache link. Find the query with the longest execution time using the Configure Viewer. Choose the Settings button, in the top right corner. Deselect all columns by selecting and deselecting the All checkbox. Search for the column STATEMENT STRING and mark the checkbox. Search for the column TOTAL EXECUTION TIME and mark the checkbox. Choose OK. To sort the list by TOTAL EXECUTION TIME, click the Sort button, select the Descending and TOTAL EXECUTION TIME radio buttons and press the OK button.


Unit 9 Exercise 17 Administer a Table

Business Example You want to create tables in the SAP HANA system that you are administrating. You also want to optimize partitioning and check the in tegrity.

Create a new EPM.PO.Item_Part table in schema SAP_HANA_DEMO with the same structure as the sap.hana.democontent.epm.data::PO.Item table . Insert all data from the sap.hana.democontent.epm.data::PO.Item table into EPM.PO.Item_Part. Check the loading status of the table, and manually trigger unload and load. Unload the EPM.PO.Item_Part table from the memory of the SAP HANA server. Confirm that the table has been unloaded successfully by checking the loading status in the Runtime Information. Load the table completely into the memory and check the loading status again. Check the size of the memory consumption of main storage and delta storage, and manually trigger a delta merge operation. Check the size of the memory consumption of main storage and delta storage of the EPM.PO.Item_Part table. Manually trigger a delta merge operation of the EPM.PO.Item_Part table. After the delta merge operation has been performed, check the size of the memory consumption of main storage and delta storage of the EPM.PO.Item_Part table.

Create and merge table partitions, and verify the integrity with an extended data check. Open the Table Distribution Editor, and di splay table partitions of the EPM.PO.Item_Part table. Partition the EPM.PO.Item_Part table by range for the PURCHASEORDERITEM column using the following data:

Start

0000000000

0000000040

End

0000000040

0000000080



Check the integrity of partitions in the EPM.PO.Item_Part table by executing an extended data check. Merge the partitions of the EPM.PO.Item_Part table.


Unit 9 Solution 17 Administer a Table

Business Example You want to create tables in the SAP HANA system that you are administrating. You also want to optimize partitioning and check the in tegrity.

Create a new EPM.PO.Item_Part table in schema SAP_HANA_DEMO with the same structure as the sap.hana.democontent.epm.data::PO.Item table . In the WTS session, choose the Windows button, search for the SAP HANA Studio, and start it. In the Systems window, right-click the SAP HANA system where you are logged on as user SYSTEM. From the context menu, choose Open SQL Console. To create the table, enter the following command: CREATE TABLE

"SAP_HANA_DEMO"."EPM.PO.Item_Part" like "SAP_HANA_DEMO"."sap.hana.democontent.epm.data::PO.Item"; Choose Execute. In the Systems window, navigate to Catalog

→

SAP_HANA_DEMO.

Right-click Tables, and choose Refresh. Confirm that the table has been cre ated. To open the definition of the table, right-click it, and choose Open Definition. Confirm that the table has the same structure as the sap.hana.democontent.epm.data::PO.Item table. Insert all data from the sap.hana.democontent.epm.data::PO.Item table into EPM.PO.Item_Part. In the SQL Console, enter the following command:

INSERT INTO "SAP_HANA_DEMO"."EPM.PO.Item_Part" SELECT * FROM "SAP_HANA_DEMO"."sap.hana.democontent.epm.data::PO.Item"; Choose Execute. In the Systems window, right-click the EPM.PO.Item_Part table, and choose Open Content. Confirm that the entries from the sap.hana.democontent.epm.data::PO.Item table have been inserted into EPM.PO.Item_Part.

Check the loading status of the table, and manually trigger unload and load.



Unload the EPM.PO.Item_Part table from the memory of the SAP HANA server. In the Systems window, right-click the EPM.PO.Item_Part table. From the context menu, choose Unload from Memory.... To confirm, choose OK. Confirm that the table has been unloaded successfully by checking the loading status in the Runtime Information. In the Systems window, right-click the table, and choose Open Definition. Open the Runtime Information tab. Confirm that the Loaded column in the table Details for Table indicates that the table is not loaded. Furthermore, currently the table does not consume memory. This is indicated by Total Memory Consumption (KB). Load the table completely into the memory and check the loading status again. In the Systems window, right-click the EPM.PO.Item_Part table. From the context menu, choose Load into Memory... To confirm, choose OK. In the Systems window, right-click the table, and choose Open Definition. Choose Refresh. Open the Runtime Information tab. Confirm that the Loaded column in the table Details for Table indicates that the table is fully loaded. Furthermore, currently the table now consumes memory. This is indicated by Total Memory Consumption (KB). Check the size of the memory consumption of main storage and delta storage, and manually trigger a delta merge operation. Check the size of the memory consumption of main storage and delta storage of the EPM.PO.Item_Part table. In the Systems window, right-click the table, and choose Open Definition. Open the Runtime Information tab. Check the Memory Consumption in Main Storage (KB) and Memory Consumption in Delta Storage (KB). Manually trigger a delta merge operation of the EPM.PO.Item_Part table. In the Systems window, right-click the table, and choose Perform Delta Merge.... To confirm, choose OK. After the delta merge operation has been performed, check the size of the memory consumption of main storage and delta storage of the EPM.PO.Item_Part table. In the table definition, navigate to the Runtime Information tab, and choose Refresh.


Solution 17: Administer a Table

Check the Memory Consumption in Main Storage (KB) and Memory Consumption in Delta Storage (KB).

Create and merge table partitions, and verify the integrity with an extended data check. Open the Table Distribution Editor, and di splay table partitions of the EPM.PO.Item_Part table. In the Systems window, expand the SAP_HANA_DEMO schema. In the SAP_HANA_DEMO schema, right-click the Tables folder. To open the Table Distribution Editor, from the context menu, choose Show Table Distribution. Choose the EPM.PO.Item_Part table. To confirm that the table is not partitioned, view the partition details of table. Partition the EPM.PO.Item_Part table by range for the PURCHASEORDERITEM column using the following data:

Start

0000000000

0000000040

End

0000000040

0000000080

In the Table Distribution Editor, right-click the EPM.PO.Item_Part table, and choose Partition Table.... For the Partitioning Specification, select Range, and choose Next. To partition the table on the PURCHASEORDERITEM column, choose the Change button. Select the PURCHASEORDERITEM column, and choose OK. To specify a value range, choose Add. Enter the data from the table.

Note: Because an additional partition for all other values is created automatically, three partitions are created in total.

Choose Finish. In the partition details (Table Distribution Editor) of the EPM.PO.Item_Part table, expand the host. The three partitions with their respective sizes are displayed. Check the integrity of partitions in the EPM.PO.Item_Part table by executing an extended data check. In the Systems window, right-click the SAP HANA system where you are logged on as user SYSTEM.



From the context menu, choose SQL Console. To check the partitioning consistency of the table, enter the following SQL command:

CALL CHECK_TABLE_CONSISTENCY('CHECK_PARTITIONING_DATA', 'SAP_HANA_DEMO','"EPM.PO.Item_Part"'); Choose Execute. Confirm that no errors are displayed, that is , that the extended data check has shown that no issues exist. Merge the partitions of the EPM.PO.Item_Part table. In the Systems window, expand the SAP_HANA_DEMO schema. In the SAP_HANA_DEMO schema, right-click the Tables folder. To open the Table Distribution Editor, from the context menu, choose Show Table Distribution. Right-click the EPM.PO.Item_Part table. Choose Merge Partitions.... To confirm, choose OK. In the partition details of the EPM.PO.Item_Part table, confirm that the table is no longer partitioned.


Unit 9 Exercise 18 Transport Changes

Business Example You want to test the transport of a delivery unit between two SAP HANA tenant databases using SAP HANA application lifecycle management. A delivery unit is created in the source system. The source system is registered in the target system and a transport route is created. This exercise uses the following information: ●

Source system: Tenant H94@H94 on wdflbmt7194

●

Target system: Tenant H95@H95 on wdflbmt7195

Create a delivery unit in the source system wdflbmt7194 using SAP HANA application lifecycle management. Start SAP HANA application lifecycle management and log on to the source system using the following credentials:

User

SYSTEM

Password

Welcome1

Create a delivery unit called DU_HA200 . Create a package called Package_HA200. Assign Package_HA200 to the delivery unit DU_HA200.

Start SAP HANA application lifecycle management and log on to the target system as user SYSTEM . Register the source system H94 on wdflbmt7194. Create a transport route using the following data:

Name

Source System Content

Start the transport.


T_route_HA200 H94 (wdflbmt7194)

DU_HA200


Check the result.


Unit 9 Solution 18 Transport Changes

Business Example You want to test the transport of a delivery unit between two SAP HANA tenant databases using SAP HANA application lifecycle management. A delivery unit is created in the source system. The source system is registered in the target system and a transport route is created. This exercise uses the following information: ●

Source system: Tenant H94@H94 on wdflbmt7194

●

Target system: Tenant H95@H95 on wdflbmt7195

Create a delivery unit in the source system wdflbmt7194 using SAP HANA application lifecycle management. Start SAP HANA application lifecycle management and log on to the source system using the following credentials:

User Password

SYSTEM

Welcome1

Start your browser and enter the following URL: https://wdflbmt7194:4300/sap/ hana/xs/lm. On the There is a problem with this website’s security certificate screen, choose Continue to this website (not recommended). Log on using the credentials from the table. Create a delivery unit called DU_HA200 . Choose the PRODUCTS → Delivery Units tab. Choose + Create. In the dialog box, in the Name field, enter DU_HA200 . Choose Create. Create a package called Package_HA200. In the Assigned Packages area, choose Manage Packages. The SAP Web IDE for SAP HANA starts in a new browser tab. Right-click Content, and choose New → Package. In the dialog box, in the Package name field, enter Package_HA200 .



Choose Create. Assign Package_HA200 to the delivery unit DU_HA200. Go back to the SAP HANA application lifec ycle management browser tab. Select the DU_HA200 delivery unit. In the Assigned Packages area, choose Assign. In the dialog box, choose Package_HA200, and choose Assign.

Start SAP HANA application lifecycle management and log on to the target system as user SYSTEM . Start your browser and enter the following URL: https://wdflbmt7195:4300/sap/ hana/xs/lm. Log on as user SYSTEM . Register the source system H94 on wdflbmt7194. In SAP HANA application lifecycle management, choose Transport. On the TRANSPORT → Systems tab, choose + Register. In the dialog box, in the Host field, enter wdflbmt7194. In the XS Engine HTTP(S) Port field, enter 8000. Choose Next. To maintain log on information, choose Maintain Destination. On the HTTP Destination Details screen, choose the Authentication Details tab, and choose Edit. In the Authentication Type field, choose Basic, and enter the logon information for the SYSTEM user. Choose Save. Close the HTTP Destination Details screen, and choose Finish. Create a transport route using the following data:

Name

Source System Content

T_route_HA200 H94 (wdflbmt7194)

DU_HA200

On the TRANSPORT → Transports tab, choose + Create. In the dialog box, enter the data from the table. Choose Create.


Solution 18: Transport Changes

Start the transport. Select your transport route. On the TRANSPORT → Transports tab, choose Start Transport. In the dialog box, choose OK. Check the result. To check the logs, choose the TRANSPORT → Logs tab.


Unit 9 Exercise 19 Optional: Implement Mini Checks in SAP HANA studio

This exercise task is performed in the SAP HANA studio. Use the SAP HANA studio available in your WTS session. Connect to the WTS training landscape with the Remote Desktop using the following credentials:

Remote Desktop Connection

WTS training landscape

Host name


User name

train-##

Password

initial

Start SAP HANA studio and open the Administration Console. In SAP HANA studio, on the System Information tab, create a new folder named Mini Checks with the description Mini Checks. Import the SAP HANA Mini Checks from the N:\HA200 folder. Start the Mini Check for your SAP HANA database and review the results for system issues.


Unit 9 Solution 19 Optional: Implement Mini Checks in SAP HANA studio

This exercise task is performed in the SAP HANA studio. Use the SAP HANA studio available in your WTS session. Connect to the WTS training landscape with the Remote Desktop using the following credentials:

Remote Desktop Connection

WTS training landscape

Host name


User name

train-##

Password

initial

If you are still connected to the WTS training landscape, proceed to step 2. Open the Microsoft Remote Desktop application. On the Remote Desktop Connection window, in the Computer field, enter the WTS training landscape host name provided by the instructor, and choose Connect. In the Windows Security window, choose Use another account. Enter the WTS training landscape credentials from the table, and choose OK. On the Remote Desktop Connection dialog box, choose Yes.

Note: You are now connected to your WTS training landscape desktop with a gray background.

Start SAP HANA studio and open the Administration Console. From the Windows taskbar, choose SAP HANA studio. In the StartUpTool - HANA Studio window, choose Submit. In the Eclipse Launcher window, choose OK. In the Secure Storage - Password Hint Needed window, choose No. To open the Administration Overview, in the Systems view, double-click your SAP HANA system. In SAP HANA studio, on the System Information tab, create a new folder named Mini Checks with the description Mini Checks.



Choose the System Information tab. Right-click the table area, and choose New Folder. In the New Folder dialog box, in both the Name and Description fields, enter Mini Checks. Choose OK. Import the SAP HANA Mini Checks from the N:\HA200 folder. Choose the tab System Information. Right-click the Mini Checks folder, and choose Import SQL Statements. In the Import SQL Statements window, navigate to the N:\HA200 folder, and choose the SQLStatements.zip file. To unpack and import the SQL Statements.zip file, choose Open. The Mini Checks are imported into a folder named Import . Start the Mini Check for your SAP HANA database and review the results for system issues. Choose the System Information tab. Choose Mini Checks → Import → Configuration → Mini Checks. To start the Mini Checks script for an SAP HANA 2.0 database, double-click SSS. Review the results in column C. The X indicates possible system issues.


Unit 10 Exercise 20 Backup and Recovery

Business Example You want to perform a backup and recovery. Chec k the location of the directory for the data backups and the log backups. Ensure that there is sufficient free space for the backup files. Estimate the amount of free space that is needed in the backup directory.

Start SAP HANA cockpit 2.0, and connect the system database for monitoring and administration using the following information:

User Password

Database

USER94

USER95

Welcome1

Welcome1

SYSTEMDB@H94

SYSTEMDB@H95

Check the location of the directory for the data backups. Perform an estimation of the size of a backup of your system DB. Perform an estimation of the size of a backup of your tenant DB. Check the parameter settings, which control the log backup behavior (log_mode and enable_auto_log_backup ). Check the parameter settings, which control the log backup behavior.

After the preparation steps, perform a comple te data backup of your SAP HANA database system and check the size of the backup in the file system. Perform a complete data backup of your SAP HANA system DB with the SAP HANA cockpit using the following data:

Backup Type Destination Type

Complete

File

Backup Prefix

Default settings

Backup Destination

Default settings

Check that the backup has finished successfully.


Unit 10: Backup and Recovery

Perform a complete data backup of your SAP HANA tenant DB with the SAP HANA cockpit using the following data:

Backup Type

Destination Type

Complete

File

Backup Prefix

Default settings

Backup Destination

Default settings

Check that the backup has finished successfully. Check the size of the backup in the file system.

Perform a differential data backup of your SAP HANA database. Perform a differential data backup of your SAP HANA tenant database with the SAP HANA cockpit using the following data:

Backup Type

Destination Type

Differential

File

Backup Prefix

Default settings

Backup Destination

Default settings

Check that the differential data backup was performed successfully. Simulate a file system crash of your SAP HANA tenant DB. Log on to the SAP HANA system on the OS level using PuTTY. Simulate a file system crash by deleting one of the data volumes from the hdb0000X subdirectories. Restart your tenant database

Recover the tenant database to its most recent state. As a prerequisite for recovery, stop the database. Stop the tenant database. Recover the tenant database to its most recent state. When the recovery is complete, the system is online.


Unit 10 Solution 20 Backup and Recovery

Business Example You want to perform a backup and recovery. Chec k the location of the directory for the data backups and the log backups. Ensure that there is sufficient free space for the backup files. Estimate the amount of free space that is needed in the backup directory.

Start SAP HANA cockpit 2.0, and connect the system database for monitoring and administration using the following information:

User Password Database

USER94

USER95

Welcome1

Welcome1

SYSTEMDB@H94

SYSTEMDB@H95

Start Internet Explorer and connect to the SAP HANA cockpit using the following U RL: https://wdflbmt7285.wdf.sap.corp:51021 To accept the security certificate warning, choose Continue to this website (not recommended). If requested, enter the data from the table in the XS Advanced dialog box. Check the location of the directory for the data backups. In the list of recently accessed systems in SAP HANA cockpit, choose the entry for the system DB of your SAP HANA system. Choose DB Administration → Configure system properties. Search for the parameter basepath_databackup. The data backup files are written to the location specified by the basepath_databackup parameter in the persistence section of the global.ini configuration file. By default, the location for data backup files is $(DIR_INSTANCE)/ backup/data. Search for the parameter basepath_logbackup. The log backup files are written to the location specified by the basepath_logbackup parameter in the persistence section of the global.ini configuration file. By default, the location for log backup files is $(DIR_INSTANCE)/backup/log . Select the Back button to return to the SAP HANA Cockpit | SYSTEMDB@H9x — Overview screen. Perform an estimation of the size of a backup of your system DB.



In the SAP HANA Cockpit | SYSTEMDB@H9x — Overview screen, scroll down to DB Administration and choose Open SQL Console. Choose your SAP HANA system. To estimate the size of the next data backup, enter the following command:

select * from M_BACKUP_SIZE_ESTIMATIONS Choose Run . The result gives the estimated sizes for the next complete, differential, and incremental backup. The size might differ between the SELECT statement and DATA BACKUP execution. For this reason, you should include a reserve of free space. Close the Database Explorer tab to return to the SAP HANA cockpit. Perform an estimation of the size of a backup of your tenant DB. Select the Home button to return to the My Resources screen. In the list of recently accessed systems in SAP HANA cockpit, choose the entry for the tenant DB of your SAP HANA system. Scroll down to DB Administration and choose Open SQL Console. Choose your SAP HANA system. To estimate the size of the next data backup, enter the following command:

select * from M_BACKUP_SIZE_ESTIMATIONS Choose Run . The result gives the estimated sizes for the next complete, differential, and incremental backup. The size might differ between the SELECT statement and DATA BACKUP execution. For this reason, you should include a reserve of free space. Close the Database Explorer tab to return to the SAP HANA cockpit. Select the Home button to return to the My Resources screen.

Check the parameter settings, which control the log backup behavior (log_mode and enable_auto_log_backup ). Check the parameter settings, which control the log backup behavior. In the list of recently accessed systems in SAP HANA cockpit, choose the entry for the system DB of your SAP HANA system. Scroll down to DB Administration and choose Configure system properties. Search for the parameter log_mode . The log_mode parameter is located in the persistence section of the global.ini configuration file. The correct parameter setting to perform log backups is as follows: log_mode = normal Search for parameter enable_auto_log_backup .


Solution 20: Backup and Recovery

The enable_auto_log_backup parameter is located in the persistence section of the global.ini configuration file. The correct parameter setting to perform log backups is as follows: enable_auto_log_backup = yes Select the Home button to return to the My Resources screen.

After the preparation steps, perform a comple te data backup of your SAP HANA database system and check the size of the backup in the file system. Perform a complete data backup of your SAP HANA system DB with the SAP HANA cockpit using the following data:


Complete

File

Backup Prefix

Default settings

Backup Destination

Default settings

In the list of recently accessed systems in SAP HANA cockpit, choose your SAP HANA system DB . Scroll down to DB Administration and choose Manage database backups. Choose Create Backup. Specify the backup settings using the data from the table. Choose Back Up. The backup then starts. The progress of the backup is shown for all types of services (for example, name server and index server). When all the volumes are backed up, the details for the backup are shown. Select the Back button to return to the Backup Catalog. A successful Complete Data Backup is listed in the Backup Catalog. Select the Back button to return to the SAP HANA cockpit | SYSTEMDB@ — Overview screen. Check that the backup has finished successfully. In the SAP HANA cockpit | SYSTEMDB@H9x — Overview, scroll down to Alerting & Diagnostics and choose View trace and diagnostic files. Choose SYSTEMDB@ Database Diagnostic Files → → other. In the list of trace files, choose backup.log. To check that the backup has finished successfully, search for the SAVE DATA finished successfully entry. Select the Home button to return to the My Resources screen.



Perform a complete data backup of your SAP HANA tenant DB with the SAP HANA cockpit using the following data:


Complete

File

Backup Prefix

Default settings

Backup Destination

Default settings

In the list of recently accessed systems in SAP HANA cockpit, choose your SAP HANA tenant DB. Choose DB Administration → Manage database backups. Choose Create Backup. Specify the backup settings using the data from the table. Choose Back Up. The backup then starts. The progress of the backup is shown for all types of services (for example, name server and index server). When all the volumes are backed up, the details for the backup are shown. Select the Back button to return to the Backup Catalog. A successful Complete Data Backup is listed in the Backup Catalog. Select the Back button to return to the SAP HANA cockpit | @ — Overview screen. Check that the backup has finished successfully. In SAP HANA cockpit, choose Alerting & Diagnostics → View trace and diagnostic files. Select your SAP HANA system DB in the Database Explorer. Choose @ Database Diagnostic Files → → other. In the list of trace files, choose backup.log. To check that the backup has finished successfully, search for the SAVE DATA finished successfully entry. Check the size of the backup in the file system. Log on to the SAP HANA system on OS-level using PuTTY connect. To open a session, choose the Windows Menu button, and search for HA200_Putty. Start the PuTTY session for your Linux server. If you see a security alert, confirm by choosing Yes. Navigate to the following backup directory: cd /usr/sap//HDB00/backup/ data.



Determine the size of the backup files and the backup directory for the system DB using the following command: ls -lh SYSTEMDB. Determine the size of the backup files and the backup directory for the tenant DB using the following command: ls -lh DB_. Compare this result with the estimation that you performed in the third step of the first task, Check the Location of the Directory. Perform a differential data backup of your SAP HANA database. Perform a differential data backup of your SAP HANA tenant database with the SAP HANA cockpit using the following data:


Differential

File

Backup Prefix

Default settings

Backup Destination

Default settings

In the list of recently accessed systems in SAP HANA cockpit, choose your SAP HANA tenant DB. Choose DB Administration → Manage database backups. Choose Create Backup. Enter the backup settings from the table. Choose Back Up. The backup starts. The progress of the backup is shown for all types of services (for example, name server and index server). When all the volumes are backed up, the details for the backup are shown. Go back to the Backup Catalog. Differential and incremental backups are not listed in the Backup Catalog, by default. Check that the differential data backup was performed successfully. In the Backup Catalog, choose the Filter By button. Choose Backup Type. Select Differential Data Backup and Incremental Data Backup. Choose OK. Note that a successful Differential Data Backup is listed in the Backup Catalog. Go back to SAP HANA cockpit. Simulate a file system crash of your SAP HANA tenant DB. Log on to the SAP HANA system on the OS level using PuTTY.



To open a Secure Shell session, choose the Windows menu and search for HA200_Putty . Start the PuTTY session for your Linux server. If you see a security alert, confirm by choosing Yes. Simulate a file system crash by deleting one of the data volumes from the hdb0000X subdirectories. To open the directory that contains the data volumes, navigate to the following directory: cd /hana/data//mnt00001 To display the content of the dire ctory, enter the following command: ls –lh. The data volumes are located in the hdb0000X subdirectories. To delete the subdirectory hdb00003, enter the following command: rm –rf hdb00003. Restart your tenant database In the list of recently accessed systems in SAP HANA cockpit, choose your SAP HANA system DB. In the Tenant Monitoring and Administration tab of SAP HANA cockpit, choose the Overall Tenant Statuses tile. Choose the Stop Tenant button to stop the tenant database. Choose Immediately in the Stop Tenant Database dialog box and press OK. Wait until the system stops the tenant database. Choose Start Tenant. SAP HANA cockpit shows that the tenant database is starting. After a few minutes, the start fails because of the missing data volume. Some services are not running. A recovery is required. Choose Not running in the Status column. The list of services shows the services which are running. Go back to SAP HANA cockpit Overview screen. The tile Overall Tenant statuses shows that one database is not running.

Recover the tenant database to its most recent state. As a prerequisite for recovery, stop the database. Stop the tenant database. Open a Secure Shell session, choose the Windows menu and search for HA200_Putty. Start the PuTTY session for your Linux server. If you see a security alert, confirm by choosing Yes. Execute su — adm to connect to your OS user. Connect to the system database using hdbsql:



hdbsql -n -i 00 -u SYSTEM -p Welcome1 -d SYSTEMDB Execute the following command: alter system stop database immediate To exit the hdbsql tool enter \q Recover the tenant database to its most recent state. When the recovery is complete, the system is online. In the list of recently accessed systems in SAP HANA cockpit, choose your SAP HANA system DB. In the Tenant Monitoring and Administration tab of SAP HANA cockpit, choose the Overall Tenant Statuses tile. Select the tenant database from the overview. Choose ... → Recover Tenant. If a popup indicates that you need to stop the tenant database for the recovery. Choose Stop Tenant. To specify the recovery type, choose Recover to the most recent state. Proceed with Step 2. To specify the location of the most recent backup catalog, choose Default location. Proceed with Step 3. Choose the complete data backup to be used for the recovery. Proceed with Step 4. Choose Yes to use delta backups. Proceed with Step 5. Use the default locations for Data, Delta and Log backups. Proceed with Step 6. To check whether the backups are available, choose Yes. Proceed with Step 7. To specify whether to initialize the log area, choose No. Choose Review. Choose Start Recovery. The recovery starts, and the progress of the recovery for each SAP HANA service is displayed. When the recovery is complete, the SAP HANA database system is online. Go back to SAP HANA cockpit.


Unit 11 Exercise 21 Configure Data Volume and Log VolumeEncryption

Business Example You are required to configure data volume and log volume encryption of a SAP HANA tenant database. Activate data volume encryption. Activate log volume encryption. Monitor the progress of the data volume encryption.


Unit 11 Solution 21 Configure Data Volume and Log VolumeEncryption

Business Example You are required to configure data volume and log volume encryption of a SAP HANA tenant database. Activate data volume encryption. In the list of recently accessed systems in SAP HANA cockpit, choose your SAP HANA tenant system. Open the Security area. In the Data Encryption tile, switch on Data Volume Encryption. On the Switch On Data Volume Encryption dialog box, choose Yes. The Data Encryption tile indicates that data encryption is running. Activate log volume encryption. In the list of recently accessed systems in SAP HANA cockpit, choose your SAP HANA tenant system. Open the Security area. In theData Encryption tile, switch on Log Volume Encryption. On the Switch On Log Volume Encryption dialog box, choose Yes. The Data Encryption tile indicates that data encryption is activated. Monitor the progress of the data volume encryption. To show the progress of the data volume encryption, push the Data Encryption tile. The section Data at Rest Encryption indicates that data volume encryption is pending. To monitor the status of the data volume e ncryption, choose the Refresh button several times. The Encrypted status indicates that the data volumes are encrypted. To return to the SAP HANA cockpit home screen, choose the Home button.


Unit 11 Exercise 22 Enable Audit Policy

Business Example Enable audit logging and activate an audit policy. This re cords read access on the table "SAP_HANA_DEMO"."EPM.PO.Item_Part", and an audit policy records system configuration changes. Use Database Table as audit trail target. Then perform a select on table "SAP_HANA_DEMO"."EPM.PO.Item_Part" and check the resulting entry in the audit trail.

Perform general system settings for auditing. Define and activate an audit policy, which records read access on the table "SAP_HANA_DEMO"."EPM.PO.Item_Part". Define and activate an audit policy, which records system configuration changes. Check that auditing is activated and that two audit policies are enabled. Perform a select on table "SAP_HANA_DEMO"."EPM.PO.Item_Part", and check the resulting entry in the audit trail. Perform a select on table "SAP_HANA_DEMO"."EPM.PO.Item_Part". Check the resulting entry in the audit trail.


Unit 11 Solution 22 Enable Audit Policy

Business Example Enable audit logging and activate an audit policy. This re cords read access on the table "SAP_HANA_DEMO"."EPM.PO.Item_Part", and an audit policy records system configuration changes. Use Database Table as audit trail target. Then perform a select on table "SAP_HANA_DEMO"."EPM.PO.Item_Part" and check the resulting entry in the audit trail.

Perform general system settings for auditing. In the list of recently accessed systems in the SAP HANA cockpit, choose your SAP HANA tenant database. Navigate to the Security area. Choose the Auditing tile. Choose the Configuration tab. Choose Edit. In the Auditing Status field, choose Enable . Choose Save. Define and activate an audit policy, which records read access on the table "SAP_HANA_DEMO"."EPM.PO.Item_Part". Choose the Audit Policies tab. Choose Create Audit Policies. In the Audit Policy field, enter a name, for example, TABLE ACCESS. In the Policy Status field, choose Enable. In the Audited Action Status field, choose All. In the Audit Level field, choose Warning. Choose Add Actions. For audited actions, choose Data Query and Manipulation → SELECT . Choose OK. Choose Add Objects. For auditing, select the table EPM.PO.Item_Part with schema SAP_HANA_DEMO.


Unit 11: Security

Choose OK. Choose Add Users. Select the SYSTEM user. Choose OK. Choose Save. Go back to the Auditing overview screen. Define and activate an audit policy, which records system configuration changes. Choose Create Audit Policies. In the Audit Policy field, enter a name, for example, CONFIG CHANGES . In the Policy Status field, choose Enable. In the Audited Action Status field, choose All. In the Audit Level field, choose Info. Choose Add Actions. For audited actions, choose Session Management and System Configuration → SYSTEM CONFIGURATION CHANGE. Choose OK. Choose Save. Go back to the Auditing overview screen. To return to the SAP HANA cockpit home screen, choose the Home button. Check that auditing is activated and that two audit policies are enabled. In the list of recently accessed systems in the SAP HANA cockpit, choose your SAP HANA tenant database. Navigate to the Security area. The Auditing tile indicates that auditing is activated and that two audit policies are enabled. To return to the SAP HANA cockpit home screen, choose the Home button. Perform a select on table "SAP_HANA_DEMO"."EPM.PO.Item_Part", and check the resulting entry in the audit trail. Perform a select on table "SAP_HANA_DEMO"."EPM.PO.Item_Part". In the list of recently accessed systems in the SAP HANA cockpit, choose your SAP HANA system. Choose DB Administration → Open SQL Console. Enter the following command: select * from "SAP_HANA_DEMO"."EPM.PO.Item_Part" Choose Run.


Solution 22: Enable Audit Policy

Check the resulting entry in the audit trail. To check the resulting entry in the audit trail (database table), enter the following SQL command: select "TIMESTAMP", "USER_NAME", "AUDIT_POLICY_NAME", "STATEMENT_STRING" from "PUBLIC". "AUDIT_LOG" Choose Run. In the STATEMENT_STRING column, the statement select * from "SAP_HANA_DEMO"."EPM.PO.Item_Part" displays, among others.


Unit 12 Exercise 23 Maintaining Administrative Users and Authorization

Business Example You are setting up the database system, and you want to create user accounts for database administrators, developers, and end users. You also want to grant privileges to these users. These tasks are performed by authorized users. Create a user who is responsible for role management and a user who is responsible for basic administration tasks. As the SYSTEM user, create a role that authorizes role management. Grant this role to the administration user who is responsible for the role management. Then log on with the credentials of the user responsible for role management, and create two new roles to perform basic administration tasks and backups. You need a user with authorizations to cre ate roles and another user to perform basic administration tasks and backups. Create a user named ROLE_ADMIN_USER . Create a user named ADMIN_USER . To create roles using the SAP Web IDE, you require the authorizations of the sap.hana.ide.roles::EditorDeveloper role. Assign the sap.hana.ide.roles::EditorDeveloper role to the SYSTEM user. Create a new package HA200_ROLE_PACKAGE , and create the role role_builder , which allows you to create roles. Create new Package HA200_ROLE_PACKAGE using the SAP Web IDE for SAP HANA. Create a new role role_builder . This role collects all actions that database administrators are allowed to do and that are not specific to data schemas or repository packages. Therefore, grant the following privileges:


Exercise 23: Maintaining Administrative Users and Authorization

System privilege

ROLE ADMIN

Authorizes the creation and deletion of roles using the CREATE ROLE and DROP ROLE commands. It also authorizes the granting and revocation of roles using the GRANT and REVOKE commands.

Object privi- EXECUTE on REPOSITORY_REST lege (SYS)

General access to the repository

Package privileges

REPO.READ on package HA200_ROLE_PACKAGE

Read content of roles (and other development objects)

REPO.EDIT_NATIVE_OBJECTS on package HA200_ROLE_PACKAGE

Create or modify locally created (not imported) objects

REPO.ACTIVATE_NATIVE_OBJECTS on package HA200_ROLE_PACKAGE

Activate locally created (not imported) objects

REPO.MAINTAIN_NATIVE_PACKAGES on package HA200_ROLE_PACKAGE

Create, modify, or drop locally created (not imported) packages

Assign the roles role_builder and sap.hana.ide.roles::EditorDeveloper to the ROLE_ADMIN_USER user. Assign the role sap.hana.ide.roles::EditorDeveloper to the ROLE_ADMIN_USER user. You have created a user with authorizations to cre ate roles in the HA200_ROLE_PACKAGE package. You need a user with authorizations for database administration. This database administrator performs the following tasks: ●

●

All actions that any database administrator is allowed to do and that are not specific to data schemas or repository packages. All backup-related tasks

Create the roles basic_admin and backup_admin. Perform this task with the user name ROLE_ADMIN_USER . Create a new role basic_admin. This role collects all actions that any database administrator is allowed to do and that are not specific to data schemas or repository packages. Therefore, grant the following privileges:

CATALOG READ


Read access to all metadata of the database catalog. Among other things, required to enter into the administration editor of SAP HANA studio

Unit 12: Maintaining Users and Authorization

SERVICE ADMIN

Start and stop individual services (processes) of the database

INIFILE ADMIN

Modify the database configuration

TRACE ADMIN

Start and stop database traces, change the trace levels of the kernel trace

SESSION ADMIN

Kill sessions

VERSION ADMIN

Trigger garbage collection of the database’s version history (part of MVCC implementation)

LICENSE ADMIN

Install or delete license key

Create a new role backup_admin. This role allows all backup-related tasks, such as creating a database backup or managing the backup catalog or deleting backups from disk. Therefore, grant the following privileges:

CATALOG READ

Read access to all metadata of the database catalog

BACKUP ADMIN

Access to all backup functionalities except for restore (which requires OS user credentials)

Assign the roles basic_admin and backup_admin to the ADMIN_USER user. After you have created the user successfully, log on and add the user to the Navigator View of the SAP HANA studio. Confirm that your user’s schema has been created under Catalog. Assign the roles HA200_ROLE_PACKAGE::basic_admin and HA200_ROLE_PACKAGE::backup_admin to the ADMIN_USER user. Check the authorizations of the user ADMIN_USER. Add the user to the Navigator View of the SAP HANA studio. Check if the ADMIN_USER user is authorized to review the Backup Catalog.


Unit 12 Solution 23 Maintaining Administrative Users and Authorization

Business Example You are setting up the database system, and you want to create user accounts for database administrators, developers, and end users. You also want to grant privileges to these users. These tasks are performed by authorized users. Create a user who is responsible for role management and a user who is responsible for basic administration tasks. As the SYSTEM user, create a role that authorizes role management. Grant this role to the administration user who is responsible for the role management. Then log on with the credentials of the user responsible for role management, and create two new roles to perform basic administration tasks and backups. You need a user with authorizations to cre ate roles and another user to perform basic administration tasks and backups. Create a user named ROLE_ADMIN_USER . In the list of recently accessed systems in SAP HANA cockpit, choose your SAP HANA tenant database. Choose User & Role Management → Manage users. Choose + (Add) → Create User. Enter the user name ROLE_ADMIN_USER . In the Authentication Mechanism section, select the Password checkbox. Enter an initial password (for example, enter Initial1), and confirm the password. Choose Save. To return to the SAP HANA cockpit home screen, choose the Home button. Create a user named ADMIN_USER . In the list of recently accessed systems in SAP HANA cockpit, choose your SAP HANA tenant database. Choose User & Role Management → Manage users. Choose + (Add) → Create User. Enter the user name ADMIN_USER . In the Authentication Mechanism section, select the Password checkbox.



Enter an initial password (for example, Initial1 ), and confirm the password. Choose Save. To return to the SAP HANA cockpit home screen, choose the Home button. To create roles using the SAP Web IDE, you require the authorizations of the sap.hana.ide.roles::EditorDeveloper role. Assign the sap.hana.ide.roles::EditorDeveloper role to the SYSTEM user. In the list of recently accessed systems in SAP HANA cockpit, choose your SAP HANA tenant database. Choose User & Role Management → Assign role to users. In the User field, enter SYS. From the list of possible entries, choose SYSTEM. Choose Edit. Choose Assign Roles. In the search field, enter ide. Select the role sap.hana.ide.roles::EditorDeveloper, and choose OK. Choose Save. To return to the SAP HANA cockpit home screen, choose the Home button. Create a new package HA200_ROLE_PACKAGE , and create the role role_builder , which allows you to create roles. Create new Package HA200_ROLE_PACKAGE using the SAP Web IDE for SAP HANA. To log on to the SAP Web IDE for SAP HANA with SYSTEM use r, open Internet Explorer and enter the following URL: https://.wdf.sap.corp:4300/sap/ hana/xs/ide/ Log on using the credentials of the SYSTEM user. To open the editor, choose Editor. To create a new package, choose Content → New → Package. In the Package name field, enter HA200_ROLE_PACKAGE , and choose Create. Create a new role role_builder . This role collects all actions that database administrators are allowed to do and that are not specific to data schemas or repository packages. Therefore, grant the following privileges:


Solution 23: Maintaining Administrative Users and Authorization

System privilege

ROLE ADMIN

Authorizes the creation and deletion of roles using the CREATE ROLE and DROP ROLE commands. It also authorizes the granting and revocation of roles using the GRANT and REVOKE commands.

Object privi- EXECUTE on REPOSITORY_REST lege (SYS)

General access to the repository

Package privileges

REPO.READ on package HA200_ROLE_PACKAGE

Read content of roles (and other development objects)

REPO.EDIT_NATIVE_OBJECTS on package HA200_ROLE_PACKAGE

Create or modify locally created (not imported) objects

REPO.ACTIVATE_NATIVE_OBJECTS on package HA200_ROLE_PACKAGE

Activate locally created (not imported) objects

REPO.MAINTAIN_NATIVE_PACKAGES on package HA200_ROLE_PACKAGE

Create, modify, or drop locally created (not imported) packages

To log on to the SAP Web IDE for SAP HANA with SYSTEM use r, open the Chrome browser and enter the following URL: https://.wdf.sap.corp:4300/sap/ hana/xs/ide/ Log on using the credentials of the SYSTEM user. To open the editor, choose Editor. Right click H A200_ROLE_P ACKAGE → New → Role. Enter the following name for your role: role_builder . Choose the System Privileges tab, and choose the plus (+) sign. Search for System Privilege ROLE ADMIN, select it, and choose OK. Choose the Object Privileges tab, and choose the plus (+) sign. Choose Run-time, and select the PROCEDURE object type. Search for Object Privilege REPOSITORY_REST (SYS), select it, and choose OK. Select the object that has just been added. Scroll to the right, and assign the EXECUTE privilege to the REPOSITORY_REST (SYS) object. Choose the Package Privileges tab and choose the plus (+) sign. Search for Package HA200_ROLE_PACKAGE, select it, and choose OK. Select the object that has just been added.



Scroll to the right, and assign the four privileges from the table to object HA200_ROLE_PACKAGE. These are: ●

●

●

●

REPO.READ REPO.EDIT_NATIVE_OBJECTS REPO.ACTIVATE_NATIVE_OBJECTS REPO.MAINTAIN_NATIVE_PACKAGES

To save the newly created role, choose Save all. Log off from the SAP Web IDE. Assign the roles role_builder and sap.hana.ide.roles::EditorDeveloper to the ROLE_ADMIN_USER user. Assign the role sap.hana.ide.roles::EditorDeveloper to the ROLE_ADMIN_USER user. In the list of recently accessed systems in SAP HANA cockpit, choose your SAP HANA tenant database. Choose User & Role Management → Assign role to users. In the User field, enter ADMIN. In the list of possible entries, choose ROLE_ADMIN_USER. Choose Edit. Choose Assign Roles. In the search field, enter ide. Select the role sap.hana.ide.roles::EditorDeveloper, and choose OK. Choose Assign Roles. In the search field, enter build . Select the role HA200_ROLE_PACKAGE::role_builder, and choose OK. Choose Save. To return to the SAP HANA cockpit home screen, choose the Home button. You have created a user with authorizations to create roles in the HA200_ROLE_PACKAGE package. You need a user with authorizations for database administration. This database administrator performs the following tasks: ●

●

All actions that any database administrator is allowed to do and that are not specific to data schemas or repository packages. All backup-related tasks

Create the roles basic_admin and backup_admin. Perform this task with the user name ROLE_ADMIN_USER .


Solution 23: Maintaining Administrative Users and Authorization

Create a new role basic_admin. This role collects all actions that any database administrator is allowed to do and that are not specific to data schemas or repository packages. Therefore, grant the following privileges:

CATALOG READ

Read access to all metadata of the database catalog. Among other things, required to enter into the administration editor of SAP HANA studio

SERVICE ADMIN

Start and stop individual services (processes) of the database

INIFILE ADMIN

Modify the database configuration

TRACE ADMIN

Start and stop database traces, change the trace levels of the kernel trace

SESSION ADMIN

Kill sessions

VERSION ADMIN

Trigger garbage collection of the database’s version history (part of MVCC implementation)

LICENSE ADMIN

Install or delete license key

To log on to the SAP Web IDE for SAP HANA with ROLE_ADMIN_USER user, open the Chrome browser and enter the following URL: https://.wdf.sap.corp: 4300/sap/hana/xs/ide Log on using the credentials of the ROLE_ADMIN_USER user. To open the editor, choose Editor. Right click HA200_ROLE_PACKAGE → New → Role. Enter the following name for your role: basic_admin. Choose the System Privileges tab, and choose the plus (+) sign. Search for Sy stem Privilege CATALOG READ, select it, and choose OK. Repeat the same steps for the remaining system privileges from the table. (SERVICE ADMIN, INIFILE ADMIN, TRACE ADMIN; SESSION ADMIN, VERSION ADMIN, LICENSE ADMIN) To save the newly created role, choose Save All. Create a new role backup_admin. This role allows all backup-related tasks, such as creating a database backup or managing the backup catalog or deleting backups from disk. Therefore, grant the following privileges:

CATALOG READ

Read access to all metadata of the database catalog

BACKUP ADMIN

Access to all backup functionalities except for restore (which requires OS user credentials)



To log on to the SAP Web IDE for SAP HANA with ROLE_ADMIN_USER user, open the Chrome browser and enter the following URL: https://.wdf.sap.corp: 4300/sap/hana/xs/ide. Log on using the credentials of the ROLE_ADMIN_USER user. To open the editor, choose Editor. Right click HA200_ROLE_PACKAGE → New → Role. Enter the following name for your editor: backup_admin. Choose the System Privileges tab and choose the plus (+) sign. Search for System Privilege CATALOG READ, select it, and choose OK. Repeat the same steps for the System Privilege BACKUP ADMIN. To save the newly created role, choose Save All. Assign the roles basic_admin and backup_admin to the ADMIN_USER user. After you have created the user successfully, log on and add the user to the Navigator View of the SAP HANA studio. Confirm that your user’s schema has been created under Catalog. Assign the roles HA200_ROLE_PACKAGE::basic_admin and HA200_ROLE_PACKAGE::backup_admin to the ADMIN_USER user. In the list of recently accessed systems in SAP HANA cockpit, choose your SAP HANA tenant database. Choose User & Role Management → Assign role to users. In the User field, enter ADMIN. In the list of possible entries, choose ADMIN_USER . Choose Edit. Choose Assign Roles. Select the roles HA200_ROLE_PACKAGE::basic_admin and HA200_ROLE_PACKAGE::backup_admin . Choose OK. Choose Save. To return to the SAP HANA cockpit home screen, choose the Home button. Check the authorizations of the user ADMIN_USER. Add the user to the Navigator View of the SAP HANA studio. To add the ADMIN_USER user, open the context menu of the system node, and choose Add System with Different User … Enter the user ID, and in the password field, enter Initial1 , and choose Finish. When prompted for a new password, enter Welcome1, for example.


Sap La Ha200 en 14 Ex

Recommend Documents