Data Set History Report
Data source | Performance data collector |
|---|---|
Fields shown in Initial display | (DATE); (MONTH); (DAY); SAMPLES; RESPTMAX; DATEMAX; TIMEMAX; IOSMAX; IOSQMAX; PENDTMAX; DISCTMAX; CONNTMAX; SERVTMAX; RPRCMAX; RHTPMAX; WPRCMAX; WHTPMAX |
Report name verb | PERF_DSN |
Member name | SRMBR023 |
See the Report option keywords and report matrix for performance reports for a list of the report option keywords that are available on this report. PERF_DSN requires keyword DSNINDX.
The following table presents a field list for the Data Set History Report.
Field list for the Data Set History Report
Column heading | Field name | Description |
|---|---|---|
Conn Time Avg | CONNTAVG | The connect time in milliseconds average for the summarized snapshots. |
Conn Time HWM | CONNTHWM | The connect time in milliseconds high-water mark from the summarized samples. |
Conn Time LWM | CONNTLWM | The connect time in milliseconds low-water mark from the summarized samples. |
Conn Time Max | CONNTMAX | The connect time in milliseconds from the snapshot in which the maximum response time was found. |
Conn Time Min | CONNTMIN | The connect time in milliseconds from the snapshot in which the minimum response time was found. |
Date Max | DATEMAX | The date of the snapshot in which the maximum IOs per second was found. |
Date Min | DATEMIN | The date of the snapshot in which the minimum IOs per second was found. |
Day | DAY | Day of the week. |
Disc Time Avg | DISCTAVG | The disconnect time in milliseconds average for the summarized snapshots. |
Disc Time HWM | DISCTHWM | The disconnect time in milliseconds high-water mark from the summarized samples. |
Disc Time LWM | DISCTLWM | The disconnect time in milliseconds low-water mark from the summarized samples. |
Disc Time Max | DISCTMAX | The disconnect time in milliseconds low-water mark from the summarized samples. |
Disc Time Min | DISCTMIN | The disconnect time in milliseconds from the snapshot in which the minimum response time was found. |
I/Os /sec Avg | IOSAVG | The IO operations per second average for the summarized snapshot samples. |
I/Os /sec HWM | IOSHWM | The IO operations per second high-water mark from the summarized snapshot samples. |
I/Os /sec LWM | IOSLWM | The IO operations per second high-water mark from the summarized snapshot samples. |
I/Os /sec Max | IOSMAX | The maximum IO operations per second found in the summarized snapshot samples. All shown maximum values are from the snapshot in which this value is found. |
I/Os /sec Min | IOSMIN | The time of the snapshot in which the minimum IOs per second was found. |
Intv Strt Date | DATE | The summarization interval starting date. |
Intv Strt Time | STIME | The summarization interval starting time. |
IOSQ Time Avg | IOSQTAVG | The IOSQ time in milliseconds average for the summarized snapshots. |
IOSQ Time HWM | IOSQTHWM | The IOSQ time in milliseconds high-water mark from the summarized samples. |
IOSQ Time LWM | IOSQTLWM | The IOSQ time in milliseconds low-water mark from the summarized samples. |
IOSQ Time Max | IOSQTMAX | The IOSQ time in milliseconds from the snapshot in which the maximum response time was found. |
IOSQ Time Min | IOSQTMIN | The IOSQ time in milliseconds from the snapshot in which the minimum response time was found. |
Month | MONTH | The month of the year. |
Pend Time Avg | PENDTAVG | The pending time in milliseconds average for the summarized snapshots. |
Pend Time HWM | PENDTHWM | The pending time in milliseconds high-water mark from the summarized samples. |
Pend Time LWM | PENDTLWM | The pending time in milliseconds low-water mark from the summarized samples. |
Pend Time Max | PENDTMAX | The pending time in milliseconds from the snapshot in which the maximum response time was found. |
Pend Time Min | PENDTMIN | The pending time in milliseconds from the snapshot in which the minimum response time was found. |
Read Hit% Avg | RHTPAVG | The read hit percentage average for the summarized snapshots. |
Read Hit% HWM | RHTPHWM | The read hit percentage high-water mark from the summarized samples. |
Read Hit% LWM | RHTPLWM | The read hit percentage low-water mark from the summarized samples. |
Read Hit% MAX | RHTPMAX | The read hit percentage from the snapshot in which the maximum I/Os per second was found. |
Read Hit% Min | RHTPMIN | The read hit percentage from the snapshot in which the minimum I/Os per second was found. |
Read% Max | RPRCMAX | The read percentage from the snapshot in which the maximum I/Os per second was found. |
Read% Min | RPRCMIN | The read percentage from the snapshot in which the maximum I/Os per second was found. |
Reads% Avg | RPRCAVG | The read percentage average for the summarized snapshots. |
Reads% HWM | RPRCHWM | The read percentage high-water mark from the summarized samples. |
Reads% LWM | RPRCLWM | The read percentage low-water mark from the summarized samples. |
Resp Time Avg | RESPTAVG | The response time in milliseconds average for the summarized snapshots. |
Resp Time HWM | RESPTHWM | The response time in milliseconds high-water mark from the summarized samples. |
Resp Time LWM | RESPTLWM | The response time in milliseconds low-water mark from the summarized samples. |
Resp Time Max | RESPTMAX | The maximum response time in milliseconds found in the summarized snapshot samples. All shown maximum values are from the snapshot in which this value is found. |
Resp Time Min | RESPTMIN | The minimum response time in milliseconds found in the summarized snapshot samples. All shown minimum values are from the snapshot in which this value is found. |
Samples | SAMPLES | Total number of snapshots in the interval. |
Serv Time Avg | SERVTAVG | The service time in milliseconds average for the summarized snapshots. |
Serv Time HWM | SERVTHWM | The connect time in milliseconds high-water mark from the summarized samples. |
Serv Time LWM | SERVTLWM | The service time in milliseconds low-water mark from the summarized samples. |
Serv Time Max | SERVTMAX | The service time in milliseconds from the snapshot in which the maximum response time was found. |
Serv Time Min | SERVTMIN | The service time in milliseconds from the snapshot in which the minimum response time was found. |
Time Max | TIMEMAX | The time of the snapshot in which the maximum IOs per second was found. |
Time Min | TIMEMIN | The time of the snapshot in which the minimum IOs per second was found. |
Write Hit% Avg | WHTPAVG | The write hit percentage average for the summarized snapshots. |
Write Hit% HWM | WHTPHWM | The write hit percentage high-water mark from the summarized samples. |
Write Hit% LWM | WHTPLWM | The write hit percentage low-water mark from the summarized samples. |
Write Hit% Max | WHTPMAX | The write hit percentage from the snapshot in which the maximum I/Os per second was found. |
Write Hit% Min | WHTPMIN | The write hit percentage from the snapshot in which the minimum I/Os per second was found. |
Write% Avg | WPRCAVG | The write percentage average for the summarized snapshots. |
Write% HWM | WPRCHWM | The write percentage high-water mark from the summarized samples. |
Write% LWM | WPRCLWM | The write percentage low-water mark from the summarized samples. |
Write% Max | WPRCMAX | The write percentage from the snapshot in which the maximum I/Os per second was found. |
Write% Min | WPRCMIN | The write percentage from the snapshot in which the minimum I/Os per second was found. |
The following figure provides a sample of the Data Set History Report.
Data Set History Report example
BMC Software, Inc. Generated:03/15/2004(2004.196)@14:44
Intv Strt Samples Resp Time Date Time I/Os /sec IOSQ Time Pend Time Disc Time Conn Time Serv Time Read% Read Hit% Write%
Date Max Max Max Max Max Max Max Max Max Max Max Max
--------------------------------------------------------------------------------------------------------------------------------
07/01/2004 26 31.9 03/02/2004 14:30 0.00 0.0 0.0 26.5 1.5 28.0 100.0 50.0 0.0
07/03/2004 52 74.9 03/06/2004 17:30 0.00 0.0 0.0 72.8 1.5 74.3 100.0 50.0 0.0
07/11/2004 13 19.4 03/15/2004 12:15 0.00 0.0 0.0 17.1 2.1 19.2 100.0 50.0 0.0
************************************************** End of Data Set Summary Report ***********************************************