Tracing can be enabled collectively with a single trace file for all workers. Tracing to a single collective trace file is referred to as global tracing. While global trace is enabled, tracing is automatically initiated for any new workers that start up.
A trace file can be segmented into two or more physical files by a release function. Releasing a trace file closes the current file and opens a new file for the same task. Releasing a trace file allows significant events to be confined to a smaller trace file. The location of a trace file is assigned when the Query Processor server is installed.
All information in diagnostic trace files is prefixed with the mix number and timestamp to the nearest second.
Global trace files are created as public files.
Use the following system commands to enable the trace facility for all the workers:
── NA MCPSQL TRACE ─┬──────────────────┬────────────────────────────────┤
├─ ON ─┬─────────┬─┤
│ └─ DEBUG ─┤ │
├─ + ────────────┘ │
├─ OFF ─┬──────────┤
├─ ─ ───┘ │
└─ RELEASE ────────┘The following table explains the elements of the syntax diagrams.
|
Element |
Definition |
||
|---|---|---|---|
|
TRACE |
Shows the status of the trace as well as the name and location of the current trace file. |
||
|
TRACE ON |
Produces a trace in a single global trace file. You can also use the + (plus) option in place of the ON option. |
||
|
TRACE ON DEBUG |
Produces trace information designed to assist Unisys personnel in diagnosing problems.
|
||
|
TRACE OFF |
Causes the Query Processor server to discontinue tracing and close the global trace file. You can also use the — (minus) option in place of the OFF option. |
||
|
TRACE RELEASE |
Closes the current global trace file and opens a new file. |

