Defining a subscription

Replication overview

Use the Define Subscription window to define basic or customized subscription sets to be replicated. Defining basic subscription sets involves setting up source and target table combinations with the appropriate target server and Apply qualifier. Defining customized subscription sets involves adding more specifications, such as specifying the target table type, timing, and run-time SQL statements.

If the window was invoked from the Create menu option, all fields are empty.

Fields and controls

Authorities and privileges

To define a subscription:

1. Open the Define Subscription window.
2. Set up sources and targets.
3. Optional: Select a source table and target table combination from the source table and target table fields and click on the Advanced push button, so you can:
   • Specify the target table type.
   • Specify the names of the target columns.
   • Create new columns.
   • Copy a subset of rows to the target table.
4. Optional: Click on the Add push button to add one or more source and target table combinations to the replication subscription.

   Tip: You can add source and target table combinations at any time while you are using this window.

5. Optional: Click on the Change push button to change the target table of a source and target table combination.
6. Optional: Click on the Remove push button to remove one or more source and target table combinations from the replication subscription.

   Tip: You can remove source and target combinations at any time while you are using this window.

7. Optional: Click on the SQL push button to open the SQL window so that you can define SQL statements to be processed during subscription run time.
8. Optional: Click on the Timing push button to open the Subscription Timing notebook so that you can specify when and how often to replicate the subscription.
9. Click on OK to submit the subscription. At the Run Now or Save SQL window, you can choose to run your subscription request now or run it later.
10. Refresh and verify your object.

    After verifying your object, remember to start the Apply program from your command line processor using your subscription's Apply qualifier. See the Replication Guide and Reference for more information.

Related information

• Changing a subscription
• Cloning a subscription
• Activating and deactivating a subscription
• Running an SQL file now or later
• Removing a subscription