Kbase P122626: How to enable enhanced logging on replication enabled databases ?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
4/21/2009 |
|
Status: Verified
GOAL:
How to enable enhanced logging on replication enabled databases ?
GOAL:
How to enable enhanced logging on the target database
GOAL:
How to enable enhanced logging on the source database
GOAL:
Diagnosing problems starting replication
GOAL:
Diagnosing replication failure
FACT(s) (Environment):
OpenEdge Replication
Fathom Replication
FIX:
Should the immediate problem not be identifiable by analysing the source, target and system logfiles, enhanced logging can be enabled as follows:
0) If still running:
a) Shut down the target database
$ proshut <target> -by
b) Shut down the source database
$ proshut <source> -by
1) On the source and target machine:
edit DLC/pmmgr.properties and for both replserv and replagent sections add a following line:
arguments=-logging 2
2) restart the databases
Thereafter, the source & target databases logfiles as well as the <source>.repl.server.log and <target>.repl.agent.log will be needed for further analysis.
If enhanced logging is /only/ needed on the target-side, it is not necessary to shut down the source database:
a) Shut down the target database
$ proshut <target> -by
b) Shut down the replication server (the source database will remain running provided there are enough ai extents available)
$ dsrutil <source> -C terminate server
1) On the target machine:
edit DLC/pmmgr.properties and for the replagent section add a following line:
arguments=-logging 2
2) start the target database
3) restart replication server
$ dsrutil <source> -C restart server
Thereafter, a <target>.repl.agent.log will be needed for further analysis.