You can use below SQL query to list all application connections which are connected to SAP HANA system from SQL editor.
SAP Basis, SAP Security, S/4HANA, Fiori, SAP Administration
-
How to Resolve SAML2 HTTP 500 Errors Caused by HTTP Allow List Restrictions
When performing a server migration, hostname update, or domain change in an SAP landscape, one of the most common issues administrators encounter is...
-
Automatically Reorganizing Short Dumps
In order to clean the shortdumps in the system with certain criteria, the “SAP_REORG_ABAPDUMPS” job (Program Name : RSSNAPDL) must be...
-
Reset the password of user Administrator of SAP Cloud Connector
Reset the password of user Administrator of SAP Cloud Connector – Stop the SAP Cloud Connector Service with the following command; #service...
-
Dumps after SPAM aborts while Importing SAP Support Package
If the SPAM transaction is canceled or there is a connection interruption during the transfer of SAP Support Packages, errors as stated below may...
-
SAP HotNews : RSPO1043 detects false inconsistencies and deletes spool requests
If you are storing ADS spool requests in the database and not in the default way in the filesystem or you are on one of this SPs or higher ; ...
-
SAP extends support deadline for getting off legacy software
SAP has announced an extension for support for legacy systems for certain customers who sign up for specific ERP cloud migration deals. ...
-
500 Internal Server Error via Web Browser
When trying to open a web browser-based screen via a transaction code in SAP, a “500 Internal Server Error” error may be received. ...
-
Asking and Answering Questions in the SAP Community
SAP provides a convenient channel through which you can ask questions about any SAP topic. Before asking a question, you can also browse the...
-
Performance Issues on ABAP Stack
Today we are going to check performance issues on ABAP stack…The system may be up and running, but performance issues will hurt...
-
What is RISE with SAP ?
RISE with SAP is a “Business Transformation as a Service (BTaaS) product that focuses on shifting customers into the SAP cloud product...
LIST & KILL Sessions on HANA
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
You can use the following SQL queries to check your HANA system’s memory usage details…
Activate / Deactivate user in SAP HANA DB
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
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
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
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
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
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)
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
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
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
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
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
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
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
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
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
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
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
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
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
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
You can find the details of HANA licensing issues in this post, so you can; “Check” , “Get” and “Install” your SAP HANA license easily…
Featured Posts
-
How to Resolve SAML2 HTTP 500 Errors Caused by HTTP Allow List Restrictions
-
Automatically Reorganizing Short Dumps
-
Reset the password of user Administrator of SAP Cloud Connector
-
Dumps after SPAM aborts while Importing SAP Support Package
-
SAP HotNews : RSPO1043 detects false inconsistencies and deletes spool requests
-
SAP extends support deadline for getting off legacy software
-
500 Internal Server Error via Web Browser
-
Asking and Answering Questions in the SAP Community
-
Performance Issues on ABAP Stack
-
What is RISE with SAP ?
Recent Comments