DBRM Reports
This section describes the following reports:
- Summary Level History Report - DBRM View
- Detail Level History Report - DBRM View
- Measurement Comparison Report - DBRM View
- Cost Comparison Report - DBRM View
Summary Level History Report - DBRM View
The Summary History Report - DBRM View displays a list of the measurement sessions that match the filters specified on the Strobe - History - DBRM Change Sort/Filters panel. Each line in this report represents one or more iterations of a specific measurement session. The number of individual measurement sessions associated with each row is shown in the HISTORY RECS column.
The following table describes the fields in the report.
Field | Description |
|---|---|
FILTERED BY | The list of filters used to retrieve this view of the measurement session history. |
DBRM NAME | The name of the database request module or package under which the observed SQL statements were executed. |
HISTORY RECORDS | The number of individual measurement session history records associated with this row. |
The following fields represent values from the last measurement session. | |
MEASUREMENT DATE | The calendar date of the last Strobe measurement included in the set of records. The format of the date depends on the date format specified by the Strobe system programmer in the Strobe parameter dataset. |
MEASUREMENT TIME | The time of day of the last Strobe measurement that matches the specified filter. The format of the time depends on the time format specified by the Strobe system programmer in the Strobe parameter dataset. |
STMT EXEC COUNT | The number of times SQL statements were executed in this DBRM during the measurement session. |
TOTAL CPU % | The total percentage of all CPU time used within the address space by this DBRM. |
AVERAGE CPU SECONDS PER STATEMENT | The average number of CPU seconds per statement used to execute one SQL statement during the measurement session. |
AVERAGE SERVICE UNITS PER STATEMENT | The average number of service units per statement for the measurement session. |
Detail Level History Report - DBRM View
The Detail Level History Report - DBRM View displays the list of measurement sessions that comprise the selected row on the summary report. Each line in this report represents a specific measurement session.
The following table describes the fields in the report.
Field | Description |
|---|---|
FILTERED BY | The list of filters used to retrieve the summary view of the measurement session history. |
DBRM | The name of the database request module under which the observed SQL statements were executed. |
ANNUAL FREQUENCY | The approximate number of times per year the DBRM is executed. This value is used to calculate the annualized cost fields on the cost comparison reports. |
MEASUREMENT DATE | The calendar date of the Strobe measurement. The format of the date depends on the date format specified by the Strobe system programmer in the Strobe parameter dataset. |
MEASUREMENT TIME | The time of day of the Strobe measurement. The format of the time depends on the time format specified by the Strobe system programmer in the Strobe parameter dataset. |
JOBNAME | The name of the job under which the target program or subsystem was executed. |
STEPNAME | The name of the job step, or of the procedure step and job step, in which the program or subsystem was executed. |
PROGRAM | The name of the program or subsystem that was the target of the measurement session. |
STMT EXEC COUNT | The number of times SQL statements were executed in this DBRM during the measurement session. |
TOTAL CPU % | The total percentage of all CPU time used within the address space by this DBRM. |
AVERAGE STMT EXEC TIME | The average amount of elapsed CPU execution time, per SQL statement, that Strobe observed during the measurement session |
AVERAGE CPU SECONDS PER STATEMENT | The average number of CPU seconds used to execute one SQL statement during the measurement session. |
AVERAGE SERV UNITS PER STATEMENT | The average number of service units, per SQL statement, that Strobe observed during the measurement session. |
SYSTEM ID | The MVS system name on which the measurement session was performed. |
CPU MODEL | The model number of the central processing unit (CPU) that executed the target program or subsystem. Sometimes, to understand certain aspects of performance you need to identify the manufacturer’s CPU timing information for the specific CPU identified in the measurement session. |
Detail Level History Report - DBRM View - Right Page
The right-hand page of the report displays some fields from the Detail Level History Report - DBRM View, as well as some additional information about the measurement session history record. This page only appears if you have requested to print the comments for the report. The following table describes these additional fields.
Field | Description |
|---|---|
DBRM CREATE DATE | The date and time that the database request module was created. |
COMMENT | The user-supplied annotation for the measurement session history record. |
HISTORIAN | The creator of the measurement session history record. The value in this field represents one of the following:
|
Measurement Comparison Report - DBRM View
The Measurement Comparison Report - DBRM View shows the differences between the selected baseline measurement session and one or more comparison measurement sessions.
The following table describes the fields in the report.
Field | Description |
|---|---|
FILTERED BY | The list of filters used to retrieve the summary view of the measurement session history. |
DBRM | The name of the database request module under which the observed SQL statements were executed. |
ANNUAL FREQUENCY | The approximate number of times per year the DBRM is executed. This value is used to calculate the annualized cost fields on the cost comparison reports. |
MEASUREMENT DATE | The calendar date of the Strobe measurement. The format of the date depends on the date format specified by the Strobe system programmer in the Strobe parameter dataset. |
MEASUREMENT TIME | The time of day of the Strobe measurement. The format of the time depends on the time format specified by the Strobe system programmer in the Strobe parameter dataset. |
JOBNAME | The name of the job under which the target program or subsystem was executed. |
STEPNAME | The name of the job step, or of the procedure step and job step, in which the program or subsystem was executed. |
PROGRAM | The name of the program or subsystem that was the target of the measurement session. |
STMT EXEC COUNT | The number of times SQL statements were executed in this DBRM during the measurement session. |
TOTAL CPU % | The total percentage of all CPU time used within the address space by this DBRM. |
AVERAGE STMT EXEC TIME | The average number of times an SQL statement was executed during the measurement session. |
AVERAGE CPU SECONDS PER STATEMENT | The average number of CPU seconds used to execute one SQL statement during the measurement session. |
AVERAGE SERV UNITS PER STATEMENT | The average number of service units used to execute one SQL statement during the measurement session. |
SYSTEM ID | The MVS system name on which the measurement session was performed. |
CPU MODEL | The model number of the central processing unit (CPU) that executed the target program or subsystem. Sometimes, to understand certain aspects of performance you need to identify the manufacturer’s CPU timing information for the specific CPU identified in the measurement session. |
BASELINE DBRM | The measurement session history record with which other measurement session history records are compared. |
COMPARE TO BASELINE | The list of measurement session history records being compared with the baseline selection. The values shown in these rows are the measurement differentials (comparison minus baseline), as compared to the baseline measurement. |
Measurement Comparison Report - DBRM View - Right Page
The right-hand page of this report displays some of the fields from the Measurement Comparison Report - DBRM View, as well as additional information about the measurement session history record. This page only appears if you have requested to print the comments for the report. The following table describes these fields.
Field | Description |
|---|---|
DBRM CREATE DATE | The date and time that the database request module was created. |
COMMENT | The user-supplied annotation for the measurement session history record. |
HISTORIAN | The creator of the measurement session history record. The value in this field represents one of the following:
|
BASELINE DBRM | The measurement session history record with which other measurement session history records are compared. |
COMPARE TO BASELINE | The list of measurement session history records being compared with the baseline selection. The values shown in these rows are the measurement differentials (comparison minus baseline), as compared to the baseline measurement. |
Cost Comparison Report - DBRM View
The Cost Comparison Report - DBRM View displays the changes in operating costs between the selected baseline measurement session and one or more comparison measurement sessions.
The following table describes the fields in the report.
Field | Description |
|---|---|
FILTERED BY | The list of filters used to retrieve the summary view of the measurement session history. |
DBRM | The name of the database request module under which the observed SQL statements were executed. |
ANNUAL FREQUENCY | The approximate number of times per year the DBRM is executed. This value is used to calculate the annualized cost fields on the cost comparison reports. |
MEASUREMENT DATE | The calendar date of the Strobe measurement. The format of the date depends on the date format specified by the Strobe system programmer in the Strobe parameter dataset. |
MEASUREMENT TIME | The time of day of the Strobe measurement. The format of the time depends on the time format specified by the Strobe system programmer in the Strobe parameter dataset. |
JOBNAME | The name of the job under which the target program or subsystem was executed. |
STEPNAME | The name of the job step, or of the procedure step and job step, in which the program or subsystem was executed. |
PROGRAM | The name of the program or subsystem that was the target of the measurement session. |
COST CAT | This value indicates whether the program was assigned a prime (PR) or non-prime (NP) rate. The default values for both the prime and non-prime rates are assigned according to the time of day. The time intervals for prime and non-prime are set by the Strobe system programmer during installation. If the default value is not specified, Strobe displays a value of “**”. |
AVERAGE CPU SECONDS PER STATEMENT | The average number of CPU seconds used to execute one SQL statement during the measurement session. |
AVERAGE SERV UNITS PER STATEMENT | The average number of service units used to execute one SQL statement during the measurement session. |
COST PER STMT | The estimated cost to execute one SQL statement. This amount is based on the dollar value per CPU hour or per 1000 service units for the particular system and CPU model on which the measurement session was executed. |
COST PER YEAR | The estimated cost to execute the SQL statement over the course of one year. This amount is based on the specified dollar value per CPU hour or per 1000 service units for the particular system and CPU model on which the measurement session was executed. To calculate this value, you must have entered an amount in the ANNUAL FREQUENCY field on any of the Detail or Comparison panels. |
BASELINE DBRM | The costs associated with the measurement session history record with which other measurement session history records are compared. |
COMPARISON TO BASELINE | The list of measurement session history records being compared with the baseline selection. The values shown in these rows are the measurement differentials (comparison minus baseline), as compared to the baseline measurement. |
Cost Comparison Report - DBRM View - Right Page
The right-hand page of this report displays some fields from the Cost Comparison Report - DBRM View, as well as additional information about the measurement session history record. This page appears only if you have requested to print the comments for the report. The following table describes these additional fields.
Field | Description |
|---|---|
DBRM CREATE DATE | The date and time that the database request module was created. |
COMMENT | The user-supplied annotation for the measurement session history record. |
HISTORIAN | The creator of the measurement session history record. The value in this field represents one of the following:
|
BASELINE DBRM | The measurement session history record with which other measurement session history records are compared. |
COMPARISON TO BASELINE | The list of measurement session history records being compared with the baseline selection. The values shown in these rows are the measurement differentials (comparison minus baseline), as compared to the baseline measurement. |