REPORT (Generate Reports) › Recovery File (RXX) Report › Sample Report: REPORT AREA=RXX › Request Summary Report

Request Summary Report

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.

Date: mm/dd/ccyy    ********************************************************************************         Page:     1
                    *                                 CA Datacom/DB                                *
Time: hh.mm.ss      *                              Multi-User Facility                             *      Release: 12
                    *                   Copyright © 2009 CA. All rights reserved.                  *               SPnn
                    ******************************************************************************** Directory: PRODCXX
           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

Œ

A PERCENT column was added in Version 12.0 for each detail line. The percentage is the percent of the occurrence records for the entire RXX input. Restrictive options like DBID= do not change the percent.



The following pertains to the MOVER command:

MOVERU

MOVERU is specified for MOVER log records that were done for a record moved in support of the UPDAT command for compressed tables.

MOVERO

MOVERO is specified for MOVER log records that were done for a record moved in support of the DBUTLTY OLREORG function.

Ž

In addition to the percentage, another Version 12.0 enhancement is another summary section consisting of 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.