Trace Section
Use this section to set trace values for performance monitoring and troubleshooting:
| Parameter | Description |
|---|---|
|
TraceFile |
This applies to Windows only and indicates the file to which SQL traces are written when TraceSQL has a value greater than zero. SQL traces for the following programs are written to this file: nVision, and Cube Manager. Other processes—such as Application Engine, SQR, and COBOL—have the SQL traces written to a separate subdirectory under the directory specified for the Log/Output Directory parameter. See the Log/Output Directory parameter. |
|
TraceSQL |
Specify a SQL trace value for troubleshooting. It is implemented as a bit field. Possible values for TraceSQL are listed later in this section. |
|
TracePC |
Specify a trace value for troubleshooting PeopleCode. This is used by PeopleSoft Application Engine when it runs PeopleCode. Possible values for TracePC are listed later in this section. |
|
TraceAE |
Specify the trace options that are specific to PeopleSoft Application Engine. Trace information based on this option is written to a file with the following format: <Application Engine program name>_<Process Instance>.AET Possible values for TraceAE are listed later in this section. |
|
AETFileSize |
This parameter is used to specify the maximum file size (in MB) of the AE trace file. The minimum value is taken to be 20 MB by default and the maximum value limit is set to be 1500 MB. |
|
TraceAECombineOutput |
Set this parameter to Y to merge People Code and SQL trace output into AET file. Default is N. |
|
TraceAEEnableSection |
Set this parameter to Y to enable section level trace. Default is N i.e. section level trace will be disabled and AE traces will be controlled by TraceAE setting only. |
|
TracePPM |
The Performance Monitor agent is a thread that reports performance metrics for each instrumented server if monitoring is enabled for the database. Select 1 to enable and 0 to disable. See Performance Monitor. |
The following table lists the possible values for TraceSQL:
| Bit | Constant | Type of Tracing |
|---|---|---|
|
0 |
%TraceSQL_None |
No output. |
|
1 |
%TraceSQL_Statements |
SQL statements. |
|
2 |
%TraceSQL_Variables |
SQL statement variables. |
|
4 |
%TraceSQL_Connect |
SQL connect, disconnect, commit, and rollback. |
|
8 |
%TraceSQL_Fetch |
Row fetch (indicates that it occurred and the return code, not data). |
|
16 |
%TraceSQL_MostOthers |
All other application-programming interface (API) calls, except Set Select Buffers (ssb). |
|
32 |
%TraceSQL_SSB |
Set Select Buffers (identifies the attributes of columns to be selected). |
|
64 |
%TraceSQL_DBSpecific |
Database API-specific calls. |
|
128 |
%TraceSQL_Cobol |
COBOL statement timings. |
|
1024 |
%TraceSQL_DB2390Server |
Turn on the tracing of diagnostic messages returned by the D22 z/OS %UpdateStats() command. |
The following table lists the possible values for TracePC. Use these by adding the numbers together, or by specifying more than one constant:
| Bit | Constant | Type of Tracing |
|---|---|---|
|
1 |
%TracePC_Functions |
Provide a trace of the program as it is run. This implies options 64, 128, and 256. |
|
2 |
%TracePC_List |
Provide a listing of the entire program. |
|
4 |
%TracePC_Assigns |
Show the results of all assignments made to variables. |
|
8 |
%TracePC_Fetches |
Show the values fetched for all variables. |
|
16 |
%TracePC_Stack |
Show the contents of the internal machine stack. This option is normally used for debugging the PeopleCode language, not PeopleCode programs. |
|
64 |
%TracePC_Starts |
Provide a trace showing when each program starts. |
|
128 |
%TracePC_ExtFuncs |
Provide a trace showing the calls made to each external PeopleCode routine. |
|
256 |
%TracePC_IntFuncs |
Provide a trace showing the calls made to each internal PeopleCode routine. |
|
512 |
%TracePC_ParamsIn |
Show the values of the parameters to a function. |
|
1024 |
%TracePC_ParamsOut |
Show the values of the parameters as they exist at the return from a function. |
The following table lists the possible values for TraceAE:
| Bit | Type of Tracing |
|---|---|
|
1 |
Trace STEP execution sequence to AET file. |
|
2 |
Trace Application SQL statements to AET file. |
|
4 |
Trace dedicated temporary table allocation. |
|
8 |
Trace temporary table data. |
|
128 |
Timings report to AET file. |
|
256 |
Method/BuiltIn detail, instead of summary in AET Timings report. |
|
1024 |
Timings report to tables. |
|
2048 |
DB optimizer trace to file. |
|
4096 |
DB optimizer trace to tables. |
|
8192 |
Trace Integration Broker transform programs. |