PMIRPT23 contains detailed information about a buffer's input/output during a specific interval.
Sample report
REPORT NO. 23 CA, INC. mm/dd/yy PAGE 7 CA IDMS/PM nn.n volser BUFFER DETAIL REPORT DC SYSTEM VERSION #: 56 <-------------- YOUR COMPANY NAME --------------> DATA FROM: mm/dd/yy INTERVAL START TIME:15:00:00 END TIME: 15:10:00 BUFFER NAME:DCDML-BUFFER BUFFER PAGE SIZE: BUFFER PAGE DEFINED: 76 BUFFER READS 655360 BUFFER WRITES 5 BUFFER PGS IN USE BUFFER FLUSHES 5 BUFFER REQUESTS PAGES FND IN POOL .0 PGS FND RATIO (%) --READ I/O WAITS-- --WRITE I/O WAITS-- 756608 TOT WAITS TOT WAITS 39.000 TOT WAIT TIME AVG WAIT TIME 26693.000 TOT WAIT TIME AVG WAIT TIME HIGHEST WAIT TIME 26.000 HIGHEST WAIT TIME --DB BUFFER WAITS-- --SHARED BUFFER WAITS-- TOT WAITS TOT WAITS TOT WAIT TIME AVG WAIT TIME TOT WAIT TIME AVG WAIT TIME HIGHEST WAIT TIME HIGHEST WAIT TIME --EXCLUSIVE BUFFER WAITS- TOT WAITS TOT WAIT TIME AVG WAIT TIME HIGHEST WAIT TIME INTERVAL START TIME:15:00:00 END TIME: 15:10:00 BUFFER NAME:DCLOD-BUFFER BUFFER PAGE SIZE: BUFFER PAGE DEFINED: 76 BUFFER READS BUFFER WRITES 10 BUFFER PGS IN USE BUFFER FLUSHES 10 BUFFER REQUESTS PAGES FND IN POOL .0 PGS FND RATIO (%) --READ I/O WAITS-- --WRITE I/O WAITS-- TOT WAITS TOT WAITS TOT WAIT TIME AVG WAIT TIME TOT WAIT TIME AVG WAIT TIME HIGHEST WAIT TIME HIGHEST WAIT TIME --DB BUFFER WAITS-- --SHARED BUFFER WAITS-- TOT WAITS TOT WAITS TOT WAIT TIME AVG WAIT TIME TOT WAIT TIME AVG WAIT TIME HIGHEST WAIT TIME HIGHEST WAIT TIME --EXCLUSIVE BUFFER WAITS- TOT WAITS TOT WAIT TIME AVG WAIT TIME HIGHEST WAIT TIME
PMIRPT23 fields
|
Field |
Description |
|---|---|
|
Start Time |
Starting time for the interval on a 24-hour clock (hh:mm:ss) |
|
End Time |
Ending time for the interval on a 24-hour clock (hh:mm:ss) |
|
Buffer Name |
Name of buffer |
|
Buffer Page Size |
Size of buffer pages |
|
Buffer Page Defined |
Number of pages defined for buffer |
|
Buffer Reads |
Number of times DBMS requested a new database page for which a physical I/O occurred |
|
Buffer Writes |
Number of times a buffer page was discarded in order to read another page |
|
Buffer Pgs In Use |
Number of pages currently in use in the buffer |
|
Buffer Flushes |
Number of times a page was discarded from the buffer in order to read another page |
|
Buffer Requests |
Total number of buffer requests (the sum of Pages Fnd in Pool and Buffer Reads) |
|
Pages Fnd In Pool |
Number of database area requests that could be processed in the buffer without a physical I/O |
|
Pages Fnd Ratio (%) |
Percent of Pages Fnd in Pool to Buffer Requests; this ratio should be as close to 100 as possible |
|
Read I/O Waits |
Number of physical read I/Os that resulted in a wait and the total, highest, and average wait times |
|
Write I/O Waits |
Number of physical write I/Os that resulted in a wait and the total, highest, and average wait times |
|
DB Buffer Waits |
Number of times a page within the area had to wait for a buffer page to become available and the total, highest, and average wait times |
|
Shared Buffer Waits |
Number of times transactions wanted to access a database page that was exclusively held by another transaction and the total, highest, and average wait times |
|
Exclusive Buffer Waits |
Number of times transactions waited for exclusive access to a database page and the total, highest, and average wait times |
|
Copyright © 2014 CA.
All rights reserved.
|
|