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 run the Data Table by Application script:
-
Click Application, then Jobs, and then Schedule Jobs.
-
From the Schedule Jobs page, then What type of job is this?, select Integration Maintenance Script.
-
To schedule an integration maintenance script to run now, see Scheduling Hourly Jobs .
To schedule an integration maintenance script to run later, see Scheduling a Data Rule or Integration Definition to Run Later in the Job Scheduler.
-
Click Next.
-
From Integration Maintenance Script page, click
to the right of the Maintain Data Table by
Application task to schedule.
-
From the Maintain Data Table by Application page, and then from the Target Application drop-down, select the target application to which to purge files.
-
From Start Period, select the starting period from which to delete data.
-
From End Period, select the ending period from which to delete data.
-
From Category, select the category data to delete.
To delete all category data, leave blank.
-
Click OK.