IBM Q复制新增QSUB

原创

wx62e28ac222a20 2022-08-04 11:08:44 ©著作权

文章标签 python sql java sqlserver cmd 文章分类 运维

©著作权归作者所有：来自51CTO博客作者wx62e28ac222a20的原创作品，请联系作者获取转载授权，否则将追究法律责任

1.新增QSUB名称为SUB0002，目的是为了同步db2inst1.t2表到目标端的db2inst1.t2表。t2表需要提前创建。

[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.执行命令导入SUB0002

[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是否添加成功

[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