Direct Load Materialization from Adaptive Server to Adaptive Server

Use this procedure to set up direct load materialization and enable replication from an Adaptive Server primary to an Adaptive Server replicate.

  1. Use isql to log in to the replicate Replication Server:
    isql -Uiuser -Pipassword -SRRS_servername
    where:

    • iuser is the subscription creator, who must have create object permission.

    • ipassword is the password for iuser.

    • RRS_servername is the server name of the replicate Replication Server.

  2. At the replicate Replication Server, create the subscription:
    create subscription subscription_name
for replication_definition
with replicate at dataserver.database
[where search_conditions]
without holdlock
direct_load

[user cusername password cpass]
go

    The dataserver.database must match the Replication Server connection name you use for the replicate database. If you specify cusername here, this name is used to log in to the primary database and select from the primary table. If you do not specify cusername here, iuser—the name specified in isql—is used. Make sure that the name used to log in to the primary database has necessary permission at the primary database.

  3. Monitor the progress of the subscription materialization:
    check subscription subscription_name for repdef_name
with replicate at replicate_dataserver.replicate_database
go

    When materialization is complete, Replication Server returns a message similar to:

    Subscription subscription_name has been MATERIALIZED at the replicate.

    When the subscription process is complete, Replication Server returns a message similar to:

    Subscription subscription_name is VALID at the replicate.
    If there is an error in the subscription process, the check subscription command returns a message similar to:
    Subscription subscription_name encountered ERROR.
    When a subscription encounters an error, look at the replicate and primary Replication Server log files to diagnose the cause, drop the subscription without purge, delete data from the replicate table, correct the error, and then recreate the subscription. See the Replication Server Troubleshooting Guide > Subscription Problems > check subscription > Materialization Status and the Replication Server Troubleshooting Guide > Subscription Problems > Materialization Problems.

See the Replication Server Reference Manual > Replication Server Commands for information on configuring Replication Servers and materialization methods.

Parent topic: Direct Load Materialization