Previous Topic: PMIRPT21: I/O by area detail reportNext Topic: PMIRPT23: Buffer detail report


PMIRPT22: I/O by file detail report

PMIRPT22 contains detailed information about a file's input/output during a specific interval.

Sample report

REPORT NO. 22 CA, INC. mm/dd/yy PAGE 1 CA IDMS/PM nn.n volser I/O BY FILE 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 FILE NAME: CA30NWK.CA30DML1 BUFFER: DEFAULT-BUFFER --READ I/O WAITS-- --WRITE I/O WAITS-- 7355 TOT WAITS TOT WAITS 173.000 TOT WAIT TIME .0235 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 FILE NAME: CA30NWK.CA30DML2 BUFFER: DEFAULT-BUFFER --READ I/O WAITS-- --WRITE I/O WAITS-- 7272 TOT WAITS TOT WAITS 172.000 TOT WAIT TIME .0237 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

PMIRPT22 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)

File Name

Name of the file

Buffer

Name of buffer associated with file

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