Use create subscription command for Atomic Materialization

Use create subscription to enable atomic materialization.

To create a subscription with atomic materialization, execute the create subscription command at the Replication Server managing the database where the data is to be replicated. The syntax is:

create subscription subscription
	for table_rep_def 
	with replicate at data_server.database
	[where search_conditions]
 	[incrementally]
 	[subscribe to truncate table]

where subscription is the name of the subscription to activate, table_rep_def is the name of the table replication definition you are subscribing to, and data_server.database identifies the replicate database.

The subscription name must be unique for the replication definition and replicate database.

Subscribing to function replication definitions requires you to use define subscription (the bulk materialization method) or create subscription with the without materialization clause (the no materialization method).

If you use the optional keyword incrementally, Replication Server initializes the subscription by sending 1000-row batches of inserts.

If you do not use the keyword incrementally, Replication Server inserts all of the subscription rows at the replicate database in a single transaction. All of the rows are held in a stable queue at the replicate Replication Server at one time, and there must be enough partition space to accommodate them. Also, the transaction log for the replicate database must have enough space to log the transaction.