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/