Recommendations for detail traces of long-running threads
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.
This section contains the following topics:
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*