Replication Definitions and Subscriptions for Warm Standby Databases

You can create replication definitions and subscriptions for warm standby applications.

In a replication system containing only Adaptive Server databases, you can reduce the need for replication definitions for tables in a warm standby environment or multisite availability (MSA) environment if a replication definition exists solely to specify primary key, quoted identifier information , or customized function string. See Replication Server Administration Guide Volume 1 > Manage Replicated Objects Using Multisite Availability > Reduce the Use of Replication Definitions and Subscriptions.

However, you can create a replication definition for each table in the logical database. You can also use function replication definitions when replicating into a standby database. Replication definitions can change how Replication Server replicates data into a standby database, allowing you to optimize your warm standby application or enable a non-default behavior that your application requires.

You can use replication definitions in a warm standby application in normal replication into or out of the logical database.

• alter table Support for Warm Standby
  Adaptive Server Enterprise version 12.0 and later allows users to alter existing tables—add non-nullable columns, drop columns, and modify column datatypes.
• Use Replication Definitions to Optimize Performance
  Use replication definitions to improve the performance of the replication system in a warm standby environment.
• Use Replication Definitions to Copy Redundant Updates
  If you want to replicate redundant updates, create a replication definition for the column that includes the send standby replication definition parameter option
• Use Subscriptions with Warm Standby Applications
  You can use subscriptions with warm standby applications.
• Missing Columns When You Create the Standby Database
  When you create a standby database for an existing database that has replication definitions, missing columns may result under a certain combination of circumstances.