How do I turn on SQL tracing within Optim?

Question

How do I turn on SQL tracing within Optim?

Answer

To enable sql tracing:

On Windows: 

1) Help-> About Optim 
2) Double click on the Optim Logo 
3) Select the checkbox for NEC Dynamic SQL (DSQ) 
4) Select the checkbox for Option 25 (Trace sql statements...) 
5) Click on enable tracing. 
6) Reproduce the problem.

On Unix: 

Add the following to either the pstserv.cfg or the pstlocal.cfg, 
dependant on whether you are using optim server or client (pr0cmnd): 


trace DSQ 25 
trace enable


If using server you will need to restart it to pick up these changes. 

Trace files are named PR0TOOL.00n or PR0CMND.00n if running through the windows client. If running on Unix/Linux the trace files are named PR0SVER.00n and PR0SVCE.00n. Please send the trace files created

http://www-01.ibm.com/support/docview.wss?uid=swg21423841