create error class

Description

Creates an error class.

Syntax

create [replication server] error class error_class
    [set template to template_error_class]

Parameters

Examples

Example 1

This example creates a new error class named pubs2_db_err_class:

create error class pubs2_db_err_class

Example 2

Creates the my_error_class error class based on rs_oracle_error_class:

create error class my_error_class set template to rs_oracle_error_class

Example 3

Creates a new Replication Server error class named pubs2_rs_err_class:

create replication server error class
   pubs2_rs_err_class

Example 4

Creates the my_rs_err_class Replication Server error class based on rs_repserver_error_class, which is the default Replication Server error class:

create replication server error class my_rs_err_class
set template to rs_repserver_error_class

Usage

• Use create error class to create an error class. An error class is a name used to group error action assignments for a database.

• This command has the following requirements:

  • Routes must exist from the Replication Server where an error class is created to the Replication Servers managing data servers that are to use the error class.

  • The rs_sqlserver_error_class is the default error class provided for Adaptive Server databases while the rs_repserver_error_class is the default error class provided for Replication Server. Initially, these two error classes do not have a primary site. You must create these error classes at a primary site before you can change the default error actions.

  • After using create error class, use the rs_init_erroractions stored procedure to initialize the error class.

• Associate an error class with a database using create connection or alter connection. Each database can have one error class. An error class can be associated with multiple databases.

• Replication Server distributes the new error class to qualifying sites through out the replication system. The changes do not appear immediately at all such sites because of normal replication system lag time.

• Use assign action to change the Replication Server response to specific data server errors. Actions are assigned at the Replication Server where the error class is created.

• Use drop error class to remove an error class and any actions associated with it.