CA Earl and CA Easytrieve Reporting › Report Descriptions › CA7xx008 Database DSD/DSM Record Activity Profile

CA7xx008 Database DSD/DSM Record Activity Profile

The Database DSD/DSM Record Activity Profile report provides a profile of the activity for data set directory (DSD) and member (DSM) records. Activity is shown in time increments as specified by the SUMM parameter. The log record type from which this report is produced is TYPE=161.

This data is also included as one of the line items comprising total database activity in the CA7xx016 Composite Database Activity Profile.

12/11/yy                                   CA-7 DATABASE DSD/DSM RECORD ACTIVITY PROFILE                               PAGE       1
TIME: 14.16.44                                                                                                   REQUEST - CA7xx008
-----------------------------------------------------------------------------------------------------------------------------------
                          DSD     DSD       DSD       DSD       DSD  PCT DSD      DSM     DSM     DSM       DSM       DSM  PCT DSM
 TIMES                   ADDS DELETES     READS  REPLACES     TOTAL    READS     ADDS DELETES   READS  REPLACES     TOTAL    READS
-----------------------------------------------------------------------------------------------------------------------------------
yy.032/08:00 - 08:30        0       0       320         0       320    100.0        0       0     565        61       626     90.2
yy.032/08:30 - 09:00        0       0       470         0       470    100.0        0       0     630       175       805     78.2
yy.032/09:00 - 09:30        0       0       834         0       834    100.0        0       0   1,475       180     1,655     89.1
yy.032/09:30 - 10:00        0       0       450         0       450    100.0        0       0     743        43       786     94.5
yy.032/10:00 - 10:30        0       0       526         0       526    100.0        0       0   1,074       124     1,198     89.6
yy.032/10:30 - 11:00        0       0       414         0       414    100.0        0       0     515        59       574     89.7
yy.032/11:00 - 11:30        5       0       333         5       343     97.0        5       0   1,315       184     1,504     87.4
yy.032/11:30 - 12:00        0       0       241         0       241    100.0        0       0     272        74       346     78.6

END OF REPORT

This report contains the following fields:

TIMES

Identifies the increment of date and time. Each increment spans the number of minutes specified in the SUMM parameter. The FROM parameter sets the first increment start time. The THRU parameter sets the end time of the last increment.

DSD ADDS

Identifies the number of data set directory records added to the database.

DSD DELETES

Identifies the number of data set directory records deleted from the database.

DSD READS

Identifies the number of data set directory records read from the database.

DSD REPLACES

Identifies the number of data set directory records replaced (updated) in the database.

DSD TOTAL

Identifies the total number of data set directory accesses to the database.

PCT DSD READS

Identifies the percent of total data set directory accesses that were reads.

DSM ADDS

Identifies the number of data set member records added to the database.

DSM DELETES

Identifies the number of data set member records deleted from the database.

DSM READS

Identifies the number of data set member records read from the database.

DSM REPLACES

Identifies the number of data set member records replaced (updated) in the database.

DSM TOTAL

Identifies the total number of data set member accesses to the database.

PCT DSM READS

Identifies the percent of total data set member accesses that were reads.