Set the following trace options in the override parameters of the process definition to trace SQL executed by a COBOL SQL process. To access the Process Definition page, select PeopleTools, Process Scheduler, Processes. On the Override Options tab, select “Override” in the Parameter List drop-down and enter the following in the Parameters field:
| %%PRCSNAME%% %%DBTYPE%%/%%DBNAME%%/%%OPRID%%/%%OPRPSWD%%/%%RUNCNTLID%%/%%INSTANCE%%/255/%%DBFLAG%% |
Save the process definition and run the COBOL SQL process. The trace files can be retrieved in the Process Monitor.