Setting Command Line Options
The command line option is available for Microsoft Windows NT and UNIX, but it is not available when calling Application Engine programs from PeopleCode.
To enable tracing from the command line, specify the −TRACE option within the command line that you submit to PSAE.EXE. For example:
n:\pt840\bin\client\winx86\psae.exe -CT MICROSFT -CD PT800GES -CO PTDMO
-password PTDMO -R PT8GES -AI AETESTPROG −I 45 -TRACE 2The following table describes the available TRACE option parameter values:
| Value | Description |
|---|---|
|
0 |
Disables tracing. |
|
1 |
Initiates the Application Engine step trace. |
|
2 |
Initiates the Application Engine SQL trace. |
|
4 |
Initiates the trace for dedicated temporary table allocation to an Application Engine trace (AET) file. You can trace how the system allocates, locks, and releases temporary tables during program runs. |
|
8 |
Initiates the trace for temporary table data. Should be used together with AET file analyzer to display the rows affected by insert/update/delete SQL statements. |
|
128 |
Initiates the statement timings trace to a file, which is similar to the COBOL timings trace to a file. |
|
256 |
Initiates the PeopleCode detail to the file for the timings trace. |
|
1024 |
Initiates the statement timings trace and stores the results in the PS_BAT_TIMINGS_LOG and PS_BAT_TIMINGS_DTL tables. |
|
2048 |
Requests a database optimizer trace file. |
|
4096 |
Requests a database optimizer to be inserted in the Explain Plan table of the current database. |
|
8192 |
Sets a trace for PeopleSoft Integration Broker transform programs. |
|
16384 |
Initiates a SQL timings trace and stores the results in the PS_AE_TIMINGS_LG and PS_AE_TIMINGS_DT tables. |
To specify traces on the command line, you enter the sum of the desired trace options. This action is similar to adding the trace values using PSADMIN, such as the COBOL statement timings or the SQL statement trace value. To specify a combination of traces, enter the sum of the corresponding trace values. For example, to enable the step (1), the SQL (2), and the statement timings (128) traces, you would enter 131, which is the sum of 1 + 2 + 128.
To disable tracing, explicitly specify −TRACE 0. If you do not include the −TRACE flag in the command line, Application Engine uses the value specified in the Process Scheduler configuration file or in Configuration Manager. Otherwise, the command-line parameters override any trace settings that may be set in Configuration Manager.