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
Thursday, November 19, 2015
Monday, November 16, 2015
GoldenGate ETROLLOVER
EXTRACT DATAPUMP REPLICATE
When Issue ETROLLOVER on EXTRACT write n->n+1 read from n+1, write to n no change
..................................................DATAPUMP write to n+1
When Issue ETROLLOVER on EXTRACT write n->n+1 read from n+1, write to n no change
..................................................DATAPUMP write to n+1
Sunday, November 15, 2015
Velocity Template Format Date and Decimals
#set ( $String = "formatter" )$String.format("%5.2f", $val)
--Turn 123.41234 into 123.41 the same as decimal (5, 2) in T-SQL
$String.format("%.10s", $date)
--Turn datetime into 2015-01-01
For GG using velocity:#set ( $String = "formatter" )
#set ( $Double = 1.0 )$String.format("%15.2f", $Double.parseDouble($col.AfterValue))date: $col.AfterValue.substring(0,10)
time: $col.AfterValue.substring(11,23)
Friday, November 13, 2015
Thursday, November 5, 2015
Wednesday, November 4, 2015
Subscribe to:
Posts (Atom)