You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@trafodion.apache.org by Roberta Marton <ro...@esgyn.com> on 2015/08/21 01:33:18 UTC

Tracing in SQL

I want to add some debug tracing to the Trafodion SQL privilege manager
code.  There are various tracing capabilities in the product today.  I was
wondering if anyone could recommend one of the them or suggest a tracing
solution that would work.  This would be used initially for debugging
grant/revoke issues.



   Thanks,

   Roberta

RE: Tracing in SQL

Posted by Sandhya Sundaresan <sa...@esgyn.com>.
If youre adding it in SQL there are some wrapper methods you can use in
sql/sqlmxevents/logmxevent_traf.cpp.  You could use those or clone something
from the existing to suit you. They save you the trouble of adding to the
conf file etc.

Sandhya

-----Original Message-----
From: Venkat Muthuswamy [mailto:venkat.muthuswamy@esgyn.com]
Sent: Thursday, August 20, 2015 4:50 PM
To: dev@trafodion.incubator.apache.org
Subject: RE: Tracing in SQL

Hi Roberta,

Most of our components now use log4cxx or log4j to log messages. If you look
under ~/sqf/conf folder,  you'll see several log configuration files.
I would recommend that you use this infrastructure as well. In your log
config file you can control what level of tracing you need.

Venkat


-----Original Message-----
From: Roberta Marton [mailto:roberta.marton@esgyn.com]
Sent: Thursday, August 20, 2015 4:33 PM
To: dev@trafodion.incubator.apache.org
Subject: Tracing in SQL

I want to add some debug tracing to the Trafodion SQL privilege manager
code.  There are various tracing capabilities in the product today.  I was
wondering if anyone could recommend one of the them or suggest a tracing
solution that would work.  This would be used initially for debugging
grant/revoke issues.



   Thanks,

   Roberta

RE: Tracing in SQL

Posted by Venkat Muthuswamy <ve...@esgyn.com>.
Hi Roberta,

Most of our components now use log4cxx or log4j to log messages. If you look
under ~/sqf/conf folder,  you'll see several log configuration files.
I would recommend that you use this infrastructure as well. In your log
config file you can control what level of tracing you need.

Venkat


-----Original Message-----
From: Roberta Marton [mailto:roberta.marton@esgyn.com]
Sent: Thursday, August 20, 2015 4:33 PM
To: dev@trafodion.incubator.apache.org
Subject: Tracing in SQL

I want to add some debug tracing to the Trafodion SQL privilege manager
code.  There are various tracing capabilities in the product today.  I was
wondering if anyone could recommend one of the them or suggest a tracing
solution that would work.  This would be used initially for debugging
grant/revoke issues.



   Thanks,

   Roberta