How to read a SQL Trace in PeopleSoft

How to read a SQL Trace in PeopleSoft

As always with so many things, I struggled initially to understand the trace file. More often, I would generate a trace file and did not understand every aspect of the trace file. However with experience, I have figured what is written to the trace file and sharing my findings below.

When a trace is run for SQL statements, the resulting trace statement will have various parts. Here is the list along with the description.

First Part: n-xxxxx.

This is a sequential line counter for the process (exe). n is a integer starting from 1 to n. xxxxx is reserved for each line written to the trace file. If there is a second process, then it would be 2-xxxxx, for the third one it would be 3-xxxxx and so on.

Second Part: hh.mi.ss

It indicates the timestamp at which the trace line is written. This timestamp is retrieved from the machine in which PeopleTools is running.

Third Part: A time value

This is the time elapsed since the previous trace line was written. The time elapsed between n-xxxxx and n-(xxxxx+1) is written.

Fourth Part: Cur#n

This indicates the cursor number for the statement

Fifth Part: PSFT_DB

Indicates the PeopleSoft database in which this API call is executing.

Sixth Part: RC=0

This is the return code for the associated API call.

Seventh Part: Dur=Another time value.

This is the time to execute the assoicated API call.

Eight Part: COM Stmt=<SQL Statement>

This is the database API call and provides information on the SQL executed.

如何启用跟踪COBOL程序执行从PeopleSoft在2层和/或3层？

仁科跟踪支持对象仅限于PeopleTools，所以我们不能跟踪COBOL的SQL。这是真的吗？

NO。

这是可能产生COBOL SQL（cobsql.）追踪一起绑定值。，它是未能产生cobsql.trc的文件在两个两层三线模式。

  

要生成的三级COBOL程序cobsql.trc文件（应用服务器）执行以下操作：
1）关闭应用服务器
2）打开psappsrv.cfg的
3）设置的RCCBL重定向至1 
4）取消对行日志目录（在域设置部分）<==这是一个必要的步骤
       （如果是在UNIX上，确保“\”改为“/”）
5）设定的TRACESQL 255。
6）保存psappsrv.cfg 
7）关闭并重新启动应用程序服务器（它会需要一些时间的应用程序。服务器开机，您已经开启跟踪）
8）点击任何remotecall中COBOL，然后检查临时<pshome> / appserv程序/日志文件夹如下：
a）阁下，将有<COBOL PROGRAM> _ <OPRID>。出/ ERR出现在<pshome> / appserv程序/ logs文件夹的文件
                  ），你也将获得小组处理，涉及SQL SQL跟踪
）也将得到cobsql_ <日期时间> TRC（你想看到这是跟踪文件）
[进程调度
日志目录=％PS_SERVDIR％/日志

要产生cobsql.trc的  两 ​​层COBOL程序文件，做到以下几点：

1）打开“配置管理 - 跟踪”选项卡。  

2）检查所有或选定框左侧（除非为Sybase信息）“跟踪”选项卡  

3）检查再直接输出框配置管理器中的进程调度器“选项卡上。  

的cobsql跟踪文件将驻留在％TEMP％\ PS \数据库名在的格式cobsql_program name_datetime.trc中的。