XXX工商局DB2Q复制配置维护手册.docxVIP

Q复制规划1.1主机和DB2的相关设置信息descriptionsourcetargetHost nameDbsvr01Dbsvr04Host IP Address54Db2 instance ownerDb1inst1Db1inst1Db2 tcp port5000250002Database server /aliaspronodedssnodeDb2 codepagogretainYesYesDB ALIAStopicidssdb注意: 在使用复制功能之前，源数据库都应该将日志模式设置为archive logging模式（归档日志模式）1.2Websphere MQ的相关配置信息descriptionsourcetargetQueue ManagerQMSYSAQMSYSBListener porransmit QSYSA.XMITQSYSB.XMITQSDR channelSYSAtoSYSBSYSBtoSYSASCV channelSYSBtoSYSASYSAtoSYSBRestart QSYSA.RESTARTQAdminQSYSA.ADMINQSYSA.ADMINQSend Q(remote)SYSA.SENDQReceive Q(local)SYSB.RECVQAdminQ(remote)SYSA.ADMINQSpill QIBMQREP.SPILL.MODELQ1.3Q复制的配置信息descriptionsourcetargetQ capture schemaASN Q apply schemaASN Q capture path/home/db2inst2/captureQ apply path/home/db2inst2/applyReplication queue map nameSYSAtoSYSBSYSAtoSYSB1.4复制队列映射属性descriptionQCaptureQApply复制队列映射名称SYSAtoSYSBQ Capture服务器topicisQ Apply服务器dssdb发送队列SYSA.SENDQ接收队列SYSB.RECVQ管理队列SYSA.ADMINQSYSA.ADMINQ.1.5通道测试cd /usr/mqm/samp/bin./amqsput SYSA.SENDQ QMSYSA./amqsget SYSB.RECVQ QMSYSB2、mq用户创建创建用户mqm和组mqm,并把组mqm加入到用户db2inst1和db2fenc1中。3、mq software install解压缩mq软件，用smitty installp安装,创建大小50G的mqmvg 、mqmlv和文件系统mqm,挂载点/var/mqm，/var/mqm/log 4、mq 队列和通道创建在dbsvr04上执行setclock dbsvr01进行与dbsvr01的时间同步，需要在/etc/hosts中添加dbsvr01和IP。由于MQ的需要在dbsvr01和dbsvr04中/etc/hosts添加相互的IP和name 信息。Service ip 和 service name 也要添加。Dbsvr04:/etc/hosts:1 dbsvr04 dbsvr045 dbserver //hacmp 中service IP MQ测试：Dbsvr01:$ crtmqm -q venus.queue.managerWebSphere MQ queue manager created.Creating or replacing default objects for venus.queue.manager.Default objects statistics : 58 created. 0 replaced. 0 failed.Completing setup.Setup completed.$ strmqmWebSphere MQ queue manager venus.queue.manager starting.5 log records accessed on queue manager venus.queue.manager during the log replay phase.Log replay for queue manager venus.queue.manager complete.Transaction manager state recovered for queue manager venus.queue.manager.WebSphere MQ queue manager venus.queue.manager started.$ runmqsc57