Recitalreplication
Template:YLM to do The replication services are administrated with the dbservice command. It takes the following arguments;
Contents
help
If you can specify help or -h argument without a service name first and it will display a list of arguments for all the services.
# dbservice help
service name
For all non help related commands you must specify the name of the service. The following list of service names can be used, these can be abbreviated to the first three letters of the name.
Service Name | Description |
---|---|
rrs | This will perform the request on all services |
subscriber | This will perform the request on the subscriber service. |
publisher | This will perform the request on the publisher service. |
start
This argument is used to start the specified service. If the service name specified is all, then all configured services will be start on this system.
stop
This argument is used to stop the specified service. If the service name specified is all, then all running services will be stopped on this system.
restart
This argument is used to restart the specified service. If the service name specified is all, then all running services will be restarted on this system.
status
This argument is used to display the current status of the specified service. If the service name specified is all, then the current status for all services will be displayed.
-d seconds
Specify the delay in seconds between checking for new transactions. Specifying this argument on the command will overwrite the setting specified for DB_REPDELAY in the dbservice.conf file.
-i
Rebuild the subscriber index used for Peer to Peer replication.
-h
List available command line options (this page).
-l
Turn logging on. Specifying this argument on the command will overwrite the setting specified for DB_REPLOG in the dbservice.conf file.
-p password
Specify a password for the server the publisher is running on. The password can also be specified in the data source.
-r
Reset the time stamp so all transactions in the queue are processed.
-u username
Specify a user name for the server the publisher is running on. The user name can also be specified in the data source.