When you define tables, registrations, or subscription sets on one system (a test system, for example), and you need to copy the replication environment to another system (a production system, for example), you can use the DJRA promote functions. These functions reverse engineer your tables, registrations, or subscription sets, to create script files with appropriate data definition language (DDL) and data manipulation language (DML). Table 7 shows the three promote functions.
For example, use the promote functions to define subscription sets for
remote DB2 Personal Edition target databases. After you define a model
target system in your test environment, you can create subscription-set
scripts (and modify which Apply qualifier is used and so on) for your DB2
Personal Edition systems, which are not otherwise supported from a central
control point.
Promote table | This function promotes tables, table spaces, and indexes. It does
not promote constraints defined for a table.
This function is fully supported for DB2 UDB V5 and later, but for the IBM Common Server you can promote only tables, not table spaces. |
Promote registration | This function promotes registrations and view registrations from a source server. |
Promote subscription | This function promotes subscriptions: subscription sets,
subscription-set members, subscription columns, subscription prune control,
and subscription statements. It enables you to create a new
subscription set from an existing one.
From the Promote Subscriptions window in DJRA, you can change your subscriptions (before promoting them) by setting new values for any of the following fields: Apply Qualifier, Set Name, Source server, Source alias, Target server, Target alias, Control server, and Control alias. |