Symantec Data Loss Prevention (DLP) Enforce
If you have database issues and need the SQL queries to send to engineering for diagnosis, you can enable SQL Query (manager_jdbc.log) logging.
To enable SQL Query logging in the Manager (for DLP 15.1 and Above):
Once JDBC logging is enabled, go into the UI and perform any task that you need to capture the SQL queries on i.e., run reports, select incidents etc.
Any SQL statement not executed through OJB will be logged to
Windows Path: \ProgramData\Symantec\DataLossPrevention\EnforceServer\15.x\logs\debug\manager_jdbc_y.log
Linux Path: /var/log/Symantec/DataLossPrevention/EnforceServer/15.x/debug/manager_jdbc_y.log
where x is the DLP version
and y is the log number
along with the time it took to execute the statement.
After performing this test:
Legacy Information:
To enable SQL Query logging in the Manager (for DLP 15.0 and below):
Once JDBC logging is enabled, go into the UI and perform any task that is perceived as slow; i.e., run reports, select incidents -- whatever takes more time than it should.
Any SQL statement not executed through OJB will be logged to \Vontu\Protect\logs\debug\manager_jdbc_0.log along with the time it took to execute the statement.
After performing this test: