Show TOC

admin verify_repserver_cmdLocate this document in the navigation structure

Verifies that Replication Server can successfully execute a replication definition request.

Syntax
admin verify_repserver_cmd, ‘<rs_api>
Parameters
rs_api

The string containing the Replication Command Language (RCL) command and all corresponding parameters you want to verify.

Enclose <rs_api> in single quotes, and replace each single quote inside the string with two single quotes.

Examples
Example 1

In this example, admin verify_repserver_cmd tests if you can use alter replication definition to drop columns from a replication definition and suspend the target DSIs successfully after the data for the old replication definition version is replicated to a target, such as a standby or replicate database:

admin verify_repserver_cmd, ‘alter replication
definition authors drop <address>, <city>, <state>, <zip>
with DSI_suspended’
If Replication Server can execute the alter replication definition command, Replication Server returns with this message:
The replication definition command can be executed
successfully.
Example 2

This example shows what happens if you use admin verify_repserver_cmd to see whether you can drop columns from a replication definition that does not exist:

admin verify_repserver_cmd, ‘alter replication
definition authors_does_not_exist
drop <address>, <city>, <state>, <zip>

Replication Server returns with a message that the replication definition named “authors_does_not_exist” does not exist.

Example 3

This example shows that admin verify_repserver_cmd can detect syntax errors, such as using the “columns” keyword in the command line:

admin verify_repserver_cmd, ‘alter replication
definition authors drop columns <address>, <city>, <state>, <zip>
with DSI_suspended’
Replication Server returns with a message, such as:
Line 1, character 71: Incorrect syntax with the keyword
'columns'.
Example 4

This example shows that admin verify_repserver_cmd can detect if you are using quotes incorrectly, such as using double quotes to enclose ‘off’:

admin verify_repserver_cmd, ‘alter replication
definition authors replicate sqldml “off”’
Replication Server returns with a message, such as:
Line 1, Incorrect syntax with the keyword 'off'.

The correct syntax is:

admin verify_repserver_cmd, ‘alter replication
definition authors replicate sqldml ‘‘off’’’
Usage
  • When Replication Agent sends a replication definition RCL to Replication Server to execute, and the replication definition RCL fails to execute, Replication Agent shuts down. To avoid this situation, use admin verify_repserver_cmd to verify that Replication Server can successfully execute a replication definition request before you execute the RCL directly from the primary database. Replication Server returns an error if it cannot successfully execute the request.

  • Replication Server supports admin verify_repserver_cmd for the same replication definition commands as rs_send_repserver_cmd:

    • alter replication definition

    • create replication definition

    • drop replication definition

    • alter applied function replication definition

    • create applied function replication definition

    • alter request function replication definition

    • create request function replication definition

Permissions

Any user may execute this command.