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 ;
Everything About SAP Basis
Archive for April, 2018
SAP HANA Status Check via SAPCONTROL
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
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
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”.
CHECK_REQUIREMENTS QUEUE_NOT_EMPTY Error while SPAM Update
You are trying to update your SPAM version on your SAP system and process canceled with the error CHECK_REQUIREMENTS –> QUEUE_NOT_EMPTY.In this case, you can check the below steps to clarify and solve the issue…
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.
Featured Posts
-
Asking and Answering Questions in the SAP Community
-
Performance Issues on ABAP Stack
-
What is RISE with SAP ?
-
SAP Spool : “Waiting in host spooler (Position 1)”
-
SAP Security Patch Day for December 2022
-
ITAB_DUPLICATE_KEY in XPRA phase
-
“Upgrade is running! No import possible” in ACT_UPG
-
ORA-12154: TNS:could not resolve the connect identifier specified
-
SAP Security Mandate: SAP Software and Log4J Remote Code Execution
-
SAP HANA 2.0 Revision Strategy
Recent Comments