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:

  1. Click Application, then Jobs, and then Schedule Jobs.

  2. From the Schedule Jobs page, then What type of job is this?, select Integration Maintenance Script.

  3. 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.

  4. Click Next.

  5. From Integration Maintenance Script page, click Image shows Select icon. to the right of the Maintain Data Table by Application task to schedule.

  6. 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.

  7. From Start Period, select the starting period from which to delete data.

  8. From End Period, select the ending period from which to delete data.

  9. From Category, select the category data to delete.

    To delete all category data, leave blank.

  10. Click OK.