Skip to main content

Replication history

The attrep_history table provides statistics about each task, such as the number and volume of records processed during a particular timeslot.

A new record is appended to the table at the end of each TIMESLOT_DURATION. In other words, the data in this table is never deleted.

Column descriptions
Column Type Description

SERVER_NAME

nvchar

The name of the machine on which Qlik Replicate is installed.

TASK_NAME

nvchar

The name of the Qlik Replicate task.

TIMESLOT_TYPE

varchar

One of the following:

  • FULL LOAD
  • CHANGE PROCESSING (CDC)

When FULL LOAD and CHANGE PROCESSING are running in parallel (some tables in full load, some in CDC), two history records will occupy the same time slot.

TIMESLOT

timestamp

The end timestamp of the time slot.

TIMESLOT_DURATION

int

The duration of each history record in minutes.

TIMESLOT_LATENCY

int

The latency at the end of the time slot. This is only applicable to CDC time slots. Note that this value contains the value of the target latency only.

TIMESLOT_RECORDS

int

The number of records processed during the time slot.

TIMESLOT_VOLUME

int

The volume of data processed in MB.