Recommendations for detail traces of long-running threads

A detail trace can start at any time during the life of thread, and event collection starts immediately.

A trace entry in LTRAC is normally posted when the thread is complete and the accounting record is available. You will never see an entry for an active thread on the CT view. Also, even when a long-running thread is completed, all captured events might only be visible on the HT view, because online event buffers are reused as needed.

You may be able to see trace activity for active threads in two places:

• From the DUSER display (detail user status display of an active thread) you can view the recent collected chronological events (from two online buffers) with the UTRAC display, which is similar to DTRAC. The UTRAC Expand button on DUSER will be highlighted when events are available for viewing from an active detail trace.
• With trace logging, a trace entry in LTRAC becomes available in History Traces as detail event buffers fill up and are written to a log, even during the life of the thread. Such an entry is identified with a status of INCMP. The STRAC display for an active thread has no accounting data, only the thread identifiers and the detail event summaries - for example, of the SQL statements executed. The chronological events can be viewed in DTRAC. These active threads (INCMP) can only be viewed from the trace logs, and only after at least one buffer of events has been written. You must access it from the HT view.