Wednesday, February 17, 2016

How to enable and disable HANA Client Trace

Use hdbodbc_cons for tracing applications based on ODBC and hdbsqldbc_cons for tracing applications based on SQLDBC.

Use blow syntax

hdbodbc_cons.exe trace <level> <on/off>

Where levels are:
             api: tracing of ODBC api calls
             debug: detailed tracing of whole call stack
             sql: tracing of sql commands as well as output and parameter handling

Before you trun on trace, first configure the trace file name.
C:\Program Files\sap\hdbclient>hdbodbc_cons.exe config trace filename C:\temp\hdbodbc_trace.log

To turn on/off trace use below examples

Tracing of sql commands as well as output and parameter handling
          C:\Program Files\sap\hdbclient>hdbodbc_cons.exe trace sql on
          C:\Program Files\sap\hdbclient>hdbodbc_cons.exe trace sql off

Detailed tracing of whole call stack
          C:\Program Files\sap\hdbclient>hdbodbc_cons.exe trace debug on
          C:\Program Files\sap\hdbclient>hdbodbc_cons.exe trace debug off

Tracing of ODBC api calls
           C:\Program Files\sap\hdbclient>hdbodbc_cons.exe trace api on
           C:\Program Files\sap\hdbclient>hdbodbc_cons.exe trace api off

Reference:-
SAP Note: 1993254 - Collecting ODBC Trace
SAP Note: 1993251 - Collecting SQLDBC Trace

Regards,
Satishbabu Gunukula, Oracle ACE

6 comments:

  1. Thank you for sharing this information with this site. And please keep update like this information.

    digital marketing training Chennai

    ReplyDelete
  2. Yes!i agree this kind of information,this is very helpful for me and easily understand all given information.
    iOS Training in Chennai

    ReplyDelete
  3. Amazing this be helpful very much to disable the trace layout. Thank you very much

    http://www.webdesigningtraining.in/web-designing-training-in-chennai.php

    ReplyDelete
  4. All of these tips are great, that’s very interesting.Thanks, I really appreciate the kind words.
    http://www.oraclesqltraining.in/oracle-sql-training-in-chennai.html

    ReplyDelete
  5. Thank you for share this amazing article with this site. And please keep update like this information related to these topics.

    SQL DBA Training in Chennai

    ReplyDelete