Maintain Data Table by Application
Purge archives of exported data for audit and drill by deleting the following tables:TDATAMAPSEG, TDATASEG, TPROCESSLOG.
The Data Integration data tables store archives of exported data for audit and drill down purposes. These tables can grow over a period of time but you can purge these tables as needed. The maintenance process deletes the following tables:
-
TDATAMAPSEG
-
TDATASEG
-
TPROCESSLOG
The parameters are:
-
Target Application
-
Category
-
Start Period
-
End Period
To schedule the script to run now, see Scheduling a Job to Run Now.
To schedule the script to run later, see Scheduling a Job to Run Later.
When scheduling the Maintain Data Table by Application script, specify the following:
- Target Application: Select the target application to which to purge files.
- Start Period: Select the starting period from which to delete data.
- End Period: Select the ending period from which to delete data.
- Category: Select the category data to delete. To delete all category data, leave blank.