To create a subscription with bulk materialization, execute the define subscription command at the Replication Server that is managing the database where the data is to be replicated. define subscription sets the subscription status to DEFINED.
The syntax for define subscription is:
define subscription subscription
for {table_rep_def | function_rep_def
publication pub_name | database replication definition db_repdef
with primary at data_server.db
with replicate at data_server.db
[where search_conditions]
[subscribe to truncate table]
where subscription is the name of the subscription to define, table_rep_def is the name of the table replication definition the subscription is for, function_rep_def is the name of the function replication definition the subscription is for, pub_name is the publication the subscription is for, db_repdef is the database replication definition the subscription is for, and data_server.db identifies the primary or replicate database.
The subscription name must be unique for the replication definition and replicate database.
Refer to Chapter 9, “Managing Replicated Tables” for more information on creating table replication definitions. Refer to Chapter 10, “Managing Replicated Functions” for more information on creating function replication definitions. Also refer to Chapter 3, “Replication Server Commands,” in the Replication Server Reference Manual for details on using define subscription command.
