CA Earl and CA Easytrieve Reporting › Report Descriptions › CA7xx012 Database SID/SIM Record Activity Profile

CA7xx012 Database SID/SIM Record Activity Profile

The Database SID/SIM Record Activity Profile report provides a profile of the database activity for input workstation network schedule directory (SID) and member (SIM) 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 SID/SIM RECORD ACTIVITY PROFILE                               PAGE       1
TIME: 14.18.26                                                                                                   REQUEST - CA7xx012
-----------------------------------------------------------------------------------------------------------------------------------
                          SID     SID       SID       SID       SID  PCT SID      SIM     SIM     SIM       SIM        SIM  PCT SIM
 TIMES                   ADDS DELETES     READS  REPLACES     TOTAL    READS     ADDS DELETES   READS  REPLACES      TOTAL    READS
-----------------------------------------------------------------------------------------------------------------------------------
yy.032/08:00 - 08:30        0       0       260         0       260    100.0        0       0     491         0        491    100.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       260         0       260    100.0        0       0     491         0        491    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       260         0       260    100.0        0       0     491         0        491    100.0
yy.032/10:30 - 11:00        0       0         0         0         0       .0        0       0       0         0          0       .0
yy.032/11:00 - 11:30        0       0       260         0       260    100.0        0       0     491         0        491    100.0
yy.032/11:30 - 12:00        0       0         2         2         4     50.0        0       0       1         1          2     50.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.

SID ADDS

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

SID DELETES

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

SID READS

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

SID REPLACES

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

SID TOTAL

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

PCT SID READS

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

SIM ADDS

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

SIM DELETES

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

SIM READS

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

SIM REPLACES

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

SIM TOTAL

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

PCT SIM READS

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