Row Count Validation for Non-SQL Statement Replication

To address errors in Replication Server, Replication Server 15.2 includes support for Replication Server error classes and error actions for row count verification errors not related to SQL statement replication.

Replication Server 15.2 introduces the Replication Server error class. Therefore, with version 15.2, a connection associates itself with two error class types—a data server error class and a Replication Server error class. You must associate a Replication Server error class with a connection before Replication Server can query the Replication Server error class for overrides to the default Replication Server error actions. You can associate a connection with only one Replication Server error class. However, you can associate one Replication Server error class with multiple connections. Use the set replication server error class parameter for the create connection and alter connection commands to associate a Replication Server error class with a connection.

When Replication Server responds to errors, it looks first for the Replication Server error class assigned to the connection. If Replication Server does not find the Replication Server error class, Replication Server uses the default rs_repserver_error_class error class assigned to the server.

• Command to Create Replication Server Error Classes
  With Replication Server 15.2, you can use create error class to create Replication Server error classes that you can use to assign error actions for errors that occur in Replication Server.
• Command to Assign Error Actions
  Use the assign action command at the primary site for the Replication Server error class to specify an error action.
• Stored Procedures to Display Replication Server Error Classes
  Use the rs_helpdb, rs_helpclass, and rs_helperror stored procedures to display information about Replication Server error classes.
• Replication Server System Database Modifications
  To support Replication Server error handling, two system tables in the Replication Server System Database (RSSD) have been modified.