After the subscription is defined, use activate subscription to set the subscription status to Activating at the replicate Replication Server and to send the activation request to the primary Replication Server.
When the primary Replication Server receives the activation request, it changes the subscription status to Active, sends the activation request back to the replicate Replication Server, and begins sending updates for the subscription to the replicate Replication Server. When the replicate Replication Server receives the activation request, it changes the subscription status to Active at the replicate Replication Server.
If the with suspension option was specified for the activate subscription command, the DSI thread is suspended when the activation request is received at the replicate Replication Server. At this stage, you load the replicate database. For more information, see the Replication Server Reference Manual. After loading, execute the resume connection command to continue applying transactions from the DSI.
Table 5-6 describes solutions for bulk materialization problems that occur during the activation phase based on the status returned by check subscription. The Replicate Status column shows the subscription status returned by check subscription at the replicate Replication Server. The Primary Status column shows the subscription status returned by check subscription at the primary Replication Server. The Subscription State column provides a detailed description of the subscription status. The Suggested Actions column provides the solutions.
Replicate Status |
Primary Status |
Subscription State |
Suggested Actions |
|---|---|---|---|
Activating/ Recovering |
Defined |
Cannot send the activation request to the primary Replication Server. |
Verify that the primary Replication Server is running and the SQM, SQT, and DIST threads for the primary database are running. Check the error log in the replicate Replication Server. Investigate whether the primary Replication Server has run out of segments. |
Activating |
Active |
The primary Replication Server received the activation request and returned it to the replicate Replication Server. The replicate Replication Server is waiting for the activation request. |
Verify the connection between the primary Replication Server and the replicate Replication Server. Verify that the DSI thread for the replicate database is running. |
Active |
Active |
The activation stage is complete. |
Validate the subscription. If you specified the with suspension option for the activate subscription command, you may now load the replicate database. |
