Task 2: Creating replication definitions

Create replication definitions using the Replication Server create replication definition command to define the source data available for replicate tables that have subscriptions to the DB2 tables.

You must create at least one replication definition for each DB2 table that contains data you want to replicate.

When you create a replication definition for a table in the primary Replication Server, the replication system makes this table available to any subscribing replicate Replication Servers or replicate databases.

Each replication definition can have multiple subscriptions.

Make sure that you specify valid ASE datatypes when creating replication definitions. For information on valid datatypes, see the appropriate documentation for ASE.

Replication Server version 12.0 and later include Heterogeneous Datatype Support (HDS). This means that you can now use DB2 date, time, and timestamp datatypes without having to map them to ASE datatypes. For more information on setting up Replication Server and the HDS feature, see the Replication Server Configuration Guide.

See the first part of this chapter for detailed information about mapping DB2 datatypes to ASE datatypes.

To create a replication definition

Log in to the primary Replication Server as the System Administrator (sa) using isql:
```
isql -Usa -Psa_password -Sservername
```

Create the replication definition using the following syntax:

create replication definition replication_definition
 with primary at data_server.database
 [with all tables named [table_owner.]'table_name' |
 [with primary table named
   [table_owner.]'table_name']
 [with replicate table named
   [table_owner.]'table_name']]
 (column_name [as replicate_column_name]
     [datatype [null | not null]]
   [, column_name [as replicate_column_name]
     [datatype [null | not null]]]...)
 primary key (column_name [, column_name]...)
 [searchable columns (column_name
   [, column_name]...)]
 [send standby [{all | replication definition}
   columns]]
 [replicate {minimal | all} columns]
 [replicate_if_changed
   (column_name [, column_name]...)]
 [always_replicate (column_name [, column_name]...)]