The HANA database trace is generated and written on the following location on the operating system level.
/usr/sap/<SID>/HDB<XX>/<HOST>/trace/[DB_<DATABASE>]
You can quickly jump to the HANA database trace location using below alias with sidadm user.
cdtrace
The HANA database trace files generally will have the following naming convention and structure.
#Naming Convention
<service>_<host>.<port>.<counter>.trc
#Structure
[<thread_id>]{<connection_id>}[<transaction_id>/<update_transaction_id>] <date> <time> <trace_level> <component> <source_file> : <message>
The HANA database trace files are accessible from the operating system or you can use SAP HANA Studio / DBACOCKPIT as below,
SAP HANA Studio > Administration > Diagnosis Files
DBACOCKPIT > Diagnostics > Diagnosis Files
