Previous Topic: PMIRPT04: Summary wait detail reportNext Topic: PMIRPT09: Shared cache summary report


PMIRPT05: DBkey/Area detail report

PMIRPT05 contains detailed area-access information for each reported interval. The report shows one line for each area accessed during each interval that shows information on db-key and area waits.

Sample report

REPORT NO. 05 CA, INC. mm/dd/yy PAGE 1 CA IDMS/PM nn.n volser DBKEY/AREA DETAIL REPORT DC SYSTEM VERSION #: 56 <-------------- YOUR COMPANY NAME --------------> DATA FROM: mm/dd/yy START AREA DBKEY DBKEY AREA BUFFER PAGE SHR PAGE EXCL TIME NAME WAITS WAIT BUFFER WAIT SHR WAIT EXCL WAIT TIME WAITS TIME WAITS TIME WAITS TIME 16:20:00 CA30NWK.DDLDCLOD 0 .0000 0 .0000 0 .0000 0 .0000 CA30NWK.DDLDML 0 .0000 0 .0000 0 .0000 0 .0000 CFAXNWK.DDLDCLOD 0 .0000 0 .0000 0 .0000 0 .0000 CFAXNWK.DDLDML 0 .0000 0 .0000 0 .0000 0 .0000 CG30NWK.DDLDCLOD 0 .0000 0 .0000 0 .0000 0 .0000 CG30NWK.DDLDML 0 .0000 0 .0000 0 .0000 0 .0000 CKSXNWK.DDLDCLOD 0 .0000 0 .0000 0 .0000 0 .0000 CKSXNWK.DDLDML 0 .0000 0 .0000 0 .0000 0 .0000 CSADNWK.DDLDCLOD 0 .0000 0 .0000 0 .0000 0 .0000 CSADNWK.DDLDML 0 .0000 0 .0000 0 .0000 0 .0000 SYSTEM.DDLDCLOD 0 .0000 0 .0000 0 .0000 0 .0000 SYSTEM.DDLDCLOG 0 .0000 0 .0000 0 .0000 0 .0000 SYSTEM.DDLDCRUN 0 .0000 0 .0000 0 .0000 0 .0000 SYSTEM.DDLDCSCR 0 .0000 0 .0000 0 .0000 0 .0000 SYSTEM.DDLDML 0 .0000 0 .0000 0 .0000 0 .0000 16:30:00 CA30NWK.DDLDCLOD 0 .0000 0 .0000 0 .0000 0 .0000 CA30NWK.DDLDML 0 .0000 0 .0000 0 .0000 0 .0000 CFAXNWK.DDLDCLOD 0 .0000 0 .0000 0 .0000 0 .0000 CFAXNWK.DDLDML 0 .0000 0 .0000 0 .0000 0 .0000 CG30NWK.DDLDCLOD 0 .0000 0 .0000 0 .0000 0 .0000 CG30NWK.DDLDML 0 .0000 0 .0000 0 .0000 0 .0000 CKSXNWK.DDLDCLOD 0 .0000 0 .0000 0 .0000 0 .0000 CKSXNWK.DDLDML 0 .0000 0 .0000 0 .0000 0 .0000 CSADNWK.DDLDCLOD 0 .0000 0 .0000 0 .0000 0 .0000 CSADNWK.DDLDML 0 .0000 0 .0000 0 .0000 0 .0000 SYSTEM.DDLDCLOD 0 .0000 0 .0000 0 .0000 0 .0000 SYSTEM.DDLDCLOG 0 .0000 0 .0000 0 .0000 0 .0000 SYSTEM.DDLDCRUN 0 .0000 0 .0000 0 .0000 0 .0000 SYSTEM.DDLDCSCR 0 .0000 0 .0000 0 .0000 0 .0000 SYSTEM.DDLDML 0 .0000 0 .0000 0 .0000 0 .0000

PMIRPT05 fields

Field

Description

Start Time

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

Area Name

Name of the DC/UCF area

DBkey Waits

Count of access requests in the area that required a wait on a db-key

DBkey Wait Time

Total time spent on db-key waits for the area (ss.tttt)

Area Buffer Waits

Number of times that tasks had to wait for a buffer pool page to become available for database page usage

Area Buffer Wait Time

Total time spent waiting for a buffer pool page to become available (ss.tttt)

Page Share Waits

Number of times that tasks had to wait for shared access to a database page that was already in a buffer pool

Page Share Wait Time

Total time spend waiting for shared access to an area's pages (ss.tttt)

Page Excl Waits

Number of times that tasks had to wait for exclusive access to a database page that was already in the buffer pool

Page Excl Wait Time

Total time spent waiting for exclusive access to an area's pages (ss.tttt)