XXX工商局DB2 Q复制配置维护手册.doc

《XXX工商局DB2 Q复制配置维护手册.doc》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、1、Q复制规划1.1主机和DB2的相关设置信息descriptionsourcetargetHostnameDbsvr01Dbsvr04HostIPAddress10.0.1.4510.0.1.44Db2instanceownerDb1inst1Db1inst1Db2tcpport5000250002Databaseserver/aliaspronodedssnodeDb2codepage13861386LogretainYesYesDBALIAStopicidssdb注意:在使用复制功能之前，源数据库都应该将日志

2、模式设置为archivelogging模式（归档日志模式）1.2WebsphereMQ的相关配置信息descriptionsourcetargetQueueManagerQMSYSAQMSYSBListenerport14531454TransmitQSYSA.XMITQSYSB.XMITQSDRchannelSYSAtoSYSBSYSBtoSYSASCVchannelSYSBtoSYSASYSAtoSYSBRestartQSYSA.RESTARTQAdminQSYSA.ADMINQSYSA.ADMINQSendQ

3、(remote)SYSA.SENDQReceiveQ(local)SYSB.RECVQAdminQ(remote)SYSA.ADMINQSpillQIBMQREP.SPILL.MODELQ1.3Q复制的配置信息descriptionsourcetargetQcaptureschemaASNQapplyschemaASNQcapturepath/home/db2inst2/captureQapplypath/home/db2inst2/applyReplicationqueuemapnameSYSAtoSYSBSYS

4、AtoSYSB1.4复制队列映射属性descriptionQCaptureQApply复制队列映射名称SYSAtoSYSBQCapture服务器topicisQApply服务器dssdb发送队列SYSA.SENDQ接收队列SYSB.RECVQ管理队列SYSA.ADMINQSYSA.ADMINQ.1.5通道测试cd/usr/mqm/samp/bin./amqsputSYSA.SENDQQMSYSA./amqsgetSYSB.RECVQQMSYSB2、mq用户创建创建用户mqm和组mqm,并把组mqm加入到用户db2i

5、nst1和db2fenc1中。3、mqsoftwareinstall解压缩mq软件，用smittyinstallp安装,创建大小50G的mqmvg、mqmlv和文件系统mqm,挂载点/var/mqm，/var/mqm/log4、mq队列和通道创建在dbsvr04上执行setclockdbsvr01进行与dbsvr01的时间同步，需要在/etc/hosts中添加dbsvr01和IP。由于MQ的需要在dbsvr01和dbsvr04中/etc/hosts添加相互的IP和name信息。Serviceip和servicena

6、me也要添加。Dbsvr04:/etc/hosts:10.0.1.41dbsvr0110.0.1.44dbsvr0410.0.1.45dbserver//hacmp中serviceIPMQ测试：Dbsvr01:$crtmqm-qvenus.queue.managerWebSphereMQqueuemanagercreated.Creatingorreplacingdefaultobjectsforvenus.queue.manager.Defaultobjectsstatistics:58created.0repl

7、aced.0failed.Completingsetup.Setupcompleted.$strmqmWebSphereMQqueuemanager'venus.queue.manager'starting.5logrecordsaccessedonqueuemanager'venus.queue.manager'duringthelogreplayphase.Logreplayforqueuemanager'venus.queue.manager'complete.Transactionmanagerstater

8、ecoveredforqueuemanager'venus.queue.manager'.WebSphereMQqueuemanager'venus.queue.manager'started.$runmqsc5724-H72(C)CopyrightIBMCorp.1994,2008.ALLRIGHTSRESERVED.StartingMQSCforqueu