Table Buffer Trace Analysis
With the table buffer trace, you can monitor accesses made to the table buffer and how it is loaded or invalidated. You can display and further analyze the trace records logged in the trace file.
By default, the table buffer trace records are displayed summarized - that is, a sequence of fetch statements on the same table is grouped into one line. If you choose Trace List -> Expand Table Buffer Trace, each fetch is displayed in a separate line.
Features
While the buffer trace is switched on, the system records all buffer accesses of a user or user group.
The table buffer trace tells you:
- Which buffer accesses your statement executes
- Which buffer operations are used
- How the buffer is managed
Additional information is available under:
Detailed Display of Table Buffer Trace Records