How to Trace AE and COBOL Processes

For AE, Open the Process Definition under PeopleTools, Process Scheduler. Go to the override tab, and on the Parameter list line select Append from the dropdown, and in the edit box next to it, you can use the desired combination of traces, they all are; 

Parameter List Append -TRACE 7 -TOOLSTRACEPC 3596 -TOOLSTRACESQL 31 

Save the Defnition and hence forth this program will be traced each time it is run, until this is removed. Using Both the -TOOLSTRACEPC & -TOOLSTRACESQL together should only be done when required, as the output from both go into the same file, making it very large and difficult to read. For normal program tracing using just the; 

-TRACE 7 -TOOLSTRACEPC 3596 

Give the Application Engine Trace, which traces the SQL in an AE program, and the PeopleSoft Trace, which is the pcode trace. 

The above settings have equivelent settings in psprcs.cfg, they are; 

TraceAE= -TRACE output goes into Application Engine Trace (.AET) 
TracePC= -TOOLSTRACEPC output goes into the PeopleTools trace file (.trc) 
TraceSQL= -TOOLSTRACESQL output ALSO goes into the PeopleTools trace file (.trc) 

Again, depending on what the program is doing, most commnoly we'd use the -TRACE & -TOOLSTRACEPC together. The only time I use the -TOOLSTRACESQL is when we're looking for a problem with the psae program itself.