SAP Online Portal

Latest SAP News, Solutions, Error Codes, Help Files, Jobs, Documentations, Articles

10 Useful Python script for HANA

Python support scripts of the HANA Database as HANA 1.0 SPS12

The python support can be found in /usr/sap/<SID>/HDB<XX>/exe/python_support.
Usually you can use the option ‘–help’ and ‘–helpGeneral’ on each scripts. Be carefeful before you execute one, these scripts can impact the system.
You can use HDBSettins.sh combined with the script, which passes the necessary variables towards.
Example:
HDBSettings.sh fullSystemInfoDump.py –help

fullSystemInfoDump.py
Collects diagnosis information from the SAP HANA database
Some options:
-F FROMDATE, –fromDate=FROMDATE
Collects trace files starting from the specified date
(format: YYYY-MM-DD)
-T TODATE, –toDate=TODATE
Collects trace files up to the specified date (format:
YYYY-MM-DD)
-e EXPORTPATH, –exportPath=EXPORTPATH
Path to exported tables/views
-t TENANT, –tenant=TENANT
Specifies the tenant where the files are to be
collected
Example:
python fullSystemInfoDump.py -F 20171110 -T 20171112

getParameter.py (download from 2399996)
Reads values from various HDB ini files.
Example:
python getParameter.py –key=global/persistence/log_mode

hanacleaner.py
Cleans up backup catalog, trace files, alerts, audit logs, etc – can be set as a periodic task.
This script is an expert tool designed by SAP support. You are allowed to use it, but SAP doesn’t take over any responsibility for problems originating from the use of this tool.
Example:
(trace files, statistics server alerts and backup catalog entries, i.e. not the backups themselves, older than 42 days
are deleted and backup logs bigger than 50 mb are compressed and renamed and logsegments a removed if more than 20
free once exist for a service):
> python hanacleaner.py -tc 42 -tf 42 -ar 42 -bd 42 -zb 50 -lr 20 -eh 2 eu -42
AUTHOR: Christian Hansen
(2399996 – How-To: Configuring automatic SAP HANA Cleanup with SAP HANACleaner)

HanaHwCheck.py
Show complete HW information
Example:
python HanaHwCheck.py -v

Read full article here..

https://blogs.sap.com/2017/11/23/10-useful-python-script-for-hana/

Leave a Reply

Your email address will not be published.

Related topics

Accenture and SAP to optimise manufacturing supply chains on S/4 HANA

Accenture and SAP are combining forces to develop extended materials requirements planning (MRP) solutions based on SAP S/4HANA to optimise manufacturing industry ROI through more […]

Step Up For Students Partners with SAP Ariba and Premikati to Create MyScholarShop, an Online Education Marketplace for Florida K-12 scholars

When it comes to serving Florida’s most disadvantaged K-12 students through opportunity scholarships, Step Up For Students leaders always look for ways to better serve its families, […]

What is Artificial Intelligence?

Technology is already more advanced than humans in some areas. But how can businesses benefit from this? One term you frequently hear in this context […]

High Availability for SAP HANA in Public Clouds

For organizations running production applications, it is essential to provide 99.999% uptime for their mission critical applications and deploy their applications in a highly available […]

High Availability of SAP HANA on Azure Virtual Machines (VMs)

On-premises, you can use either HANA System Replication or use shared storage to establish high availability for SAP HANA. On Azure VMs HANA System Replication […]