Enabling the Trace Facility

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.

Note: This option is only available when running the diagnostic version of the software.

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.