CA Earl and CA Easytrieve Reporting › Report Descriptions › CA7xx013 Database SJD/SJM Record Activity Profile

CA7xx013 Database SJD/SJM Record Activity Profile

The Database SJD/SJM Record Activity Profile report provides a profile of the database activity for CPU job schedule directory (SJD) and member (SJM) 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 SJD/SJM RECORD ACTIVITY PROFILE                               PAGE       1
TIME: 14.18.51                                                                                                   REQUEST - CA7xx013
-----------------------------------------------------------------------------------------------------------------------------------
                          SJD     SJD       SJD       SJD       SJD  PCT SJD      SJM     SJM     SJM       SJM        SJM  PCT SJM
 TIMES                   ADDS DELETES     READS  REPLACES     TOTAL    READS     ADDS DELETES   READS  REPLACES      TOTAL    READS
-----------------------------------------------------------------------------------------------------------------------------------
yy.032/08:00 - 08:30        0       0       332         0       332    100.0        0       0     638         0        638    100.0
yy.032/08:30 - 09:00        0       0         1         0         1    100.0        0       0       2         0          2    100.0
yy.032/09:00 - 09:30        0       0       332         0       332    100.0        0       0     638         0        638    100.0
yy.032/09:30 - 10:00        0       0         0         0         0       .0        0       0       0         0          0       .0
yy.032/10:00 - 10:30        0       0       331         0       331    100.0        0       0     636         0        636    100.0
yy.032/10:30 - 11:00        0       0         1         1         2     50.0        0       0       8         4         12     66.6
yy.032/11:00 - 11:30        0       0       332         0       332    100.0        0       0     637         0        637    100.0
yy.032/11:30 - 12:00        0       0         1         0         1    100.0        0       0       3         1          4     75.0

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.

SJD ADDS

Identifies the number of job schedule directory records added to the database.

SJD DELETES

Identifies the number of job schedule directory records deleted from the database.

SJD READS

Identifies the number of job schedule directory records read from the database.

SJD REPLACES

Identifies the number of job schedule directory records replaced (updated) in the database.

SJD TOTAL

Identifies the total number of job schedule directory accesses to the database.

PCT SJD READS

Identifies the percent of total job schedule directory accesses that were reads.

SJM ADDS

Identifies the number of job schedule member records added to the database.

SJM DELETES

Identifies the number of job schedule member records deleted from the database.

SJM READS

Identifies the number of job schedule member records read from the database.

SJM REPLACES

Identifies the number of job schedule member records replaced (updated) in the database.

SJM TOTAL

Identifies the total number of job schedule member accesses to the database.

PCT SJM READS

Identifies the percent of total job schedule member accesses that were reads.