The Database Type I Record Activity Profile report provides a profile of the database activity for index (I) 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 TYPE I RECORD ACTIVITY PROFILE PAGE 1 TIME: 14.19.36 REQUEST - CA7xx015 ----------------------------------------------------------------------------------------------------------------------------------- I I I I I PCT I TIMES ADDS DELETES READS REPLACES TOTAL READS ----------------------------------------------------------------------------------------------------------------------------------- yy.032/08:00 - 08:30 0 2 273 51 326 83.7 yy.032/08:30 - 09:00 0 0 554 127 681 81.3 yy.032/09:00 - 09:30 0 0 879 263 1,142 76.9 yy.032/09:30 - 10:00 0 0 702 103 805 87.2 yy.032/10:00 - 10:30 0 0 766 145 911 84.0 yy.032/10:30 - 11:00 0 0 1,199 448 1,647 72.7 yy.032/11:00 - 11:30 5 0 692 194 891 77.6 yy.032/11:30 - 12:00 0 0 388 88 476 81.5 END OF REPORT
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.
Identifies the number of index records added to the database.
Identifies the number of index records deleted from the database.
Identifies the number of index records read from the database.
Identifies the number of index records replaced (updated) in the database.
Identifies the total number of index accesses to the database.
Identifies the percent of total index accesses that were reads.
|
Copyright © 2015 CA Technologies.
All rights reserved.
|
|