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