Direct load materialization is only for use with subscriptions to table replication
definitions.
To use direct load materialization, create your subscription to a table replication
definition using the direct_load option of the create
subscription command. See Replication Server Reference Manual >
Replication Server Commands > create subscription.
When you drop a subscription that has been created with the
direct_load option:
- If the subscription is not yet valid, use the drop
subscription command with the without purge
option, which immediately stops the materialization threads, skips any pending
DML operations on the table, and drops the subscription.
- If the subscription is not yet valid when it is dropped, the replicate
Replication Server DSI must be running for drop subscription
to complete because Replication Server needs to clear all commands related to
the subscription being dropped.
When you drop a subscription with the
without purge option, it
is your responsibility to clean up the replicate table.