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…

SAP HANA System START|STOP|RESTART Information Log

SAP HANA System START|STOP|RESTART Information Log
February 08, 2017 | No Comments »

You can easily find the detail informations of your SAP HANA system; when was started/stopped/restarted from the log file  “history.glf”

SAPCONTROL Command Funtions for SAP HANA

SAPCONTROL Command Funtions for SAP HANA
January 20, 2017 | No Comments »

You can use the “sapcontrol” command for various operations and informations on SAP HANA systems with assigned FUNCTION switches.

Possible Rowstore Table Corruption When Continuous Page Flush is Enabled

Possible Rowstore Table Corruption When Continuous Page Flush is Enabled
January 09, 2017 | No Comments »

If you encounter corruptions in row store tables consistency check reports like “pointing to free variable part found;rowid=xxx;

offset=8;typeid=37;ext_rowid=xxx” then you should check the following OSS note and the steps which we completed.

Reset the HANA SYSTEM User’s Password

Reset the HANA SYSTEM User's Password
January 04, 2017 | No Comments »

If your – HANA - SYSTEM user’s password is lost, then we can reset the password for this user as operating system administrator with starting the “index server” in emergency mode.

Enabling AUTOSTART of SAP HANA Database on Server Boot Situation

Enabling AUTOSTART of SAP HANA Database on Server Boot Situation
August 15, 2016 | No Comments »

If you want to enable AUTOSTART option for your HANA database after a server reboot situation then you can do it with editing the following file…

SAP HANA Studio Installation

SAP HANA Studio Installation
July 11, 2016 | No Comments »

You can easily install “SAP HANA Studio” in this article , just follow the steps…

Download SAP HANA Studio

Download SAP HANA Studio
July 04, 2016 | No Comments »

If you have a valid user ID from SAP then you can download “SAP HANA Studio” from SAP Service Market Place with the following address

HANA Cloud Platform for Trial

HANA Cloud Platform for Trial
June 28, 2016 | No Comments »

SAP provides a trial instance of HANA Cloud and you can be used for learnind porposes.If you want to discover new SAP HANA Cloud Platform for free then you can create a trial account with the following steps easily…

HANA TCP/IP Ports

HANA TCP/IP Ports
June 16, 2016 | No Comments »

You can find the TCP/IP (Transmission Control Protocol/Internet Protocol) ports for HANA system in this post.

Suite on HANA Sizing Report

Suite on HANA Sizing Report
June 01, 2016 | No Comments »

If you are wondendering of your SAP Suite system’s “Memory and DB” size transformation after a HANA migration operation then you should implement the following OSS notes and execute the SAP report “/SDF/HDB_SIZING” to get these detail informations.

HANA Installation on SUSE Linux

HANA Installation on SUSE Linux
April 08, 2016 | No Comments »

You can install the HANA on SUSE linux OS system accordingly this post easily , just follow the screens and check the remarks…

SAP HANA Certified Hardware Check

SAP HANA Certified Hardware Check
March 31, 2016 | No Comments »

If you want to implement or migrate your SAP system to a new HANA system then first thing you should do is checking the hardware certified situation , to do this , you can use the below updated SAP official web site.

Blogroll