Previous Topic: EROPRO and Retroactive Retention ProcessingNext Topic: Expanded Retention Option - ERO


Retention Based on Generations – Standard 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.