Sap Basis Jobs

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...
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...
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...
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...
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...
Changing HTTP to HTTPS for Repository and Directory Tools for NWA

If you want to use HTTPS protocol for your NWA internal addresses instead of HTTP address redirection, then you can use the following steps to...
S/4 HANA Readiness Check

“S/4 HANA Readiness Check” is a tool from SAP that help you to prepare your SAP system to S/4 HANA upgrade.You can use this cloud-based...