PMIRPT21 contains detailed information about an area's input/output during a specific interval.
Sample report
REPORT NO. 21 CA, INC. mm/dd/yy PAGE 1 CA IDMS/PM nn.n volser I/O BY AREA DETAIL REPORT DC SYSTEM VERSION #: 56 <-------------- YOUR COMPANY NAME --------------> DATA FROM: mm/dd/yy INTERVAL START TIME:16:20:00 END TIME: 16:30:00 AREA NAME: CA30NWK.DDLDML FILE NAME: CA30NWK.CA30DML2 BUFFER NAME: DEFAULT-BUFFER AREA ACCESS WAITS 14736 AREA ACCESSES PHYSICAL WRITES 14628 PHYSICAL READS 108 BUFFER HITS --READ I/O WAITS-- --WRITE I/O WAITS-- 14627 TOT WAITS TOT WAITS 345.000 TOT WAIT TIME .0236 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- --DBKEY WAITS-- TOT WAITS TOT WAITS TOT WAIT TIME AVG WAIT TIME TOT WAIT TIME AVG WAIT TIME HIGHEST WAIT TIME HIGHEST WAIT TIME INTERVAL START TIME:16:20:00 END TIME: 16:30:00 AREA NAME: CFAXNWK.DDLDCLOD FILE NAME: CFAXNWK.CFALOD BUFFER NAME: DCLOD-BUFFER AREA ACCESS WAITS 793 AREA ACCESSES PHYSICAL WRITES 777 PHYSICAL READS 16 BUFFER HITS --READ I/O WAITS-- --WRITE I/O WAITS-- 777 TOT WAITS TOT WAITS 33.000 TOT WAIT TIME .0425 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- --DBKEY WAITS-- TOT WAITS TOT WAITS TOT WAIT TIME AVG WAIT TIME TOT WAIT TIME AVG WAIT TIME HIGHEST WAIT TIME HIGHEST WAIT TIME
PMIRPT21 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) |
|
Area Name |
Name of the area |
|
File Name |
Name of a file to which area maps |
|
Buffer Name |
Name of area's associated buffer |
|
Area Access Waits |
Number of times task waited to ready an area in a required usage mode |
|
Area Accesses |
Number of times task readied an area |
|
Physical Writes |
Number of physical writes for the area |
|
Physical Reads |
Number of physical reads for the area |
|
Buffer Hits |
Number of database area requests that could be processed in the buffer without a physical I/O |
|
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 |
|
DBkey Waits |
Number of waits for a db-key and the total, highest, and average wait times |
|
Copyright © 2014 CA.
All rights reserved.
|
|