8 Customizing tasks
barrier. For example, if Application A sets July 7th, 2020 as a barrier, Application B sets August 7th,
2020 as a barrier, and Application C sets September 7th, 2020 as a barrier, partitions will be deleted up
to July 7th, 2020.
As soon as a retention barrier is set, periodic deletion will start to run according to the defined interval,
until any of the following occurs:
l
The Partition Retention option is disabled
l
An API call removes the retention barrier
l
All partitions until the retention barrier have been deleted
For more information on setting and removing a partition retention barrier using the API, refer to the
Enterprise Manager Developer's Guide.
Limitations and considerations
l
If a connection error occurs during the partition deletion operation, the operation will fail (with a
warning). The operation will continue from the point of failure the next time that deletion is performed
(either periodically or manually).
l
If a specific object (partition or storage) cannot be deleted due to other errors (i.e. not connection
errors), a warning will be written to the log and deletion of the remaining objects will continue.
Partitions that cannot be deleted due to such errors must be deleted directly from the database by the
DBA.
l
To prevent deletion of open partitions, the last partition in a table will not be deleted, even if meets
the criteria for deletion.
l
Deletion of partitions in renamed tables is not supported.
l
Reloading a target with the Drop and Create tables option (the default) will delete both the tables and
their partitions, regardless of any partition deletion policy. However, reloading a target with the Do
nothing option, will leave the partitions untouched. In this case, partitions created prior to the target
reload cannot be deleted using the Replicate partition deletion tools.
Selecting Change Table header columns
The Change Table header columns provide information about the Change Processing operation such as the
type of operation (e.g. INSERT), the commit time, and so on. If you do not need this information, you can
configure Replicate to create the Change Tables without some or all of the header columns, thereby reducing
their footprint in the target database. To do this, clear the check boxes next to the header columns that you
wish to exclude.
Note that you cannot remove additional columns or restore columns while a task is running. To change your
initial selection, you first need to stop the task, then modify your selection, and finally reload the target tables.
When Change Data Partitioning is enabled, an extra header column named "
partition_name
" is
added to the Change Tables and automatically selected in the UI. As this column is required, it
cannot be excluded.
For a description of the header columns, refer to the Qlik Replicate User Guide and Reference .
Storing changes in an Audit table
The following section describes the options that are available for storing changes in an Audit table.
Setup and User Guide - Enterprise Manager, May 2023 179