This content has been marked as final. Show 3 replies
There are different types of checkpoints that Golden gate maintains for each process. You can see them using INFO <EXTRACT/PUMP/REPLICAT>, SHOWCH.
For example, for an extract, you will see the following read checkpoints:
- startup checkpoint
- recovery checkpoint
- current checkpoint
- BR recovery checkpoints
Similarly there are different read and write checkpoints maintained for Pump and Replicat.
For more details on each of them, you can refer to 'SHOWCH' parameter in GG reference guide.
Thanks for your comment. I understand that there are some kinds of checkpoint for each process. However I don't know exactly which parameter is to control the checkpoint interval of each kind. Could you elaborate more about it, either for extract, pump or replicat process?
CHECKPOINTSECS defines how often an extract makes its regular checkpoints. An extract will make a checkpoint every 10 seconds if this value is set to 10 irrespective of a transaction that is running for 1 hour. Extract also writes commit checkpoints when a transaction is committed.
In the example where your Pump is showing time since checkpoint as greater than 10 could have a problem at the network level or issues with the remote trail..
that is my observation as I had an extract that was being shown as RUNNING but time since last checkpoint was in hours and when i checked the report file, it had an error.