Job Cleanup Overview| Setup Portlet | Teradata Data Mover - 17.10 - Job Cleanup - Teradata Data Mover

Teradata® Data Mover User Guide

Product
Teradata Data Mover
Release Number
17.10
Release Date
June 2021
Content Type
User Guide
Publication ID
B035-4101-061K
Language
English (United States)

Data Mover has an internal repository that stores job data from previously run jobs. The purge service is enabled by default and jobs are purged every 60 days. You can adjust this setting as needed based on your business requirement. You can designate cleanup based on how old the data is, what percentage of the repository is full, or by both age and percent full. A daily cleanup check is performed at the time you specify; and if the age or space threshold is reached, the excess data is deleted from the repository. By default, Data Mover does not purge data that is newer than 5 days.

Purge by Age

When purging based on how old the data is, Data Mover deletes any job history with a run time older than the specified date period. For example, if the Older than setting is set to 30 days, Data Mover deletes the job history for all jobs run more than 30 days ago. If purging job definitions, all job definitions that have not been run in more than 30 days are also deleted.

Purge by Percent

When purging based on the percentage of how full the repository is, the job history is deleted in batches by time frame. Data Mover starts with deleting data older than 180 days. If more space is needed to meet the designated percentage, Data mover then purges data older than 173 days and continues to delete data in 7 day increments until the specified percentage of permanent space has been made available in the repository or until the 5 day limit is met.

Purge by Age and Percent

When purging based on both age and percentage, Data Move first deletes all data based on the specified age range. For example, if the Older than setting is set to 30 days, Data Mover deletes all data older than 30 days first. Data Mover then checks to see if the designated percentage of permanent space is free. If more space is needed, Data Mover continues to delete data from oldest to newest until either the specified percentage of permanent space has been reached or the 5 day limit is met.

If the purge by age setting is greater than 5 days and the percentage of free space is not met, the purge by percent feature may delete data newer than the purge by age setting.