List all Connected Applications to SAP HANA

 List all Connected Applications to SAP HANA
April 19, 2018 | No Comments »

You can use below SQL query to list all application connections which are connected to SAP HANA system from SQL editor.

LIST & KILL Sessions on HANA

LIST & KILL Sessions on HANA
April 17, 2018 | No Comments »

If you need to LIST all sessions or KILL a specific active session on HANA then you can use the following SQL queries to do these kind of actions easily..

Check Memory Usage and DB Size on HANA via SQL

Check Memory Usage and DB Size on HANA via SQL
April 11, 2018 | No Comments »

You can use the following SQL queries to check your HANA system’s memory usage details…

Activate / Deactivate user in SAP HANA DB

Activate / Deactivate user in SAP HANA DB
April 09, 2018 | No Comments »

The administrator can “activate / deactivate” a user account with the following SQL command or SQL console of the SAP HANA studio, the only prerequisite is, you need to have system privilege “USER ADMIN”.

HANA Backup and Recovery SQL Queries

HANA Backup and Recovery SQL Queries
April 02, 2018 | No Comments »

You can find some helpful SQL queries in this article to check your HANA database backup status to use in case of recovery situation.

Useful Python Scripts for HANA

Useful Python Scripts for HANA
March 12, 2018 | No Comments »

All python scripts can be found in exe/python_support directory.

These scripts can affect the system therefore it’s better to check with ‘-help’ switch before executing the scripts.

HANA Cleaner Python Script – hanacleaner.py

HANA Cleaner Python Script - hanacleaner.py
March 07, 2018 | No Comments »

SAP HANA cleanup tasks like purging the backup catalog or deleting old trace files need to be implemented individually.SAP created a Python script which called as HANACLEANER.PY to perform these tasks automatically.

SAP HANA Release Strategy for HANA 1.0 and HANA 2.0

SAP HANA Release Strategy for HANA 1.0 and HANA 2.0
December 25, 2017 | No Comments »

There are several terms used to describe parts of the SAP HANA release strategy.Also HANA 1.0 and HANA 2.0 have big differences according to SAP HANA release strategy documentations and snotes which i am going to try to explain in this article.

Find Installed Plugins on HANA Database

Find Installed Plugins on HANA Database
December 04, 2017 | No Comments »

If you want to list “Plug-ins” which installed on your HANA database system, then you can do this via “SAP HANA Administration Console” or on OS level with following steps…

HANA Database Revision Upgrade on OS Level (HDBLCM)

HANA Database Revision Upgrade on OS Level (HDBLCM)
November 27, 2017 | No Comments »

You can upgrade your “HANA Database Revision Level” with Web Support or OS level steps, in this note; i would like to share my “HANA 1.0″ revision upgrade from level 03 to level 11 on “SUSE Linux 12 SP2″ Operating System via OS level steps.

Check for SAP HANA Components Updates

Check for SAP HANA Components Updates
November 20, 2017 | No Comments »

HANA database can be updated using SAP HANA Platform Lifecycle Management, before that you should download the needed files and at this point you can use “Check for SAP HANA Components Update” option to make life eaiser…

SAP Security : “Password Blacklist” Import Methods for ABAP / JAVA / HANA

SAP Security : "Password Blacklist" Import Methods for ABAP / JAVA / HANA
November 16, 2017 | No Comments »

According to security reasons you might want to implement “SAP Password Blacklist” to your various SAP / DB systems, then you can use the following patterns for this issue…

Monitor SAP HANA Systems during START and STOP Process

Monitor SAP HANA Systems during START and STOP Process
August 14, 2017 | No Comments »

You can get detail informations and status via “Diagnosis Mode” about your SAP HANA system during the START and STOP operations.

Export & Import a List of SAP HANA Systems

Export & Import a List of SAP HANA Systems
August 08, 2017 | No Comments »

You can Export a list of your SAP HANA systems from your “SAP HANA Studio” or you can Import a list of SAP HANA systems to your “SAP HANA Studio” easily with following steps…

HANA Database Services /Stop/Start/Kill/Reconfigure

HANA Database Services /Stop/Start/Kill/Reconfigure
August 02, 2017 | No Comments »

We can easily “Stop / Start / Kill / Reconfigure” HANA system services and “Reset Memory Statistics” over “SAP HANA Administration Console”

Add a HANA System to HANA Administration Console

Add a HANA System to HANA Administration Console
July 27, 2017 | 1 Comment »

If you want to add a new “HANA System” to your “HANA Administration Console”, then you can use the following steps…

Find The Schema Owner of HANA Schema

Find The Schema Owner of HANA Schema
July 12, 2017 | No Comments »

If you want to know the owner of the HANA schema then you can use the following SQL statement , don’t forget that you need “READ Access” authorization to “SYS” schema to execute this sql.

Current size of the “Used Memory” in HANA

Current size of the "Used Memory" in HANA
July 10, 2017 | No Comments »

You can get the current size of the “used memory” for your HANA system easily with following SQL command…

HANA Database Upgrade from 1.0 to 2.0

HANA Database Upgrade from 1.0 to 2.0
June 13, 2017 | No Comments »

Start the process by following selection ;

HANA Administration Console -> Select the System -> Lifecycle Management

-> Platform Lifecycle Management -> SAP HANA Platform Lifecycle Management

SAP HANA Offline Cockpit

SAP HANA Offline Cockpit
March 02, 2017 | No Comments »

To diagnosis and analyze errors while SAP HANA is stopped or cannot be reached due to performance problems, you can access diagnosis files in the SAP HANA cockpit for offline administration.

SAP HANA Cockpit

SAP HANA Cockpit
February 24, 2017 | No Comments »

If you want to administrate and monitor your SAP HANA databases , you can use the “SAP HANA Cockpit” tool.SAP HANA cockpit, a web-based HTML5 user interface that you access through a browser, runs on SAP HANA extended application services, advanced model.

SAP HANA License Types

SAP HANA License Types
February 17, 2017 | 5 Comments »

You can find the details of “SAP HANA License Types” and difference of the “Unenforced” and “Enforced” options in this article…

Use SAP HANA HDBSQL to execute SQL commands at OS level

Use SAP HANA HDBSQL to execute SQL commands at OS level
February 14, 2017 | No Comments »

If you want to access SQL prompt using HDBSQL at OS level, then you need to follow below steps and  passwords of the user <SID>ADM and one of the HANA database users’s password.

Check and Install HANA License

Check and Install HANA License
February 10, 2017 | 1 Comment »

You can find the details of HANA licensing issues in this post, so you can; “Check” , “Get” and “Install” your SAP HANA license easily…

Blogroll