Hello
I have setup a Rdb Hot Standby at a customer's site. It works fine.
In order to monitor that the replication is still active, I looked in
the docs, but failed to find a procedure to do the job.
I ended with the following dirty hack, which may be late to detect the
problem
$ !'f$ver(1)
$ set noon
$ if F$TRNLNM("wait_hot","LNM$SYSTEM",0,"SUPERVISOR",,).eqs.""
$ then
$ define/sys wait_hot "0 00:01:00.00"
$ endif
$ def tcpip$smtp_from "Admin Vms"
$ node == f$getsyi("nodename")
$ boucle:
$ pipe rmu/dump citox$db | sea sys$pipe -
"Database is currently being replicated","Master"/match=and
$ if $severity.eq.1
$ then
$ def/group surv_hot ok
$ else
$ def/sys wait_hot "0 01:00:00.00"
$ endif
$ log = F$TRNLNM("surv_hot","LNM$GROUP",0,"SUPERVISOR",,)
$ if log.eqs.""
$ then
$ ti == f$time()
$ mail nl: dupont@[EMAIL PROTECTED]
-
/subj=" replication base xx stopped on ''node' at ''ti' "
$ endif
$ wait 'F$TRNLNM("wait_hot","LNM$SYSTEM",0,"SUPERVISOR",,)
$ deas/group surv_hot
$ goto boucle
$ exit
I then thought about having all Rdb Hot standby messages go to OPERn,
and use a program like opcom_catcher to intercept that.
I think there must be a much better way ?
Regards
Gérard
|
