Chapter 12 Working with Replication Server
Replication Server uses logical connections to manage warm standby applications.
A Replication Server warm standby application maintains two Adaptive Server databases, one of which functions as a standby or backup copy of the other. Replication Server's connection to the active and standby databases is called a logical connection.
You design a logical connection the following way:
| Replication Server concept | PowerDesigner concept |
|---|---|
| Logical connection | Data connection group |
The following extended attributes are available from the data connection group property sheet:
| Name | Internal Code | Description |
|---|---|---|
| Distribution | Distribution | Values for distribution are : On or Off |
| Logical name | LogicalName | Specifies a logical name for a logical connection |
| Materialization save interval | MaterializationSaveInterval | Materialization queue save interval. This parameter is only used for standby databases in a warm standby application |
| Replication minimum columns | ReplicateMinimalColumns | Specifies whether Replication Server should send all replication definition columns for all transactions or only those needed to perform update or delete operations at the standby database. Replication Server uses this value in standby situations only when a replication definition does not contain a "send standby" option with any parameter. Otherwise, Replication Server uses the value of the "replicate minimal columns" or "replicate all columns" parameter in the replication definition" |
| Save interval | SaveInterval | Specifies the number of minutes that the Replication Server saves messages after they have been successfully passed to the destination data server. See "Save Interval for Recovery" of the Replication Server Administration Guide for details |
| Send standby columns | SendStandbyRepdefCols | Specifies which columns Replication Server should send to the standby database for a logical connection. Overrides "send standby" options in the replication definition that tell Replication Server which table columns to send to the standby database |
| Send truncate table | SendTruncateTable | Send truncated tables |
| Copyright (C) 2007. Sybase Inc. All rights reserved. |
| |