How to Enable SQL Replication for DB2

# Identify source table(s).

​

# Identify databases involved.

​

# ('Control' and 'Target' are usually the same)

​

SET RUN SCRIPT NOW STOP ON SQL ERROR ON;

​

SET SERVER CAPTURE TO DB WESTERN ID db2inst1 PASSWORD "IN11**rk";

​

CREATE CONTROL TABLES FOR CAPTURE SERVER;

​

CREATE REGISTRATION (ABC.EMPLOYEE) DIFFERENTIAL REFRESH STAGE ABC.CDEMPLOYEE;

​

SET SERVER CONTROL TO DB WESTERN ID db2inst1 PASSWORD "IN11**rk";

​

SET SERVER TARGET  TO DB WESTERN ID db2inst1 PASSWORD "IN11**rk";

​

# Add metadata tables to hold information about

​

# your source and target tables.

​

CREATE CONTROL TABLES FOR APPLY CONTROL SERVER;

​

# Changed data will be 'staged' (stored) in a 'CD' table

​

# A subscription maps a source table to a target table.

​

# Subscriptions are grouped in sets.

​

# Every subscription must be in a set, so we make a set here:

​

CREATE SUBSCRIPTION SET SETNAME SETWESTERNTE APPLYQUAL MYQUALWESTERNTE ACTIVATE YES

​

TIMING INTERVAL 1 START DATE "2019-05-05" TIME "01:00:00.000000";

​

# Each subscription is a member of a set.

​

# If needed, you can create the target table as we do here:

​

SET PROFILE TBSPROFILETE FOR OBJECT TARGET TABLESPACE OPTIONS UW USING FILE "/opt/ibm/db2/V11.1/tablespace/TSTRGWESTERNTE.TS" SIZE 700 PAGES;

​

CREATE MEMBER IN SETNAME SETWESTERNTE APPLYQUAL MYQUALWESTERNTE ACTIVATE YES

​

SOURCE ABC.EMPLOYEE

​

TARGET NAME ABC.TGEMPLOYEE

​

DEFINITION IN TSTRGWESTERNTE00 CREATE USING PROFILE TBSPROFILETE

​

TYPE USERCOPY COLS ALL REGISTERED;

​

# Now, run the file through the asnclp command

​

# and you are ready to replicate data.

​

QUIT;