Database Guide › Database Storage and Partitioning › Set Up Partitions and Purging › Set Up Partition-Based Purging › Restart a Failed Purge

Previous Topic: Purge a Specific Partition

Next Topic: Additional Procedures and Functions
Restart a Failed Purge

CA DLP does not permit a purge to be left incomplete and in a failed state. If a purge fails to complete, after fixing the problem you can use the wgn_restart_purge procedure to restart the purge. Note also that restarted purges do not repeat or omit any purge steps.

begin 
wgn_partition_util.wgn_restart_purge; 
end;

Because you cannot start a new purge while the latest purge is in a failed state, the Restart procedure does not need to take any parameters; by definition, any failed purge that needs to be restarted must be the most recent purge.

More information:

Diagnostic Support