Find SAP HANA Database LOG and TRACE File Directories

HANA LOG  and TRACE files are located under /usr/sap/< SID >/HDB< Instance number >/< hostname >/trace directory.If you are using multitenant structure, then this directory shows SYSTEMDB and you can find TENANT logs and trace files under own directory (DB_SID).

You can find the LOG & TRACE directory location via following SQL query  ;

SELECT * FROM M_DISKS WHERE USAGE_TYPE = ‘TRACE’ ;

HANA Trace and Log Files

On OS level you can list the related log files ;

saptrace02

Also you can check the trace files like below ;

Find SAP HANA Database LOG and TRACE File Directories

After logon as “<SID>adm” user you can directly go to trace/log directory easily with “cdtrace” command ;

saptrace04

For tenant DB log and trace files, we need to go to under related “DB_<SID>” directory ;

Find SAP HANA Database LOG and TRACE File Directories

 

 

 

 

Leave a Reply


six × 2 =

Blogroll