[HANA] HANA DB Trace

Trace Structure

• Trace entries ([_] 공백으로 구분)
  • [<thread_id>]{<connection_id>}[<transaction_id>/<update_transaction_id>]
    <date>
    <time>
    <trace_level>
    <component>
    <source_file>
    :
    <message
  • Example
    • [24294]{-1}[164/215452358] 2016-10-10 12:20:39.296454 i TraceContext TraceContext.cpp(00878) : UserName= ...

 

 

 

Trace Level

• d (debug) = Debugging information, mostly not gets activated per default
• i (info) = Information, such as about database actions like log switches
• w (warning) = Warning about less critical misconfigurations and issues
• e (error) = Potentially critical problems
• f (fatal) = Highly critical problems

 

 

 

Location of Trace

• trace directory
  • /usr/sap/<sid>/HDB<inst>/<host>/trace
• trace 파일의 명명규칙
  
  • <service>_<host>.<port>.<counter>.trc

 

• Monitoring view M_MERGED_TRACES