Kbase P135112: Do replication source and target databases need to be shutdown to change the Schema-Lock-Wait parame
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/4/2009 |
|
Status: Verified
GOAL:
Do replication source and target databases need to be shutdown to change the Schema-Lock-Wait parameter from wait to force?
GOAL:
How to change the Schema-Lock-Wait parameter value?
GOAL:
How to change Schema-Lock-Wait=force to wait
GOAL:
How to change Schema-Lock-Wait=wait to force
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge Replication
Fathom Replication
OpenEdge 10.1x
OpenEdge 10.2x
FIX:
The source database does not need to be shutdown, however the replication server process does. Shutting down the replication server process will also automatically terminate any replication agents connected to it. This therefore means that you will need to stop and restart the replication target database before you can make any schema changes because the replication server and agent processes need to be running and synchronized.
1. Shutdown the replication server process on the source: dsrutil <dbname> -C terminate server
2. Update the <dbname>.repl.properties file for the source database and add the following line to the [server] section:
Schema-Lock-Wait=force
3. Shutdown and restart the target database.
4. Restart the replication server process on the source: dsrutil <dbname> -C restart server
This property was first introduced in 10.1A.