Purge snapshot log
The purge snapshot log process deletes snapshot logs from the SCV snapshot log table.
This process is implemented using the PURGE_SNAPSHOT_LOG program.
The PURGE_SNAPSHOT_LOG program considers these input parameters:
- SNAPSHOTS_TO_KEEP
- The number of snapshot log records to maintain after deleting. Note: By default, the value is set to 3.
- SOURCE
- The source system from which the planning data in the snapshot log is imported.
The PURGE_SNAPSHOT_LOG program purges snapshot logs as follows:
- Logs new log record.
- Identifies the latest <SNAPSHOTS_TO_KEEP> records for each distinct table_name if the Source parameter is specified in the SZ_SNAPSHOT_LOG_TABLE table.
- Includes the snapshot_id of each SZ_SNAPSHOT_LOG_TABLE record available in the PURGE_SNAPSHOT_LOG program in the <snapshot IDs to keep> list.
- Deletes all records from the SZ_SNAPSHOT_LOG_TABLE table where the snapshot_id value is not in the <snapshot IDs to keep> list.
- Deletes all records from the SZ_SNAPSHOT_LOG table where the snapshot_id value is not in the <snapshot IDs to keep> list.
- Commits the changes upon successful deletion.
- Completes the log record with the actual status.
This table lists default values for the input parameters of the PURGE_SNAPSHOT_LOG program:
| Parameter | Default value | Description | Possible values |
|---|---|---|---|
| SNAPSHOTS_TO_KEEP | 3 | Program logic parameter: Number of snapshot records to maintain per table snapshot. | Integer value. |