Subscriber Count

    457

Subscribe2

Pages

Example 14: Auto Starting Extract & Replicat, More Manager Parameters

Manager parameter also can be used to define many other functions to manage.

For example if you want to start the Extract and Replicat Process automatically when a manager process start , keep the following line

AUTOSTART ER *

There are other options also available , retries and wait before retry and reset the minutes along with your restart.

AUTORESTART ER *, RETRIES 3, WAITMINUTES 10, RESETMINUTES 60

There are other certain options which can help you to manage goldengate effectively and important are,

BOOTDELAYMINUTES When ever a database host restarts , the goldengate manager wait until this many minutes to ensure OS completes start up and start GG then, Applicable only for windows.
DOWNREPORTMINUTES Displays the Status of Extract/Replicat process in Error Log, the frequency of showing such status can be regulated with this option. If you have very large error log file it can be difficult to read every and then so you can specify how frequent you want to see such status.
DOWNCRITICAL In the report , it shows the process status abended/normal shutdown
LAGCRITICALSECONDS How many seconds of LAG threshold before it publish to error log.
LAGCRITICAL Specifies a lag threshold that is considered critical and generates a warning to the error log.

Sample parameter file

.ggsci

edit params MGR

AUTOSTART ER *

AUTORESTART ER *, RETRIES 3, WAITMINUTES 10, RESETMINUTES 60

DOWNREPORTMINUTES 15

DOWNCRITICAL

LAGCRITICALSECONDS 10

LAGINFOMINUTES 0

LAGREPORTMINUTES 15