Maintain Data Table by Application

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. From the Data Integration home page, and then from the Actions menu, then from the Other actions drop-down, select System Maintenance Tasks.

  2. From the System Maintenance Tasks page, click Image shows the Arrow icon. to the right of the Maintain Data Table by Application task.

  3. From the Run Script: Maintain Data Table by Application page, and then from the Target Application drop-down, select the target application to which to purge files.

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

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

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

    To delete all category data, leave blank.

  7. Click OK.