Working with the extract trace events view
The Extract Trace Events View tab includes an entry for each event that occurred during the File-AID/RDX extraction process, as recorded in the extract trace file. Each event is represented by a row in the view, and each event row is synchronized with the corresponding connecting line that represents it in the Graphical View. The event number is assigned sequentially to provide an easy way to reference the event. Other data available for each event varies by object type.
The Extract Trace Events View tab contains the following columns:
- Event Number
- % of Rows Read
- % of Rows Extracted
- Rows Read
- Rows Extracted
- # of Chase Keys
- Fetches
- Rows in Object (RUNSTATS)
- CPU Time (Seconds)
- Index Access Method
- Index Exact Match
- Index Partial Match
- Data Extracted From
- Requesting Object.
Depending on your selection, the Graphical View's connecting line boxes each display the number of Rows Read, number of Rows Extracted, or # of Chase Keys for the corresponding event in the Extract Trace Events View. For details, see Working-with-the-graphical-view-of-extract-trace-files.
The contents of the Extract Trace Events View tab can be filtered using rules specified on the Extract Hotspot Filter View. For details, see Working-with-the-extract-hotspot-filter-view.
The events in the Extract Trace Events View tab can be sorted by clicking the column headings. Clicking a column heading a second time reverses the sort order. The default sort order is ascending by Event Number.