PMIRPT13 contains information related to database and journal buffer use for each reported interval. The report shows one line of information for each buffer accessed.
Sample report
REPORT NO. 13 CA, INC. mm/dd/yy PAGE 2 CA IDMS/PM nn.n volser BUFFER SUMMARY REPORT DC SYSTEM VERSION #: 56 <-------------- YOUR COMPANY NAME --------------> DATA FROM: mm/dd/yy HIT BUFR I/O AVERAGE BUFFER AVERAGE BUFR START BUFFER BUFR BUFR BUFR RATIO DISK WAIT TIME I/O TIME BUFR WAIT TIME WAIT TIME PAGE TIME NAME RQSTS FLSHS HITS (%) I/O (SECS) (SECS) WAITS (SECS) (SECS) SIZE 16:30:00 CA30DB-BUFFER 10 0 0 .0 0 0 CSADDB-BUFFER 10 0 0 .0 0 0 DCDML-BUFFER 5 0 0 .0 978560 7517.000 0 DCLOD-BUFFER 10 0 0 .0 687616 16004.000 0 DCMSG-BUFFER 5 0 0 .0 417280 2857.000 0 DCRUN-BUFFER 10 0 0 .0 961664 98.000 0 DCSEC-BUFFER 5 0 0 .0 95680 3343.000 .0001 0 DEFAULT-BUFFER 10 0 0 .0 720000 65872.000 .0006 0 16:40:00 CA30DB-BUFFER 10 0 0 .0 0 0 CSADDB-BUFFER 10 0 0 .0 0 0 DCDML-BUFFER 5 0 0 .0 0 0 DCLOD-BUFFER 10 0 0 .0 829184 23481.000 0 DCMSG-BUFFER 5 0 0 .0 0 0 DCRUN-BUFFER 10 0 65536 360.0 216704 0 DCSEC-BUFFER 5 0 0 .0 0 0 DEFAULT-BUFFER 10 0 0 .0 0 0 16:50:00 CA30DB-BUFFER 10 0 0 .0 0 0 CSADDB-BUFFER 10 0 0 .0 0 0 DCDML-BUFFER 5 0 0 .0 988224 4567.000 0 DCLOD-BUFFER 10 0 0 .0 703872 12301.000 0 DCMSG-BUFFER 5 0 0 .0 0 20.000 0 DCRUN-BUFFER 10 0 0 .0 0 0 DCSEC-BUFFER 5 0 0 .0 0 26.000 0 DEFAULT-BUFFER 10 0 0 .0 0 0
PMIRPT13 fields
|
Field |
Description |
|---|---|
|
Start Time |
Starting time for the interval on a 24-hour clock (hh:mm:ss). |
|
Buffer Name |
Name of the DC/UCF buffer pool. |
|
Bufr Rqsts |
Total number of database requests made against the buffer. |
|
Bufr Flshs |
Count of times a page had to be written to disk because another transaction required it. |
|
Bufr Hits |
Count of database requests that could be processed in the buffer without a physical I/O. |
|
Hit Ratio |
Ratio of the number of database requests that could be processed in the buffer without a physical I/O (hits) to the total number of buffer requests. For example, a hit ratio of 1.00 indicates that all database pages requested were available in the buffer. A hit ratio of 0.00 indicates that none of the database pages requested was available in the buffer. |
|
Bufr Disk I/O |
Count of requests that could not be processed in the buffer, and therefore required a physical I/O. |
|
I/O Wait Time |
Time spent waiting for I/O to complete requests that could not be processed in the buffer (ss.ttt). |
|
Average I/O Time |
Average amount of time spent waiting for I/O to complete requests that could not be processed in the buffer (ss.tttt). |
|
Buffer Waits |
Count of waits for buffer requests; that is, the number of times the buffer was requested but not available. |
|
Buffer Wait Time |
Total time spent on buffer waits (ss.ttt). |
|
Average Wait Time |
Average amount of time spent on buffer waits (ss.tttt). |
|
Bufr Page Size |
Size of the largest page maintained in the buffer pool, in bytes. |
|
Buf Read |
Number of times a database page was read from disk, not from the buffer. |
|
Buf Write |
Number of times a buffer page was discarded from the journal buffers in order to read another page. |
|
Copyright © 2014 CA.
All rights reserved.
|
|