topic Re: What is Latching in Qlik replicate? in Qlik Replicate

What is Latching in Qlik replicate?

suvbin — Mon, 07 Feb 2022 21:10:29 GMT

what is latching in the Qlik replicate. At the sql server db side, they are facing high OS paging issues. What should be done at this time at the Qlik replicate side.

Re: What is Latching in Qlik replicate?

lyka — Tue, 08 Feb 2022 01:04:44 GMT

Hello,

With regards to the table mentioned by Hein,

In SQL Server, We keep open 2 transaction as part of Replication. Please refer to the source table : attrep_truncation_safeguard

There will be 2 rows per active task: A and B
Replicate opens a RW Transaction and selects one of the row, after 5 minutes (Endpoint config), it starts a TX for the other RX, updates the first row to the current time and commits. Thus there is always an open transaction.

You should not run any maintenance against the attrep_truncation_safeguard table. If you cannot exclude this table from the maintenance plan, then you should stop the Replicate task during the maintenance window.

Hope this helps!

Thanks
Lyka

Re: What is Latching in Qlik replicate?

suvbin — Tue, 08 Feb 2022 20:20:50 GMT

Where can i find this " attrep_truncation_safeguard" ? in the source db?

Re: What is Latching in Qlik replicate?

Heinvandenheuvel — Tue, 08 Feb 2022 20:35:45 GMT

>> Where can i find this " attrep_truncation_safeguard" ? in the source db?

DONT. Not now, not yet.

First Tell us what YOU KNOW. What you see, why you are asked the main questions in the first place.

Right now, for me, your main question is similar to 'my car makes a funny sound, how do I change the trailer?' Followed by 'where is the caliper?'.

Try to restate you question. Help us help you.

Hein.

Re: What is Latching in Qlik replicate?

lyka — Thu, 17 Feb 2022 00:00:11 GMT

Hello.

Its in the source database - if you are referring to the latch in SQL server.

Thanks

Lyka