Requirement : You want to access HANA error logs and trace files.How to configure HANA log/trace file rotation?
Prerequisite : You need <SID>adm credentials to check logs at OS level and you need TRACE ADMIN or DATA ADMIN to view or delete log files in HANA Studio.
At OS level these diagnosis files(trace and log files) are generated at following location of each node/hostname.
For System DB :
/usr/sap/<SID>/HDB<nn>/<hostname>/trace Or $DIR_INSTANCE/<hostname>/trace
You can also execute shell command alias cdtrace to access these files.
Starting HANA 2.0 , the trace file of HANA SID(tenant) has its own folder within the main trace folder.
For HANA SID , tenant:
/usr/sap/<SID>/HDB<nn>/<hostname>/trace/DB_<SID> Or $DIR_INSTANCE/<hostname>/trace/DB_<SID>
DB_<SID> is the logs folder for tenant logs.
As you can see the trace files are stored separated per host,so to get access to the trace files of a multi-node system you have to check for each host individually.
One can get all trace file location info by executing following SQL in HANA :
SELECT * FROM M_DISKS WHERE USAGE_TYPE ='TRACE';
The best way to analyze these files is using HANA Studio - Administrative perspective - Diagnosis Files page tab.
This provides us an option to Merge Diagnosis Files - This feature is very helpful during troubleshooting as we can review multiple diagnosis files in one go.
Reference : http://help.sap.com
Trace/log files rotation prevents log files from growing indefinitely by limiting the number and size of files.We can configure the log file rotation specific to one service or for the all services together.