Sap Support

- Sap Support - Dump files for support

Log & Trace file

- Log and trace directories - Investigate backup log content

Sap Hana Global Administration

- Daily Tasks - Start/Stop database - Start/Stop Hana System


- Get Sap hana version details - Get to Log and Trace file directories - Get log backup directories - Get Sap Hana default Port - Get Session Details - Get hana user status - Get dump files diagnosis - Generate dump files diagnosis - Get user store key connection details

Tools : Hana Studio

- Installation - Using hana studio - Using Studio SQL Console

Tools : sapcontrol

- Start hana system - Stop hana System - Useful commands - troubleshoot "fail nieconn refused..."

Tools : hdbsql

- Using hdbsql - hdbsql parameters - Executing SQL - Hiding header welcome message - Hiding column header - Update column delimiter - Formating output result

Tools : hdbuserstore

- Find user store key details - hdbuserstore syntax examples

Tools : hdbrsutil

- hdbrsutil tips & tricks

Tools : Hana Cockpit

- Install hana cockpit 2 complete example - Un-Install hana cockpit 2

Sap Hana Backup & Recovery

- Backup & Restore a tenant database - Backup - Restore/Recover - Checking - Log backup directories - Remove old log backup - Get backup catalog size - Restore database manually - Analyse backup log file content - Troubleshoot backint backup

Sap Hana Security

- Securing sap hana - What to do before password update - Connection & Password - Privileges to unlock a user. - Update password expiration date - Roles and privileges


- Disk space used by log segments - Reclaim space from log segments - Retrieve table index space used on disk

Specific Operations

- Adding physical memory

Sap Hana User Privileges

- Role and privileges - Grant read access to a schema

Stored procedures

- Creating a procedure - Dropping a procedure - Compiling a procedure - Executing a procedure - Working with procedures - Using anonymous block

Sap Hana functions

- DateTime : ADD_YEARS - DateTime : EXTRACT


- Configuring sap hana - Kill long queries automatically


- Sql guide line - How to use SQL -Sql references - Sql tips & tricks for tables

SQL Query

- SQL & Tables - SQL & syntaxes - How to practice SQL


- Physical memory - Memory Investigation Scenarios - Memory analysis - Memory usage details - Allocated Memory - Peak used memory usage details - Peak Memory between 2 dates - Peak Memory for a tenant database - Used memory - Used memory - Tables - Used memory - System Tables - Used memory - Column tables - Used memory - Column tables main storage - Used memory - Column tables Delta storage - Used memory - Row tables - Used memory - Processes & Services - Used memory SQL - Used memory - code & stack - Table storage comparison

Sap Hana Tables

- Managing tables - Various ways to create Tables - Sap Hana Tables - Sap Hana Temporary Tables

Table description & DDL

- Retrieve table description - Table description using table-columns-view - Table ddl with hana studio - Table ddl using 'get_object_definition' procedure - Table ddl using hdbsql


- Various ways to select data


- Various ways to insert data


SQL Programming

- Sql scripting


- Using variables - Declaring & using variables - Variable data types - Local scalar variables - Variables & anonymous-blocks - Query result into a variable - Using a variable containing an SQL syntax

If and Else

- If & else examples - Various ways to use If & else

While Loop

- While loop examples

For Loop

- Using for loop - Breaking out for loop - Skipping statement in for loop - Insert into table with for loop - Using Function with for loop - Using reverse for loop

Shell scripts

- hdbsql & shell scripts

Sap Hana Users

- Managing Users - Create user with hana studio - Create user with sql Script - Create multiple users in one go - Copy a user - Create User with SQL script - Create User via Hana Studio - Update User - Drop User

Create Standard User

- Create standard & personal User

Create Technical User

- Create a technical User - Create backup users - Create administrator users - Create Modeler User - Create Data provisioning User - Create Cockpit User - Create a user to unlock any users

User administration

Unlock User

- Activate a user - Unlock Standard and Technical User


- Connection & Password Security - Reset User connection attempt - Update login until date


- New user password - Update with old password - Reset System user lost password - Update password expiration date - Disable password validity period - Change password on first login - Change password on next login

Investigations & troubleshooting

- Retrieve User details - Check user active or not - Check user status - Check password expiration date - Show Password expiration date - Troubleshoot User

De-Activate/Lock User

- Activate User - De-activate User - Activate System User


- Overview


- User connection - General Connection issues - Connection failed RTE 89006 - Alert 10: passwd authentication


- Tenant already active when starting tenant - Common issues - Bugs - Errors - Performance - Troubleshoot Memory - Troubleshoot Memory issues - Alerts - Scripts and Procedures - Volume Disk Full - Long queries - Alert 65 log backup running too long - Alert 413: cannot reuse password - Alert 414: password to be changed - Alert 431: password expiration - 503 Service not available - Reset System User lost password - Hana System cannot start - Locked users.

How to see which sap hana version is currently installed?

Getting SAP HANA database version can be done in different ways. It all depends on which way is the most appropriate for you. The following examples show several ways to obtain current sap hana installation version details as well as how to check up for any recommanded patch update: Using Sap Hana Studio, Using Sap Hana Cockpit, Using SAPGUI, Using HDB, Using an SQL query.

How to show sap hana version using sap hana studio?

This method is the easiest if you have sap hana studio opened on your client interface or on the sap hana server. It is a 3 steps procedure and you get the current version as well as all historical installations.

How to look for sap hana version using sap hana cockpit?

This method is very simple and fast if sap hana cockpit is already opened. Sap Hana version details are immediately available on the main page under the box "Database Information". Further details such as patch installation history can be accessed by clicking the Title "Database Information"

How to retrieve sap hana version details using an SQL query?

If you are using the SQL query to retrieve your current sap hana version details, you will be able to get the answer using any sap hana sql interface such as hana studio SQL console or hdbsql.

hdbsql=> \c -i 02 -d systemdb -u admin_user -p Sys4hundred Connected to hdbsql SYSTEMDB=> \al Aligned output mode switched ON hdbsql SYSTEMDB=> SELECT * FROM SYS.M_DATABASE; | SYS | DATABASE | HOST | START_TIME | VERSION | USAGE | | --- | -------- | ------ | ----------------------------- | ---------------------- | ----------- | | TAX | SYSTEMDB | linux7 | 2021-01-03 13:33:48.928000000 | | DEVELOPMENT |

How to show sap hana version details at the OS level with HDB?

This method is the quickest if you are already connected as < sid >adm. It provides you with a quick and easy way to copy the result content if you need to paste the details in a report such as a SAP support template request.

taxadm@linux2:/usr/sap/TAX/HDB02> HDB version HDB version info: version: branch: tgl/newdb120_rel git hash: e0f41240503a1a3398bf7a3eb1171c0fb2eafad4 git merge time: 2021-01-03 00:25:51 weekstone: 0000.00.0 compile date: 2020-12-03 00:44:41 compile host: fed7284 compile type: rel

How to show SAP Hana Release and Patch Level details with sap GUI?

From the sap GUI Menu: select "System" , "Status". Go to the sap hana database System to get the Release details.

Where to find out about the latest sap hana database version available?

Getting the previous and also the latest sap hana version details available is not that difficult. It is just a matter of going to the sap web site. You will find out what has been improved and what new enhancements and capabilities have been added to the latest sap hana patch and also to any sap hana newest version.

Here is the best place to find out :

How to get latest sap hana revision and patch level details?

In order to get bug corrections and any security patches you can get to the following site and look at the sap note: 2115815. You will get all necessary details about which sap hana revisions can be applied on your hana system.

Sap hana SQL

Sap hana tools

- - -