The REQUEST SUMMARY REPORT in an RXX Analysis Report provides counts of adds, deletes, and updates to every table and base for the transaction, as shown in the following.
REQUEST SUMMARY REPORT COMMAND TABLE DBID AREA OCCURRENCES PERCENT CLOSE 1 0.0 COMIT 48 0.0 ROLBK 6 0.0 ADDIT C01 997 A01 18,000 17.2 DELET C01 997 A01 8,000 7.6 UPDAT C01 997 A01 8,000 10.0 ADDIT C02 997 A01 11,328 10.8 DELET C02 997 A01 11,355 10.9 MOVERU C02 997 A01 1,056 1.0 UPDAT C02 997 A01 11,355 14.2 ADDIT TOTAL 38,034 36.4 DELET TOTAL 28,115 27.0 UPDAT TOTAL 28,056 35.1
The percentage is the percent of the occurrence records for the entire RXX input. Restrictive options like DBID= do not change the percent.
MOVERU is specified for MOVER log records that were done for a record moved in support of the UPDAT command for compressed tables.
MOVERO is specified for MOVER log records that were done for a record moved in support of the DBUTLTY OLREORG function.
The summary section displays one line for all ADDIT commands, one line for all UPDAT commands, and one line for all DELET commands. The information represents the occurrences of those commands for all selected records, and it is the percent of this summation.
A summary line for each of ADDIT, UPDAT, and DELET shows the total records and their percent.
|
Copyright © 2015 CA Technologies.
All rights reserved.
|
|