Setting Up Tracing

To enable tracing for PeopleSoft Data Mover, you must set the PS_SERVER_CFG environment variable to point to the Data Mover configuration file, which contains parameters for tracing and character set:

  • In Windows, you can set PS_SERVER_CFG in the System control panel, or issue the following command in a batch file or at a command prompt:

    set PS_SERVER_CFG=%PS_HOME%\setup\psdmtx.cfg

  • In UNIX, edit psconfig.sh to include the following statement:

    PS_SERVER_CFG=$PS_HOME/setup/psdmtx.cfg;export PS_SERVER_CFG

To configure tracing for PeopleSoft Data Mover, you must edit the psdmtx.cfg file to specify the appropriate tracing behavior. Use the TraceSql bitfield parameter to set the level of the SQL trace by adding together the numeric values that represent each degree of tracing required. The values are defined as follows:

Bit Value Type of Tracing

1

SQL statements.

2

SQL statement variables.

4

SQL connect, disconnect, commit and rollback.

8

Row Fetch (indicates that it occurred, not data).

16

All other API calls except ssb.

32

Set Select Buffers (identifies the attributes of columns to be selected).

64

Database API specific calls.

128

COBOL statement timings.

4096

Manager information.

8192

Mapcore information.

After running PeopleSoft Data Mover, look for the generated trace log file in PS_CFG_HOME\log\APPSRV.LOG.

For UNIX, the TraceFile environment variable enables you to configure the trace file path and name. The system only uses the TraceFile value when TraceSql is set to a value greater than 0. The default value of TraceFile is DM_HOME/datamover.trc. For example,

TraceFile=%DM_HOME%/datamover.trc