Reorg/Unload keeping more records than expected when using archive
Article ID: 270858
Updated On:
Products
Issue/Introduction
When looking at the reorg/unload utilities, they seem to be keeping more records than expected when the archive is used.
For example, the archive is archiving Statistics/Reports (AH/RH) older than 7 Days.
The reorg has both the statistics and reports set to Reorg records older than 4 days and Keep last 4 records per object
When looking at Reports and Statistics in Process Monitoring or Executions after running the reorg an unload, there are 7 days of executions and then 4 record beyond that. Shouldn't there be 4 days and 4 executions kept?
Environment
Release : 21.0.5
Resolution
To reduce complexity, we'll ignore Keep last for now. For information on the impact of keep last, please see the article here: REORG utility does not flag all data when keep last is used
With regards to how many records are kept, the reason that 7 days are kept is that the reorg will keep whichever amount of days is higher, the archive or the reorg. So the following scenarios could happen:
ARCHIVE and REORG set to same number
Archive is set to archive Statistics/Reports (AH/RH) older than 7 Days.
Reorg is set to Reorg statistics older than 7 days
Reorg is set to Reorg reports older than 7 days
Result: When archive, reorg, and unload have finished, 7 days of records will be available still in the AWI.
ARCHIVE has a higher number than REORG
Archive is set to archive Statistics/Reports (AH/RH) older than 7 Days.
Reorg is set to Reorg statistics older than 4 days
Reorg is set to Reorg reports older than 4 days
Result: When archive, reorg, and unload have finished, the reorg will have kept the higher number between archive and reorg, 7 days of records will be available still in the AWI.
ARCHIVE has a lower number than REORG
Archive is set to archive Statistics/Reports (AH/RH) older than 4 Days.
Reorg is set to Reorg statistics older than 7 days
Reorg is set to Reorg reports older than 7 days
Result: When archive, reorg, and unload have finished, the reorg will have kept the higher number between archive and reorg, 7 days of records will be available still in the AWI.
Feedback
