1.新增QSUB名称为SUB0002，目的是为了同步db2inst1.t2表到目标端的db2inst1.t2表。t2表需要提前创建。http://www.cndba.cn/hbhe0316/article/4865http://www.cndba.cn/hbhe0316/article/4865http://www.cndba.cn/hbhe0316/article/4865http://www.cndba.cn/hbhe0316/article/4865

[db2inst1@node01 scripts]$ cat add_new_qsub 
ASNCLP SESSION SET TO Q REPLICATION;
SET SERVER CAPTURE TO DBALIAS DB110 ID db2inst1 PASSWORD "wwwwww";
SET SERVER TARGET  TO DBALIAS DB111 ID db2inst1 PASSWORD "wwwwww";
SET RUN SCRIPT NOW STOP ON SQL ERROR ON;
CREATE QSUB USING REPLQMAP SAMPLE_ASN_TO_TARGETDB_ASN (SUBNAME SUB0002 DB2INST1.T2      OPTIONS HAS LOAD PHASE I exist TARGET NAME DB2INST1.T2      LOAD TYPE 2);
QUIT;

2.执行命令导入SUB0002http://www.cndba.cn/hbhe0316/article/4865http://www.cndba.cn/hbhe0316/article/4865

[db2inst1@node01 scripts]$ asnclp -f add_new_qsub 

====
CMD: ASNCLP SESSION SET TO Q REPLICATION;
====


====
CMD: SET SERVER CAPTURE TO DBALIAS DB110 ID db2inst1 PASSWORD "wwwwww";
====


====
CMD: SET SERVER TARGET  TO DBALIAS DB111 ID db2inst1 PASSWORD "wwwwww";
====


====
CMD: SET RUN SCRIPT NOW STOP ON SQL ERROR ON;
====


====
CMD: CREATE QSUB USING REPLQMAP SAMPLE_ASN_TO_TARGETDB_ASN (SUBNAME SUB0002 DB2INST1.T2      OPTIONS HAS LOAD PHASE I exist TARGET NAME DB2INST1.T2      LOAD TYPE 2);
====


ASN1956I  ASNCLP : Generating SQL script files for action: "CREATE Q SUBSCRIPTION".

ASN1955I  ASNCLP : Using the following files: "qreplcap.sql" for the Capture SQL script, "replctl.sql" for the control SQL script, "qreplapp.sql" for the target SQL script, and "qreplmsg.log" for the log file.

--- ASNCLP Version 11.01.00 Build date 2021-02-19 21:15:14

<ClpInfo2Log:: Now running SQL...>
ASN1514I  The replication action ended at "Wednesday, October 6, 2021 8:50:08 AM CST" with "1" successes, "0" errors, and "1" warnings.

<ClpInfo2Log:: Now running SQL...>
ASN1514I  The replication action ended at "Wednesday, October 6, 2021 8:50:08 AM CST" with "0" successes, "0" errors, and "0" warnings.

<ClpInfo2Log:: The SQL command completed successfully.>

====
CMD: QUIT;
====


ASN1953I  ASNCLP : Command completed.

3.查看SUB0002是否添加成功http://www.cndba.cn/hbhe0316/article/4865http://www.cndba.cn/hbhe0316/article/4865

[db2inst1@node01 scripts]$ db2 connect to sourcedb
[db2inst1@node01 scripts]$ db2 "select char(subname,20)subname,state from asn.ibmqrep_subs"

SUBNAME              STATE
-------------------- -----
SUB0001              L    
SUB0002              N    

  2 record(s) selected.

4.重启Q capture和Q apply

版权声明：本文为博主原创文章，未经博主允许不得转载。

QREP