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.