CA Earl and CA Easytrieve Reporting › Report Descriptions › CA7xx009 Database JBD/JBM Record Activity Profile

CA7xx009 Database JBD/JBM Record Activity Profile

The Database JBD/JBM Record Activity Profile report provides a profile of the database activity for CPU job directory (JBD) and member (JBM) 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 JBD/JBM RECORD ACTIVITY PROFILE                               PAGE       1
TIME: 09.03.09                                                                                                   REQUEST - CA7xx009
-----------------------------------------------------------------------------------------------------------------------------------
                          JBD     JBD       JBD       JBD       JBD  PCT JBD      JBM     JBM     JBM       JBM       JBM  PCT JBM
 TIMES                   ADDS DELETES     READS  REPLACES     TOTAL    READS     ADDS DELETES   READS  REPLACES     TOTAL    READS
-----------------------------------------------------------------------------------------------------------------------------------
yy.032/08:00 - 08:30        0       0       160        20       180     88.8        0       0   1,520        18     1,538     98.8
yy.032/08:30 - 09:00        0       0       157        22       179     87.7        0       0   2,504        21     2,525     99.1
yy.032/09:00 - 09:30        0       0       255        40       295     86.4        0       0   4,197        40     4,237     99.0
yy.032/09:30 - 10:00        0       0       139        21       160     86.8        0       0   2,042        20     2,062     99.0
yy.032/10:00 - 10:30        0       0       169        25       194     87.1        0       0   2,396        25     2,421     98.9
yy.032/10:30 - 11:00        0       0       186        19       205     90.7        0       0   3,696        22     3,718     99.4
yy.032/11:00 - 11:30        2       0     6,321        36     6,359     99.4        2       0   1,694        29     1,730     97.9
yy.032/11:30 - 12:00        0       0     4,998        18     5,016     99.6        0       0   2,050        17     2,067     99.1

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.

JBD ADDS

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

JBD DELETES

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

JBD READS

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

JBD REPLACES

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

JBD TOTAL

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

PCT JBD READS

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

JBM ADDS

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

JBM DELETES

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

JBM READS

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

JBM REPLACES

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

JBM TOTAL

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

PCT JBM READS

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