CA View uses two types of report retention - standard and ERO.
When a report is originally archived; it is always controlled by standard retention. During a standard backup cycle, the EROPRO parameter controls which reports are eligible to switch from standard to ERO retention.
A database generation is equivalent to all reports that have been archived between STANDARD backup cycles. Even if a report is created multiple times before or during a standard backup cycle, all copies are in the same generation. This means that every time a standard backup cycle is executed, the database generation is incremented. If three standard backup cycles are run each day then a day is equal to three database generations.
If a report's retention is not controlled by the ERO table, then it defaults to retention controlled by the NGEND/NGENT SARINIT parameters.
NGEND indicates how many generations a report should be retained on disk. For example, if NGEND=1 and we are currently archiving generation 10, all NON-ERO reports from generation 10 and prior will be removed from disk during the next STANDARD backup because this is the start of generation 11.
NGENT indicates how many generations the report should be retained in the system, that is, on tape. Since a report will be written to tape during the first backup cycle after it is archived, it is available in two locations, disk and tape so the value includes NGEND, that is, if NGEND=10 and NGENT=30, the report will remain on disk for 10 generations and a total of 30 generations.
The second type of retention, Expanded Retention Option (ERO) is available as an optional feature.
The retention options are defined using the ERO table and the following SARINIT initialization parameters.
EROOPT, EROPRO, PRETAIN, POPT, PCOPIES
Specifies whether the ERO option is being used.
Note: We recommend that EROPRO be set to YES and left that way unless a large percentage of the database is under standard retention.
The PRETAIN parameter controls what happens to a report after its total ERO retention has expired. It controls whether a report should switch back to standard retention or should it be deleted.
Indicates that the report is to be deleted.
Note: We recommend setting PRETAIN=TABLE