IBM Q复制实施

hbhe0316

已于 2022-02-16 16:03:00 修改

阅读量552

点赞数

文章标签：队列数据库 python sqlserver sql

于 2021-10-05 21:43:00 首次发布

本文链接：https://blog.csdn.net/hbhe0316/article/details/122701375

版权

本文详细介绍了IBM Q复制的实现过程，包括源端和目标端的准备工作，如创建测试表、编目数据库、设置MQ队列管理器、生成密码文件、创建复制表和控制表。同时，阐述了如何配置ReplQrep和QSUB，启动capture和apply，最终确保源端数据成功同步到目标端。

摘要由CSDN通过智能技术生成

测试环境
           IP              db2 version  dbname    dbalias  mqversion     qname        
源端:  192.168.56.110        11.1.4.6   sourcedb   DB110    9.0.5.0       DB110 
目标端 192.168.56.111        11.1.4.6   targetdb   DB111    9.0.5.0       DB111

dbalias必须和qname相同

1.源端创建测试表t1

[db2inst1@node01 ~]$ db2 connect to sourcedb

   Database Connection Information

 Database server        = DB2/LINUXX8664 11.1.4.6
 SQL authorization ID   = DB2INST1
 Local database alias   = SOURCEDB

[db2inst1@node01 ~]$ db2 "create table t1 (id int,name varchar(10))"
[db2inst1@node01 ~]$ db2 "insert into t1 values (1,'a')"
[db2inst1@node01 ~]$ db2 "insert into t1 values (2,'b')"
[db2inst1@node01 ~]$ db2 "insert into t1 values (3,'c')"
[db2inst1@node01 ~]$ db2 "insert into t1 values (4,'d')"
[db2inst1@node01 ~]$ db2 "insert into t1 values (5,'e')"
目标端创建库，但是不插入数据
[db2inst1@node02 ~]$ db2 connect to targetdb

   Database Connection Information

 Database server        = DB2/LINUXX8664 11.1.4.6
 SQL authorization ID   = DB2INST1
 Local database alias   = TARGETDB

[db2inst1@node02 ~]$ db2 "create table t1 (id int,name varchar(10))"
DB20000I  The SQL command completed successfully.

2.在源端和目标端将db2inst1加入mqm组中

[root@node01 ~]# usermod -G mqm db2inst1
[root@node01 ~]# id db2inst1
uid=1000(db2inst1) gid=1000(db2iadm1) groups=1000(db2iadm1),1003(mqm)

[root@node02 ~]# usermod -G mqm db2inst1
[root@node02 ~]# id db2inst1
uid=1000(db2inst1) gid=1000(db2iadm1) groups=1000(db2iadm1),1003(mqm)

3.源端和目标端编目数据库

db2 catalog tcpip node node110  remote 192.168.56.110  server 50000
db2 catalog tcpip node node111  remote 192.168.56.111  server 50000

db2 catalog db sourcedb as DB110 at node node110
db2 catalog db targetdb as DB111 at node node111
db2 terminate

db2 connect to DB110 user db2inst1 using wwwwww
db2 terminate
db2 connect to DB111 user db2inst1 using wwwwww
db2 terminate

4.创建mq队列管理器

[db2inst1@node01 ~]$ cat 1_create_mq_object 
##################################################
ASNCLP SESSION SET TO Q REPLICATION;
#CREATE MQ SCRIPT RUN NOW
CREATE MQ SCRIPT
CONFIG TYPE U
MQSERVER 1 NAME DB110 MQHOST "192.168.56.110",
MQSERVER 2 NAME DB111 MQHOST "192.168.56.111";
QUIT;
##################################################

[db2inst1@node01 ~]$ asnclp -f 1_create_mq_object

在源端执行命令

[db2inst1@node01 ~]$ sh qrepl.db110.mq_aixlinux.sh

在目标端执行命令

[db2inst1@node02 ~]$ sh qrepl.db111.mq_aixlinux.sh

5.源端和目标端生成密码文件

[db2inst1@node01 ~]$ asnpwd init
2021-10-05-11.05.22.208520 ASN1981I  "Asnpwd" : "" : "Initial". The program completed successfully using password file "asnpwd.aut".
[db2inst1@node01 ~]$ asnpwd add alias DB110 id db2inst1 password wwwwww
2021-10-05-11.06.05.809424 ASN1981I  "Asnpwd" : "" : "Initial". The program completed successfully using password file "asnpwd.aut".
[db2inst1@node01 ~]$ asnpwd add alias DB111 id db2inst1 password wwwwww