Previous Topic: PMIRPT05: DBkey/Area detail reportNext Topic: PMIRPT10: DBGroup summary report


PMIRPT09: Shared cache summary report

PMIRPT09 contains information about the use of the Shared Cache in the Coupling Facility. The report shows all the shared cache that were active in the corresponding intervals, and for each shared cache, all the files that were assigned to it. Files that were excluded by input selection parameters do not appear on the report.

Sample report

REPORT NO. 09 CA, INC. mm/dd/yy PAGE 1 CA IDMS/PM nn.n volser SHARED CACHE SUMMARY REPORT DC SYSTEM VERSION #: 71 <-------------- YOUR COMPANY NAME --------------> DATA FROM: mm/dd/yy SH-CACHE AVG SH-CACHE START SHARED CACHE FILE NAME NUMBER OF FOUND IN NUMBER OF SH-CACHE WAIT TIME WAIT TIME TIME NAME READS CACHE WRITES WAITS (SECS) (SECS) 7:54:10 IDMSCACHE00001 DBCR.ACCOUNTA 1 1 DBCR.ACCOUNTB DBCR.ACCOUNTD DBCR.ACCOUNTE IDMSCACHE00002 DBCR.ACCOUNTC DBCR.BRANCHA 1 1 DBCR.BRANCHB DBCR.BRANCHC DBCR.BRANCHD 8:00:00 IDMSCACHE00001 DBCR.ACCOUNTA DBCR.ACCOUNTB 1 1 2 .011 .0055 DBCR.ACCOUNTD DBCR.ACCOUNTE IDMSCACHE00002 DBCR.ACCOUNTC DBCR.BRANCHA 1 1 2 .037 .0184 DBCR.BRANCHB DBCR.BRANCHC DBCR.BRANCHD 8:10:00 IDMSCACHE00001 DBCR.ACCOUNTA 31 17 14 43 .276 .0064 DBCR.ACCOUNTB 39 21 18 56 .476 .0085 DBCR.ACCOUNTD 49 20 29 76 .400 .0053 DBCR.ACCOUNTE 32 12 20 51 .404 .0079 IDMSCACHE00002 DBCR.ACCOUNTC 38 6 32 70 .490 .0070 DBCR.BRANCHA DBCR.BRANCHB DBCR.BRANCHC 1 1 2 .037 .0187 DBCR.BRANCHD 2 2 4 .041 .0102

PMIRPT09 fields

Field

Description

Start Time

Starting time for the interval on a 24-hour clock (hh:mm:ss)

Shared Cache Name

Name of the shared cache

File Name

Name of the file that is assigned to the corresponding shared cache

Number of Reads

Number of read requests from a specific file in the shared cache

Found in Cache

Number of times a database page we want to read was already present and valid in the shared cache

Number of Writes

Number of write requests to a specific file in the shared cache

Sh-Cache Waits

Number of waits for a specific file in the shared cache

Sh-Cache Wait Time

Amount of time spent waiting for a specific file in the shared cache

Avg Sh-Cache Wait Time

Average wait time for a specific file in the shared cache