CA Earl and CA Easytrieve Reporting › Report Descriptions › CA7xx014 Database SOD/SOM Record Activity Profile

CA7xx014 Database SOD/SOM Record Activity Profile

The Database SOD/SOM Record Activity Profile report provides a profile of the database activity for output workstation network schedule directory (SOD) and member (SOM) 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 SOD/SOM RECORD ACTIVITY PROFILE                               PAGE       1
TIME: 14.19.13                                                                                                   REQUEST - CA7xx014
-----------------------------------------------------------------------------------------------------------------------------------
                          SOD     SOD      SOD      SOD      SOD  PCT SOD      SOM     SOM      SOM      SOM      SOM  PCT SOM
 TIMES                   ADDS DELETES    READS REPLACES    TOTAL    READS     ADDS DELETES    READS REPLACES    TOTAL    READS
-----------------------------------------------------------------------------------------------------------------------------------
yy.032/08:00 - 08:30        0       0        0        0        0       .0        0       0        0        0        0       .0
yy.032/08:30 - 09:00        0       0        0        0        0       .0        0       0        0        0        0       .0
yy.032/09:00 - 09:30        0       0        0        0        0       .0        0       0        0        0        0       .0
yy.032/09:30 - 10:00        0       0        2        0        2    100.0        0       0        1        0        1    100.0
yy.032/10:00 - 10:30        0       0        0        0        0       .0        0       0        0        0        0       .0
yy.032/10:30 - 11:00        0       0        4        1        5     80.0        0       0       12        8       20     60.0
yy.032/11:00 - 11:30        0       0        7        3       10     70.0        0       0        5        2        7     71.4
yy.032/11:30 - 12:00        0       0        0        0        0       .0        0       0        0        0        0       .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.

SOD ADDS

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

SOD DELETES

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

SOD READS

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

SOD REPLACES

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

SOD TOTAL

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

PCT SOD READS

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

SOM ADDS

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

SOM DELETES

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

SOM READS

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

SOM REPLACES

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

SOM TOTAL

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

PCT SOM READS

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