What is Latching in Qlik replicate?

[suvbin]

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.

[lyka · Accepted solution]

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

[suvbin]

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

[Heinvandenheuvel]

>> 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.

[lyka]

Hello.

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

Thanks

Lyka