PeopleSoft Learning

TraceOptions

 

This section enables you to specify the tracing options that you can enable on the application server to track the SQL and PeopleCode of the domains. You can also set all of the trace parameters from the PeopleSoft sign-in page.

 

 

TraceSQL

 

Enter the logging level for SQL tracing for all clients. Traces are written to <PS_HOME>/appserv/<domain>/LOGS/<Domain User ID>_<svrname>.tracesql. Enter 0 to disable tracing; enter 7 to enable a modest tracing level for debugging. For other levels of tracing, set this option to a value that equals the sum of the needed options. For example, to trace only SQL, enter 1; to trace SQL statements and connect statements enter 7 (1+ 2 + 4 = 7). Tracing can consume large amounts of disk space over time, so be sure to reset this option to 0 when you finish troubleshooting.

 

TraceSQLMask

 

Enter the logging level ceiling for SQL tracing for individual clients. Traces are written to <PS_HOME>/appserv/<domain>/LOGS/<Client User ID>_<svrname>.tracesql. Clients must specify the necessary SQL tracing level by using the PeopleSoft Configuration Manager on the Trace tab. To prevent clients from turning on the application server trace and consuming resources, the application server uses TraceSQLMask as an administrative control facility.

If a client transmits a request to trace SQL, the application server compares the value that is transmitted to the TraceSQLMask value. If the client value is less than or equal to the TraceSQLMask value, the application server enables the trace. However, if the client value is greater, the application server enables the trace up to the TraceSQLMask value. Trace files are written on the application server; no trace shows up on the client workstation. Trace values are set in the PSAPPSRV.CFG file. Output files are written to $PS_HOME/appserver/winx86/<domain>/logs.

 

TracePC

 

Enter a level for PeopleCode tracing for activity that is generated by all clients on a domain. Eligible values are defined in the configuration file. TracePC values are displayed in the PeopleSoft Configuration Manager on the Trace tab. You can find the results in <PS_HOME>/appserv/<domain>/LOGS/<domain>.log.

 

TracePCMask

 

Enter which PeopleCode trace options that are requested by client machines will be written to the trace file. You can find the results in <PS_HOME>/appserv/<domain>/LOGS/<ClientMachine>.<domain>.log.