TPDC Manual (G06.24+)

Using the SPAM Performance Data Charts and
Reports
Tandem Performance Data Collector (TPDC) Manual—526357-001
5-66
Low Selectivity (Needle in a Haystack) SQL Table
Access Report (HAYSTCK)
Low Selectivity (Needle in a Haystack) SQL Table Access Report
(HAYSTCK)
This 132-column report shows specific opens of SQL tables that exhibit low
selectivity—where the ratio of records used to records accessed is relatively small.
This report includes:
•
The physical file name of the table
•
The volume and subvolume name of the table
•
The time the table was opened or the start of the measurement window, whichever
is later
•
The time the table was closed or the end of the measurement window, whichever
is earlier
•
The selectivity of the table accesses made via this open—the number of records
used divided by the number of records accessed, expressed as a percentage
•
The number of records accessed per second, averaged over the measurement
window
•
The number of physical disk reads per second, averaged over the measurement
window
•
The number of records accessed per second, averaged over the life of the
particular open
•
The number of physical disk reads per second, averaged over the life of the
particular open
•
The name of the process that opened the table
•
The CPU and process identifier of the opening process
•
The execution priority of the opening process
•
The program file name of the opening process
•
The average elapsed seconds per logical table I/O. This measurement includes
time spent accessing elapsed records
This report uses the GLOBINFO, FILE, and PROCESS entities
Parameters used are:
•
LID—specifies the Measure Load ID
•
SECTION—specifies the report section number
This report is sorted by file name and then by the time the file is opened.