-- Golden Gate -- Coordinated replicat - deadlock issue
Solution :
Configure REPERROR something like this:
REPERROR(60, TRANSABORT, MAXRETRIES 10, DELAYSECS 10)
Basically, retry 10 odd times on hitting a deadlock. This is the current recommendation for deadlocks. We automatically retry 3 times and then abend. We can configure to get past the error if 3 aren’t sufficient.
TRANSABORT should ensure data integrity. It will cause the replicat to aborts the transaction and repositions to the beginning of the transaction. This sequence continues either until the record(s) are processed successfully or MAXRETRIES expires.
If MAXRETRIES is not set, the TRANSABORT action will loop continuously.
Solution :
Configure REPERROR something like this:
REPERROR(60, TRANSABORT, MAXRETRIES 10, DELAYSECS 10)
Basically, retry 10 odd times on hitting a deadlock. This is the current recommendation for deadlocks. We automatically retry 3 times and then abend. We can configure to get past the error if 3 aren’t sufficient.
TRANSABORT should ensure data integrity. It will cause the replicat to aborts the transaction and repositions to the beginning of the transaction. This sequence continues either until the record(s) are processed successfully or MAXRETRIES expires.
If MAXRETRIES is not set, the TRANSABORT action will loop continuously.
No comments:
Post a Comment