Detail traces
You can create the following reports from detail traces:
Report | Description |
|---|---|
TSTAT=ALL | Summary of all records traced, plus a database summary (if scans were traced), a lock and I/O summary (if locks or I/O were traced), and a sort summary |
STRAC=ALL | Accounting long trace with one report per accounting record, plus an SQL summary, a database summary (if scans were traced), a lock and I/O summary (if locks or I/O were traced), and a sort summary |
STRAC=(SQL,SCAN) | SQL and database trace summary SORTS and IOLOCK summaries and the SQL statement pop-up displays (SQLPOPUP) can also be requested. |
DTRAC=YES | Detail event trace (LEVEL=1 shows all SQL, LEVEL=2 or 3 shows additional events) |
DTRAC=YES,POPUP=ALL | Long detail event trace with event pop-up details. POPUP=(event1, event2, event3) prints pop-up details only for the selected events |
POPUP=(event1, event2, event3) | Selected detail event pop-up displays only |
Related topic