Copying (promoting) Q replication environments

What do we mean by copying (or promoting) environments? Well, suppose we have developed a replication solution on a test machine and now want to build a similar solution on a production machine—we have two choices: if we have built the test solution using ASNCLP scripts, then we can just move these scripts over to the production machine, edit them to reflect the new schema, database names, and so on and then run them there. The point to watch out for with this approach is that the scripts have to be complete—what happens if something has been changed, which has not been reflected in the ASNCLP scripts! The second option is to use the promote functionality of the ASNCLP commands, which we will discuss next.

The ASNCLP PROMOTE procedure

Let's look at promoting a unidirectional setup from a test environment to a production one. We have replication set up between DB2A and DB2B on test and want to move this to DB2C and DB2D on production.

We will issue...