The DSRUTIL properties validation utility enables you to validate the replication properties of replication-enabled source and target databases and confirm running status of target database brokers.

When run against the replication source database, the utility performs the same validation made during startup of the replication server, validating all properties listed in the [server], [control-agent], and [transition] sections of the properties file. For each control-agent listed in the [server].control-agents property, the utility also pings the target database on the hostname and port in the associated [control-agent] section of the properties file.

When run against the replication target database, the utility performs the same validation made during startup of the replication agent, validating all properties listed in the [agent] and [transition] sections of the properties file. If there is a [server] section defined in the target database’s properties file, the length of each control-agent name in the [server].control-agents property is validated.

The utility writes all properties file errors to both standard out and the database log file.

The utility can be run while the database is online or in single-user mode.

Syntax

The command for the utility is as shown:

dsrutil db-name -C validate

Parameters

db-name
The name of the database to perform the action on. The name of the database must be the first argument and must be a valid name.

Notes

  • The utility adds the ability for the source database to report on the running status of any target database brokers using messages 19460 and 19461.
    Database db-name for agent agent-name is online. Broker is running on hostname:port-num. 19460
    		 
    Unable to contact database db-name on hostname:port-num for agent agent-name. 19461