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

18 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. Nice Article, Keep sharing such posts. Also, Read Jammu Kashmir Honeymoon Packages for more related content.

    ReplyDelete
  8. Kang Yatse trek expeditionin Zanskar valley with a summit at 6250 m/20500 ft. Check here for route details, fitness required, expedition dates and more.

    ReplyDelete
  9. Nice Post, Nice Article, Keep sharing such posts. Also, Book Kolkata to Delhi Flight Ticket at reasonable price.

    ReplyDelete
  10. Get admission in the top-notch colleges of Canada. Check what are the bestUndergraduate Courses in Canada that one can take into consideration while making its future career decision.

    ReplyDelete
  11. Shri Hemkund Sahib Ji tour is a beautiful holy shrine of Sikh community that is located in Rishikesh, Uttarakhand.

    ReplyDelete
  12. Thank you so much for posting this the style tune blog and provide more important content. it's a wonderful blog.
    Self Employed Pay Stub

    ReplyDelete
  13. You have made such a nice blog https://starindiatours.com/

    ReplyDelete