Salesforce

How to disable a Fathom Replication database Online

« Go Back

Information

 
TitleHow to disable a Fathom Replication database Online
URL NameP107980
Article Number000127856
EnvironmentProduct: Fathom Replication
Version: 3.x
Product: OpenEdge Replication
Version: All supported versions
OS: All supported platforms
Question/Problem Description
How to disable a Fathom Replication database Online
How to disable Fathom Replication for the Source database
How to disable Replication on a Target database
How to disable Replication without having to shut down the source database
How to disable OpenEdge Replication for a Source database online
How to turn off the Replication enabled flag
Steps to Reproduce
Clarifying Information
Error Message
Defect Number
Enhancement Number
Cause
Resolution
Once source database replication is disabled, the only way to replicate the database again is to re-enable Replication on the source database then re-baseline the target.

To Disable Fathom OpenEdge Replication Online: 

Available since Fathom Replication 3.0 and later.

[source]

1. Disable Replication:

The Replication Server first needs to be stopped if running currently
$ dsrutil source_dbname -C terminate server 

Release pending waits once the RPLS has stopped
$ dsrutil source_dbname -C RELWAITS  

Disable Source Replication online
$ dsrutil source_dbname -C disablesitereplication source

2. Maintenance:
  • Stop and archive all DSRUTIL cron jobs / scheduled tasks / utilities that access the source database
  • Delete the *.repl.recovery and archive or rename the *.repl.properties files (for source)
  • Remove the -DBService replserv and -pica database startup parameters
  • Any LOCKED ai files will be marked FULL after disabling source replication
3. If after-imaging also needs to be disabled online:
$   rfutil source_dbname -C aimage aioff

4. Maintenance:
  • Stop and archive all RFUTIL cron jobs / scheduled tasks / utilities that access the source database
  • Remove AIW from starting against source database (proaiw)
  • Remove -aibufs and -aistall source database startup parameters
  • If AI Management was enabled, remove the -aiarcdir, -aiarcinterval, -aiarcdircreate source database startup parameters
  • Consider removing the ai files from source at next shutdown:  $   prostrct remove source_dbname ai
5. It is recommended to backup this database online after disabling after-imaging and or only replication.

[target]

1. If the target database was running when replication was disabled against source, it will be in PRE-Transition state and still running.
$   proshut target_dbname -by

2. Delete the target database (*)
$   prodel target_dbname

3. Maintenance:
  • Stop and archive all cron jobs / scheduled tasks / utilities that access the target database
  • Delete the *.repl.recovery and archive or rename the *.repl.properties files (for target)
(*) If the target database needs to be preserved, disable target replication instead of deleting it:
$   proutil target_dbname -C disablesitereplication target
  • Remove the -DBService replagent and -pica database startup parameters
 
Workaround
Notes
Keyword Phrase
Last Modified Date11/20/2020 7:24 AM

Powered by