Previous Topic: PMIRPT09: Shared cache summary reportNext Topic: PMIRPT11: I/O by area summary report


PMIRPT10: DBGroup summary report

PMIRPT10 contains information about the use of the dynamic routing of database sessions. The report shows all the DBGroups to which database sessions have been dynamically routed for processing.

Sample report

REPORT NO. 10 CA, INC. mm/dd/yy PAGE 1 CA IDMS/PM nn.n volser DBGROUP SUMMARY REPORT DC SYSTEM VERSION #: 71 <-------------- YOUR COMPANY NAME --------------> DATA FROM: mm/dd/yy DBGROUP AVG DBGROUP START DBGROUP NUMBER OF DBGROUP WAIT TIME WAIT TIME SERVER NODE # REQUESTS TIME NAME REQUESTS WAITS (SECS) (SECS) NAME PROCESSED 8:00:00 DBDCGR 1 1 .002 .0022 SYSTEM71 1 8:10:00 DBDCGR 1019 820 25.904 .0316 SYSTEM71 472 SYSTEM74 547

PMIRPT10 fields

Field

Description

Start Time

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

DBGroup Name

Name of the DBGroup

Number of Requests

Total number of requests that have been submitted to the DBGroup

DBGroup Waits

Total number of waits for the DBGroup

DBGroup Wait Time

Total amount of time spent waiting for the DBGroup

Avg DBGroup Wait Time

Average wait time for the DBGroup

Server Node Name

Name of the server node

# Requests Processed

Number of requests submitted to the DBGroup that have been processed by the corresponding server number