The Composite Database Activity Profile report provides a composite profile of the database activity. The report is a summary of the information provided on reports CA7xx008 through CA7xx015. 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.
Information is provided in groups of 16 detail lines and a total line followed by a DB LOCKOUTS line for each increment of time. The value shown for DB LOCKOUTS indicates the number of times a database access could not be made due to an update being in progress.
12/11/yy CA-7 COMPOSITE DATABASE ACTIVITY PROFILE PAGE 4 TIME: 14.20.00 REQUEST - CA7xx016 ----------------------------------------------------------------------------------------------------------------------------------- TIMES/ PCT TYPES ADDS DELETES READS REPLACES TOTAL READS ----------------------------------------------------------------------------------------------------------------------------------- yy.032/11:00 - 11:30 TYPE - DSD 5 0 333 5 343 97.0 TYPE - DSM 5 0 1,315 184 1,504 87.4 TYPE - JBD 2 0 6,321 36 6,359 99.4 TYPE - JBM 2 0 1,694 29 1,730 97.9 TYPE - NWD 0 0 15 0 15 100.0 TYPE - NWM 0 0 15 0 15 100.0 TYPE - PPD 0 0 0 0 0 .0 TYPE - PPM 0 0 0 0 0 .0 TYPE - SID 0 0 260 0 260 100.0 TYPE - SIM 0 0 491 0 491 100.0 TYPE - SJD 0 0 332 0 332 100.0 TYPE - SJM 0 0 637 0 637 100.0 TYPE - SOD 0 0 0 0 0 .0 TYPE - SOM 0 0 0 0 0 .0 TYPE - I 5 0 692 194 891 77.6 TOTALS 19 0 12,105 448 12,577 96.2 DB LOCKOUTS 0 yy.032/11:30 - 12:00 TYPE - DSD 0 0 241 0 241 100.0 TYPE - DSM 0 0 272 74 346 78.6 TYPE - JBD 0 0 4,998 18 5,016 99.6 TYPE - JBM 0 0 2,050 17 2,067 99.1 TYPE - NWD 0 0 1 0 1 100.0 TYPE - NWM 0 0 0 0 0 .0 TYPE - PPD 0 0 0 0 0 .0 TYPE - PPM 0 0 0 0 0 .0 TYPE - SID 0 0 2 0 2 100.0 TYPE - SIM 0 0 1 0 1 100.0 TYPE - SJD 0 0 1 0 1 100.0 TYPE - SJM 0 0 3 0 3 100.0 TYPE - SOD 0 0 0 0 0 .0 TYPE - SOM 0 0 0 0 0 .0 TYPE - I 0 0 388 88 476 81.5 TOTALS 0 0 7,957 197 8,154 97.5 DB LOCKOUTS 0
This report contains the following fields:
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.
TYPE - xxx appears in this column for record type detail lines to identify the type.
Identifies the number of records added to the database.
Identifies the number of records deleted from the database.
Identifies the number of records read from the database.
Identifies the number of records replaced (updated) in the database.
Identifies the total number of accesses to the database.
Identifies the percent of total accesses that were reads.
|
Copyright © 2015 CA Technologies.
All rights reserved.
|
|