CA Earl and CA Easytrieve Reporting › Report Descriptions › CA7xx011 Database PPD/PPM Record Activity Profile

CA7xx011 Database PPD/PPM Record Activity Profile

The Database PPD/PPM Record Activity Profile report provides a profile of the database activity for prose directory (PPD) and member (PPM) 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 PPD/PPM RECORD ACTIVITY PROFILE                               PAGE       1
TIME: 14.18.01                                                                                                   REQUEST - CA7xx011
-----------------------------------------------------------------------------------------------------------------------------------
                          PPD     PPD       PPD       PPD       PPD  PCT PPD      PPM     PPM     PPM       PPM        PPM  PCT PPM
 TIMES                   ADDS DELETES     READS  REPLACES     TOTAL    READS     ADDS DELETES   READS  REPLACES      TOTAL    READS
-----------------------------------------------------------------------------------------------------------------------------------
yy.032/08:00 - 08:30        0       0         6         0         6    100.0        0       0       5         0          5    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         4         1         5     80.0        0       0       4         0          4    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        21         7        28     75.0        0       0      17         3         20     85.0
yy.032/10:30 - 11:00        0       0         9         1        10     90.0        0       0       6         1          7     85.7
yy.032/11:00 - 11:30        0       0         0         0        0        .0        0       0       0         0          0       .0
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.

PPD ADDS

Identifies the number of prose directory records added to the database.

PPD DELETES

Identifies the number of prose directory records deleted from the database.

PPD READS

Identifies the number of prose directory records read from the database.

PPD REPLACES

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

PPD TOTAL

Identifies the total number of prose directory accesses to the database.

PCT PPD READS

Identifies the percent of total prose directory accesses that were reads.

PPM ADDS

Identifies the number of prose member records added to the database.

PPM DELETES

Identifies the number of prose member records deleted from the database.

PPM READS

Identifies the number of prose member records read from the database.

PPM REPLACES

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

PPM TOTAL

Identifies the total number of prose member accesses to the database.

PCT PPM READS

Identifies the percent of total prose member accesses that were reads.