Database replication

When you work with replications you can perform the following functions:

• Create replication

• update replications or parts of the replication

• Extend the replication by adding user spaces to the replication

• repair of user spaces, the catalog space or the entire database with the aid of replications

The table below presents an overview of the necessary activities and lists the associated utility statements. The right-most column indicates which main function to choose in the utility monitor.

Activity	Statement and function	Main function in the utility monitor
Create replication	create a copy of the database CREATE REPLICATION	Main function COPY & RECOVER / REPLICATION (COP) with continuation forms Form COP.6
Update a replication	define starting point by means of job variables make log files available REFRESH REPLICATION	Main function INFORMATION-SCHEMA Form INF.5 Main function COPY & RECOVER / REPLICATION (COP) Form COP.7
Extend the replication by adding user spaces to the replication	define starting point using the RECOVERY_UNITS provide DA-LOG files make SESAM backup or foreign copy available REFRESH SPACE	Main function INFORMATION-SCHEMA Form INF.5 Main function COPY & RECOVER / REPLICATION (COP) Form COP.7
Repair, reset or recreate of user spaces, the catalog space or the entire database using replications	define starting point by means of job variables make log files available RECOVER USING/TO REPLICATION	Main function INFORMATION-SCHEMA Form INF.5 Main function COPY & RECOVER / REPLICATION (COP) Forms COP.2.n.3 (n=1,2,4,5)

Table 68: Utility statements and main functions of the utility monitor for the use of replications

You will find a detailed description of how to work with the replication of a database in section “Database replication”.