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

Posted by at
Labels: , , , ,

19 comments:

  1. raphaelFebruary 25, 2016 at 12:42 AM

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

    digital marketing training Chennai

    ReplyDelete
  2. kathickanitha55February 25, 2016 at 9:36 PM

    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. henrisFebruary 29, 2016 at 3:51 AM

    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. kanmani karthickMarch 1, 2016 at 1:38 AM

    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. henrisMarch 2, 2016 at 1:06 AM

    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. henrisMarch 2, 2016 at 5:41 AM

    Thank you for posting. Its interesting.

    SQL DBA Training in Chennai

    ReplyDelete
  7. Pablo M.June 7, 2018 at 5:52 AM

    This post is exciting. Sara

    ReplyDelete
  8. jojoOctober 13, 2018 at 11:23 AM


    افضل شركة تنظيف خزانات بالرياض
    شركة نقل عفش بالمدينة المنورة


    شركة نقل عفش بينبع

    ارخص شركة نقل عفش بالمدينة المنورة

    ___


    شركة شفط بيارات بالاحساء شركة شفط بيارات بالاحساء
    شركة تنظيف فلل بالدمام شركة تنظيف فلل بالدمام
    شركة مكافحة النمل الابيض بالدمام شركة مكافحة النمل الابيض بالدمام
    شركة تنظيف بيارات بالدمام شركة تنظيف بيارات بالدمام
    شركة تنظيف كنب بالدمام شركة تنظيف كنب بالدمام
    شركة تنظيف موكيت بالدمام شركة تنظيف موكيت بالدمام

    ReplyDelete
  9. Sonam SharmaJanuary 9, 2021 at 3:18 AM

    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
  10. AnonymousJuly 20, 2021 at 1:54 AM

    I loved reading this post. Thanks for sharing.

    Best Web designing company in Hyderabad

    Best Web development company in Hyderabad

    Best App development company in Hyderabad

    Best Digital Marketing company in Hyderabad

    ReplyDelete
  11. AnonymousAugust 29, 2021 at 9:42 PM

    Very Informative..
    online bus ticket booking

    ReplyDelete
  12. Emily AnistonFebruary 16, 2022 at 4:22 AM

    Nice Article, Keep sharing such posts. Also, Read Jammu Kashmir Honeymoon Packages for more related content.

    ReplyDelete
  13. ShikharTravelJune 13, 2022 at 11:34 PM

    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
  14. SuperbMyTripMarch 14, 2023 at 11:06 PM

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

    ReplyDelete
  15. Education AbroadMarch 15, 2023 at 12:16 AM

    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
  16. Jatin SlathiaMarch 24, 2023 at 11:38 PM

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

    ReplyDelete
  17. Pay StubsAugust 24, 2023 at 5:10 AM

    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
  18. Vikram SinghMarch 27, 2024 at 3:30 AM

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

    ReplyDelete
  19. ShikharTravelAugust 16, 2024 at 6:35 AM

    This blog post provides a clear and concise guide for enabling and disabling HANA Client Trace, making complex troubleshooting straightforward and accessible.

    Mt Nun Peak Expedition

    ReplyDelete

Subscribe to: Post Comments (Atom)