Hello Experts,
Problem:
Recently we have an increase of time in the Lag at Chkpt in a Replicat process, we have tree diffente replicat process but only in this we have an increase of the time:
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT RUNNING REPPRDB 00:00:00 00:00:06
REPLICAT RUNNING REPRHFDB 07:12:45 00:00:10
REPLICAT RUNNING REPRS 00:00:00 00:00:07
Looking the total operations on the REPLICAT REPRHFDB it look like this:
Sending STATS request to REPLICAT REPRHFDB ...
Start of Statistics at 2025-04-03 09:59:41.
DDL replication statistics:
*** Total statistics since replicat started ***
Operations 0.00
Mapped operations 0.00
Unmapped operations 0.00
Other operations 0.00
Excluded operations 0.00
Errors 0.00
Retried errors 0.00
Discarded errors 0.00
Ignored errors 0.00
Cumulative totals for specified table(s):
*** Total statistics since 2025-04-02 17:09:59 ***
Total inserts 1290942.00
Total updates 4037535.00
Total deletes 0.00
Total upserts 0.00
Total discards 0.00
Total ignores 2625.00
Total operations 5328477.00
Total insert collisions 468.00
*** Daily statistics since 2025-04-03 00:00:00 ***
Total inserts 774874.00
Total updates 2442389.00
Total deletes 0.00
Total upserts 0.00
Total discards 0.00
Total ignores 2142.00
Total operations 3217263.00
Total insert collisions 151.00
*** Hourly statistics since 2025-04-03 09:00:00 ***
Total inserts 42605.00
Total updates 220993.00
Total deletes 0.00
Total upserts 0.00
Total discards 0.00
Total ignores 32.00
Total operations 263598.00
Total insert collisions 11.00
*** Latest statistics since 2025-04-02 17:09:59 ***
Total inserts 1290942.00
Total updates 4037535.00
Total deletes 0.00
Total upserts 0.00
Total discards 0.00
Total ignores 2625.00
Total operations 5328477.00
Total insert collisions 468.00
End of Statistics.
========================================================
Comparing with other REPLICAT process
Sending STATS request to REPLICAT REPPRDB ...
Start of Statistics at 2025-04-03 11:11:41.
DDL replication statistics:
*** Total statistics since replicat started ***
Operations 2.00
Mapped operations 2.00
Unmapped operations 0.00
Other operations 0.00
Excluded operations 0.00
Errors 0.00
Retried errors 0.00
Discarded errors 0.00
Ignored errors 0.00
Cumulative totals for specified table(s):
*** Total statistics since 2025-04-02 15:02:35 ***
Total inserts 635273.00
Total updates 1237634.00
Total deletes 535059.00
Total upserts 0.00
Total discards 0.00
Total ignores 380978.00
Total operations 2407966.00
Total insert collisions 24485.00
Total update collisions 268.00
*** Daily statistics since 2025-04-03 00:00:00 ***
Total inserts 324129.00
Total updates 591537.00
Total deletes 282699.00
Total upserts 0.00
Total discards 0.00
Total ignores 357574.00
Total operations 1198365.00
Total insert collisions 12723.00
Total update collisions 104.00
*** Hourly statistics since 2025-04-03 11:00:00 ***
Total inserts 287.00
Total updates 10.00
Total deletes 7729.00
Total upserts 0.00
Total discards 0.00
Total operations 8026.00
*** Latest statistics since 2025-04-02 15:02:35 ***
Total inserts 635273.00
Total updates 1237634.00
Total deletes 535059.00
Total upserts 0.00
Total discards 0.00
Total ignores 380978.00
Total operations 2407966.00
Total insert collisions 24485.00
Total update collisions 268.00
End of Statistics.
===========================================
The total operations of the REPRHFDB is 5328477.00 and comparing with REPPRDB is 2407966.00, the REPRHFDB has most than the double of operations.
My question are …
-
How to find the root cause of the Lag of replicat..
-
How to resolve the Lag of replicat..