Data server error handling

Replication Server allows user-definable error processing for data server errors. This is accomplished by assigning appropriate error class to specified connection and customizing the assigned error class. The error actions should match the errors returned by the data server. Table 6-2 lists the RCL commands and Adaptive Server system procedures that manage errors and error classes.

Table 6-2: RCL commands and system procedures for error processing

Command

Description

assign action

Specifies an error processing action for one or more data server or Replication Server errors

alter error class

Changes an existing error class

create error class

Creates a new error class

drop error class

Drops an existing error class

alter connection

Associates an error class with an existing database connection

create connection

Associates an error class with a new database connection

rs_helpclass

Adaptive Server stored procedure that displays the name of each existing error class, function-string class, and their primary Replication Server, and in the case of inherited classes, the parent class.

rs_helperror

Adaptive Server stored procedure that displays the Replication Server error actions mapped to a given data server or Replication Server error number