Category: SAP BLOGS and TUTORIALS

There are multiple way to stop and start SAP HANA Tenant Database . But i personally prefer to stop and start SAP HANA Tenant Database using SAP HANA Studio . Step 1- Launch SAP HANA Studio and open SQL console .     Once SQL Console is open then you can execute below mentioned sql commands for Stop and Start SAP HANA Tenant Database.   How to Stop SAP HANA Tenant Database: ( SMH is TENANT DATABASE SID): alter system stop database SMH   How to verify if Tenant database has been stopped: Execute SQL command: select * from m_databases; ACTIVE ……

In this tutorial I’ll explain How to list all the HANA databases for Multi tenant Databases.   Step 1– Launch SAP HANA Studio and open SQL console .( using SYSTEMDB)   Step 2 – Execute query  ” select * from m_databases “.     Note: If above query is executed from different user apart from “SYSTEM” then you’ll not get the list of all the tenant databases . M_DATABASES only shows the current SYSTEMDB. Solution : Provide DATABASE ADMIN or DATABASE STOP or DATABASE START privilege to the said user (in SYSTEMDB) then execute :  select * from M_DATABASES again from ……

If You are experiencing high memory consumption / out of memory situations . SAP is asking you to generate full system dump for further analysis. This blog with help you to generate Generate full system dump in hana. Goto  /usr/sap/<SID>/HDBXX/exe/python_support directory Run python script fullSystemInfoDump.py as following:   <HOSTNAME>:/usr/sap/<SID>/HDB10/exe/python_support> python fullSystemInfoDump.py -t <TENANT SID> System Info Dump created 2019-07-22 11:09:20 (UTC) with script version 2.00 Called with command line options: -t <TENANT SID> Writing to file /usr/sap/<SID>/SYS/global/sapcontrol/snapshots/fullsysteminfodump_SMH_SM1_solman_2019_07_22_11_09_20.zip —– 2019-07-22 16:39:20 Generate esserver stack file —– SNo running esserver found for database <TENANT SID> —– 2019-07-22 16:39:23 Exporting xsenginetraces —– No files found matching ……

If You are experiencing high memory consumption / out of memory situations . SAP is asking you to generate a runtime dump for further analysis. This blog with help you to generate a runtime dump in HANA database.   Easiest way to generate runtime dump is from OS Level:   1) Log into the HANA host as sidadm user 2) Run command ‘hdbcons’ 3) On the hdbcons console run command below > runtimedump dump This will create a runtimedump for the host . runtime dump file will be under traces directory with naming like ‘indexserver….rtedump.trc’.   Generate runtime dump from Python script ……

How to Generate Kernel Profiler trace in HANA If You are experiencing high memory consumption / out of memory situations . SAP is asking you to provide a Kernel Profiler Trace. This blog with help you to generate kernel profiler trace in HANA database. start a kernel profiler trace on OS level by running the following command as HANA sidadm >hdbcons -p <pid_of_the_problematic_tenant_indexserver> >profiler clear >profiler start {wait for 4-5min} >profiler stop >profiler print -o profiler_cpu.dot,profiler_wait.dot   This will basically create a kernel profiler trace and a HANA runtime dump. The tracefiles will be stored in the HANA tracedirectory.   SAMPLE ……