Pages

Thursday, November 19, 2015

GoldenGate Autostart and autorestart defualts

There are three arguments you can define with AUTORESTART

RETRIES
<max retries>
The maximum number of times that Manager should try to restart a
process before aborting retry efforts. The default number of tries is 2.

WAITMINUTES
<wait minutes>
The amount of time, in minutes, to pause between discovering that a
process has terminated abnormally and restarting the process. Use this
option to delay restarting until a necessary resource becomes available or
some other event occurs. The default delay is 2 minutes.

RESETMINUTES
<reset minutes>
The window of time, in minutes, during which retries are counted. The
default is 120 minutes (2 hours). After the time expires, the number of
retries reverts to zero.

In your case you have just defined WAITMINUTES as 1. SO RETRIES is 2 and RESETMINUTES is 120.
So by the time you disabled the trigger your extract had already exhausted its 2 tries within first 2 minutes and was waiting for 120 minutes to try again.

You can check with something like the below and see

AUTORESTART REPLICAT *, RETRIES 3, WAITMINUTES 5, RESETMINUTES 20

No comments:

Post a Comment