[source: hmmm… my apologies to the original writer, I really can’t recall where I took this note from… apologies again.]
PeopleSoft trace supports only objects only within PeopleTools, so we cannot trace COBOL SQLs. Is this true?
It is possible to generate COBOL SQL(cobsql.) Trace along with bind values. And it is possible to generate cobsql.trc files in both TWO TIER and THREE tier modes.
To generate cobsql.trc file for COBOL programs in THREE TIER(Application Server) do the following:
1) Shutdown the application server
2) Open the psappsrv.cfg
3) Set the RCCBL Redirect to 1
4) Uncomment the line Log Directory (in the domain settings section) <== This is a necessary step (If it is on unix, make sure the "\" is changed to "/")
5) Set the TraceSQL to 255.
6) Save psappsrv.cfg
7) Shut down and reboot the application server (it will take some time for the app. server to boot, as you have turned on tracing)
8) Click on any remotecall cobol and then check both the temp and <pshome>/appserv/logs folders for the following:
a) you will have <COBOL PROGRAM>_<OPRID>.out /.err files appearing in the <pshome>/appserv/logs folder.
b) you will also get sql trace of the panels involving sql
c) you will also get cobsql_<datetime>.trc (THIS IS THE TRACE FILE YOU WANT TO SEE)
To generate cobsql.trc file for COBOL programs in TWO TIER do the following:
1) Open configuration manager -- Trace Tab.
2) Check all or selected boxes on the left-hand side (except for the Sybase Information) on the Trace Tab
3) Check the Re-direct output box on the Process Scheduler tab of Configuration Manager also.
The cobsql trace file will reside under %TEMP%\PS\DBName in the format cobsql_program-name_datetime.trc.