This table provides provide a permanent record of all partition-based purges, showing when each purge ran and whether it completed successfully. In effect, it provides an audit trail of CMS purge operations, recording the start and end times of all previous purges, the parameters associated with each purge, plus an indication of whether the most recent purge completed successfully or not.
The parameters associated with each purge are listed in the P1, P2 and P3 columns of the Wgn3PurgeHistory table and correspond to the parameters passed to the wgn_roll_partitions function. They indicate:
The end date of the new partition added. A null entry indicates that no new partition was added.
The end date of the partition that was purged.
The end date for the historic partition, if used. This holds records that must be retained permanently. A null entry indicates that permanent records were retained in their original partition, not in a historic partition.
|
Copyright © 2014 CA.
All rights reserved.
|
|