topic Re: Is it proper to decrease attrep_status table update frequency? in Qlik Replicate

Is it proper to decrease attrep_status table update frequency?

MoeE — Mon, 05 Jun 2023 02:32:23 GMT

Hi Support,

I have come across this article https://community.qlik.com/t5/Official-Support-Articles/Qlik-Replicate-Process-to-change-the-frequency-of-updates-made/ta-p/1943586

which shows that the update frequency can be increased. However I want to know:

Will decreasing it cause any problems?

What is the smallest feasible value I can decrease it to?

Thank you.

Kind Regards,

Mohammed

Re: Is it proper to decrease attrep_status table update frequency?

SachinB — Mon, 05 Jun 2023 04:18:06 GMT

Hello @MoeE ,

The attrep_status table contains the current status of each replication task and the target data. Specifically, the source current position and source tails. This table will be updated only after the batch (or transactional apply micro-batch) is applied to the target. Although updates for the tasks in the attrep_status table are generated every few seconds, Replicate will only apply the updates after it has applied changes to the target tables.

The default value is maintained as one minute (60 Seconds), You try to set this value below by using the below link

https://community.qlik.com/t5/Official-Support-Articles/Qlik-Replicate-Process-to-change-the-frequen...

However, This will not have any impact on the task, Ideally one minute is good for an attrep_status update.

Let us know in case if you need additional information on same.

Regards,

Sachin B

Re: Is it proper to decrease attrep_status table update frequency?

MoeE — Mon, 05 Jun 2023 05:49:03 GMT

Hi Sachin,

Thanks for the answer. I have another question.

Would latency delay the update of this table? say latency is over 3 minutes, that means update will also take a bit over 3 minutes?

Kind Regards,

Mohammed

Re: Is it proper to decrease attrep_status table update frequency?

SachinB — Mon, 05 Jun 2023 07:26:21 GMT

Hello @MoeE ,

Thanks for the update, As I said earlier "This table will be updated only after the batch (or transactional apply micro-batch) is applied to the target" Yes latency of the task have an impact as you explained above.

Regards,

Sachin B

Regards,

Sachin B