Creates an error class.
create error class error_class
The name for the new error class. The name must be unique in the replication system and must conform to the rules for identifiers.
This example creates a new error class named pubs2_db_err_class:
create error class pubs2_db_err_class
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. Initially, this error class does not have a primary site. You must create this error class at a primary site before you can change 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.
create error class requires “sa” permission.
alter connection, assign action, create connection, drop error class, rs_init_erroractions
