Online Tutorials & Training Materials |
Register Login

Execute HANA SQL Trace Analyzer Python Tool

09 Aug 2017 1:19 pm || 0

How to execute SAP HANA SQL Trace Analyzer Python tool?

You can call the Python script with different options as listed below:

python [-s <split-filename>] [-c <catalog-dir>] [-m <merge-stat-file>] [-u <user>] [-k <top k values to show>] [-disjunct] [-tr] <sqltrace-filename> [<sqldump-file>] [<tables-file>]

With the '-tr' option local temp table names can be replaced by the common placeholder "#<local-temp-table>". This is useful to generate accumulated statistics for statements on generated temp table names that only differ in the generated table name.


python <sqltracefile>

python /usr/sap/<SID>/HDB00/host/trace/