Specifying the port for SAP HANA Cockpit before installation

Specifying the port for SAP HANA Cockpit before installation
July 17, 2018 | No Comments »

During the installation of SAP HANA Cockpit, the installation assigns free ports to SAP HANA Cockpit and SAP HANA Cockpit Manager.

Installing HANA Cockpit 2.0

Installing HANA Cockpit 2.0
July 12, 2018 | No Comments »

SAP HANA cockpit is part of the SAP HANA platform 2.0.The SAP HANA 2.0 Cockpit install comprises XS Advanced, a set of XSA multi-target applications, and HANA Express.A single HANA 2.0 Cockpit can administer and monitor many SAP HANA database systems, including both SAP HANA SPS12 and SAP HANA 2.0 systems.

SAP HANA Database Software Installation

SAP HANA Database Software Installation
June 04, 2018 | No Comments »

Installing  “SAP HANA Database Software” is very easy prosedure with the command “hdblcm”, you only need to provide needed command line informations and thats it..

HANA Database Server Uninstall

HANA Database Server Uninstall
May 31, 2018 | No Comments »

If you want to uninstall your “SAP HANA Database Components” on DB server installation, then you can use the command “hdblcm” and complete the unintall operation fast and easily….

SAP Application Server on HANA Uninstall Steps

SAP Application Server on HANA Uninstall Steps
May 28, 2018 | No Comments »

If you want to uninstall your SAP HANA “Application Server” then you need to use “./sapinst” option of SWPM to do it easily…

Find SAP HANA Database LOG and TRACE File Directories

Find SAP HANA Database LOG and TRACE File Directories
May 18, 2018 | No Comments »

HANA LOG  and TRACE files are located under /usr/sap/< SID >/HDB< Instance number >/< hostname >/trace directory.If you are using multitenant structure, then this directory shows SYSTEMDB and you can find TENANT logs and trace files under own directory (DB_SID).

HANA Software Installation via “hdbinst” command

HANA Software Installation via "hdbinst" command
May 15, 2018 | No Comments »

You can install HANA database easily via command “hdbinst” on OS level in approximately 15 minutes (you can use  “hdbsetup” for GUI installation)…

Get Description for a HANA Table Instead of usage DESC

Get Description for a HANA Table Instead of usage DESC
May 10, 2018 | No Comments »

There is no DESC command on HANA database to get “description” about a table structure, therefore if you need to get this information u can use the following SQL command on HANA database…

Create Diagnosis Dump File with HANA Studio

Create Diagnosis Dump File with HANA Studio
May 07, 2018 | No Comments »

We can create the “Diagnosis File” via HANA Studio to use in case of our incedent requests.File generation process will take from seconds to minutes according to you HANA Database and using the HANA Studio is the easiest way to create these diagnosis files with just a few clicks…

Upgrade HANA 1.0 to HANA 2.0 on OS Level

Upgrade HANA 1.0 to HANA 2.0 on OS Level
May 03, 2018 | No Comments »

You can find “Upgrade HANA 1.0 to HANA 2.0 via Hana Administration Console” in the blog but this time we are going to do this on “Operation System” level…

Find Active HANA Ports via SQL Queries

Find Active HANA Ports via SQL Queries
April 26, 2018 | No Comments »

If you want to list “Active HANA Ports” on OS or HANA Admin Tool via SQL, then you can try to use below SQL queries to do it easily ;

SAP HANA Status Check via SAPCONTROL

SAP HANA Status Check via SAPCONTROL
April 23, 2018 | No Comments »

You can easily check you SAP HANA system’s status on Linux system via “sapcontrol” command…To do this “GetSystemInstanceList” and 

“GetProcessList” switchs are enough…

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…

Blogroll