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

16 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
  6. Sexy Munrika Call Girls Available For Complete Enjoyment
    We Have a good Range sort of Female Munrika Escorts Who provides a Complete and therefore the Full Package Of Entertainment. All Our Models and every one Exotic Female Munrika Call Girls Escorts Are Based Totally On A-one Class And Quality Escort Service Delivering. So, All Our Past Clients Never See the other Escorts Agency Because we all know Better Our Clients And Their
    Munirka Escorts Agency
    Call Girls in Munirka

    ReplyDelete
  7. Very nicely written blog...Relly loved reading it...Please check my blogs for
    Guwahati Escorts
    Guwahati Escorts
    Guwahati Escorts
    Guwahati Escorts

    ReplyDelete
  8. I really loved your post so much that I cant resist writing comment...Please check mine as well
    Call girl services in Bhubaneswar
    Bhubaneswar escorts

    ReplyDelete
  9. Very Informative and unique content. This the best blog post I've read . Thanks for sharing

    Trading for beginners

    ReplyDelete

  10. Thanks For Sharing such a wonderful article the way you presented is really amazing
    Best Software Training Institutes

    ReplyDelete