how to enable DQL or generated SQL tracing in webtop?

Hi,

I'd like to know how to trace the DQL or generated SQL that is executed when i use webtop...

thank you very much,

Michael.

Find more posts tagged with

To get DQL trace, you need to enable dfc tracing in dfc.properties. Your output will go to the location specified in your log4j.properties file.

To filter out the trace set

dfc.tracing.user_name_filter[0]=<user_name>

You can find more details of tracing in content server fundamentals and administration guide.

To enable SQL trace,

You can enable by appending -osqltrace parameter to the server startup or executing the below DQL via DA or whatever

EXECUTE set_options WITH option=

If you have access to Documentum Administrator (DA), there is a checkbox in DQL editor that will show the SQL translation of the DQL statement.

i thinnk tracing on server level is what I need as I want to see what's happening in webtop...

Thanks

Michael.

You can get the underlying DQL generated using dfc tracing. Use the following SN