某工商局DB2Q復(fù)制配置維護(hù)手冊(cè)范本

..Q復(fù)制規(guī)劃1.1主機(jī)和DB2的相關(guān)設(shè)置信息descriptionsourcetargetHostnameDbsvr01Dbsvr04HostIPAddressDb2instanceownerDb1inst1Db1inst1Db2tcpport5000250002Databaseserver/aliaspronodedssnodeDb2codepage13861386LogretainYesYesDBALIAStopicidssdb注意:在使用復(fù)制功能之前,源數(shù)據(jù)庫(kù)都應(yīng)該將日志模式設(shè)置為archivelogging模式〔歸檔日志模式1.2WebsphereMQ的相關(guān)配置信息descriptionsourcetargetQueueManagerQMSYSAQMSYSBListenerport14531454TransmitQSYSA.XMITQSYSB.XMITQSDRchannelSYSAtoSYSBSYSBtoSYSASCVchannelSYSBtoSYSASYSAtoSYSBRestartQSYSA.RESTARTQAdminQSYSA.ADMINQSYSA.ADMINQSendQ<remote>SYSA.SENDQReceiveQ<local>SYSB.RECVQAdminQ<remote>SYSA.ADMINQSpillQ1.3Q復(fù)制的配置信息descriptionsourcetargetQcaptureschemaASNQapplyschemaASNQcapturepath/home/db2inst2/captureQapplypath/home/db2inst2/applyReplicationqueuemapnameSYSAtoSYSBSYSAtoSYSB1.4復(fù)制隊(duì)列映射屬性descriptionQCaptureQApply復(fù)制隊(duì)列映射名稱SYSAtoSYSBQCapture服務(wù)器topicisQApply服務(wù)器dssdb發(fā)送隊(duì)列SYSA.SENDQ接收隊(duì)列SYSB.RECVQ管理隊(duì)列SYSA.ADMINQSYSA.ADMINQ.1.5通道測(cè)試cd/usr/mqm/samp/bin./amqsputSYSA.SENDQQMSYSA./amqsgetSYSB.RECVQQMSYSB2、mq用戶創(chuàng)建創(chuàng)建用戶mqm和組mqm,并把組mqm加入到用戶db2inst1和db2fenc1中。3、mqsoftwareinstall解壓縮mq軟件,用smittyinstallp安裝,創(chuàng)建大小50G的mqmvg、mqmlv和文件系統(tǒng)mqm,掛載點(diǎn)/var/mqm,/var/mqm/log4、mq隊(duì)列和通道創(chuàng)建在dbsvr04上執(zhí)行setclockdbsvr01進(jìn)行與dbsvr01的時(shí)間同步,需要在/etc/hosts中添加dbsvr01和IP。由于MQ的需要在dbsvr01和dbsvr04中/etc/hosts添加相互的IP和name信息。Serviceip和servicename也要添加。Dbsvr04:/etc/hosts:1dbsvr04dbsvr045dbserver//hacmp中serviceIPMQ測(cè)試：Dbsvr01:WebSphereMQqueuemanagercreated.Creatingorreplacingdefaultobjectsforvenus.queue.manager.Defaultobjectsstatistics:58created.0replaced.0failed.Completingsetup.Setupcompleted.$strmqmWebSphereMQqueuemanager'venus.queue.manager'starting.5logrecordsaccessedonqueuemanager'venus.queue.manager'duringthelogreplayphase.Logreplayforqueuemanager'venus.queue.manager'complete.Transactionmanagerstaterecoveredforqueuemanager'venus.queue.manager'.WebSphereMQqueuemanager'venus.queue.manager'started.$runmqsc5724-H72<C>CopyrightIBMCorp.1994,2008.ALLRIGHTSRESERVED.StartingMQSCforqueuemanagervenus.queue.manager.defineqlocal<orange.queue>1:defineqlocal<orange.queue>AMQ8006:WebSphereMQqueuecreated.end2:endOneMQSCcommandread.Nocommandshaveasyntaxerror.AllvalidMQSCcommandswereprocessed.$cd/usr/mqm/samp/bin/$./amqsputORANGE.QUEUESampleAMQSPUT0starttargetqueueisORANGE.QUEUEabcddsfsdsdfdsenddbsvr04:WebSphereMQqueuemanagercreated.Creatingorreplacingdefaultobjectsforvenus.queue.manager.Defaultobjectsstatistics:58created.0replaced.0failed.Completingsetup.Setupcompleted.$$strmqmWebSphereMQqueuemanager'venus.queue.manager'starting.5logrecordsaccessedonqueuemanager'venus.queue.manager'duringthelogreplayphase.Logreplayforqueuemanager'venus.queue.manager'complete.Transactionmanagerstaterecoveredforqueuemanager'venus.queue.manager'.WebSphereMQqueuemanager'venus.queue.manager'started.$runmqsc5724-H72<C>CopyrightIBMCorp.1994,2008.ALLRIGHTSRESERVED.StartingMQSCforqueuemanagervenus.queue.manager.defineqlocal<orange.queue>1:defineqlocal<orange.queue>AMQ8006:WebSphereMQqueuecreated.:::end2:endOneMQSCcommandread.Nocommandshaveasyntaxerror.AllvalidMQSCcommandswereprocessed.$cd/usr/mqm/samp/bin$./amqsputORANGE.QUEUESampleAMQSPUT0starttargetqueueisORANGE.QUEUEadsfsdfdsfsdfsdfsSampleAMQSPUT0end$$./amqsgetORANGE.QUEUESampleAMQSGET0startmessage<adsfsdfdsfsdfsdfs>dbsvr01:crtmqm-lc-dSYSA.XMITQ-uDEADLETTER-lp20-ls10-lf10240QMSYSA//創(chuàng)建MQ隊(duì)列strmqmQMSYSA//起隊(duì)列管理器endmqlsr-mQMSYSA//停隊(duì)列管理器ps-ef|grepmq//查看隊(duì)列管理器nohuprunmqlsr-ttcp-p1453-mQMSYSA&//起監(jiān)聽(tīng)ps–ef|greplsr//查看監(jiān)聽(tīng)進(jìn)程endmqmQMSYSA//停隊(duì)列

endmqlsr//停監(jiān)聽(tīng)

dltmqmQMSYSA//刪除管理隊(duì)列runmqscQMSYSA//起MQ資源DEFINEQREMOTE<'SYSA.SENDQ'>RNAME<'SYSB.RECVQ'>RQMNAME<'QMSYSB'>XMITQ<'SYSA.XMITQ'>DEFINEQLOCAL<'SYSA.XMITQ'>USAGE<XMITQ>MAXDEPTH<1000000>DEFPSIST<YES>DEFINEQLOCAL<'DEADLETTER'>USAGE<NORMAL>MAXDEPTH<500000>ALTERQMGRDEADQ<'DEADLETTER'>DEFINECHL<'SYSAtoSYSB'>CHLTYPE<SDR>TRPTYPE<TCP>CONNAME<'4<1454>'>XMITQ<'SYSA.XMITQ'>DISCINT<0>BATCHSZ<200>STARTCHANNEL<'SYSAtoSYSB'>DEFINECHL<'SYSBtoSYSA'>CHLTYPE<RCVR>TRPTYPE<TCP>BATCHSZ<200>DEFINEQLOCAL<'SYSA.ADMINQ'>MAXDEPTH<500000>DEFPSIST<YES>DEFINEQLOCAL<'SYSA.RESTARTQ'>MAXDEPTH<500000>DEFPSIST<YES>End*************************runmqscQMSYSAdischstatus<'SYSAtoSYSB'>//顯示running通道狀態(tài)正常dischstatus<'SYSAtoSYSB'>1:dischstatus<'SYSBtoSYSA'>AMQ8417:DisplayChannelStatusdetails.CHANNEL<SYSBtoSYSA>CHLTYPE<RCVR>CONNAME<4>CURRENTRQMNAME<QMSYSB>STATUS<RUNNING>SUBSTATE<RECEIVE>dischstatus<'SYSBtoSYSA'>2:dischstatus<'SYSBtoSYSA'>AMQ8417:DisplayChannelStatusdetails.CHANNEL<SYSBtoSYSA>CHLTYPE<RCVR>CONNAME<4>CURRENTRQMNAME<QMSYSB>STATUS<RUNNING>SUBSTATE<RECEIVE>*************************runmqscQMSYSBdischstatus<'SYSBtoSYSA'>runmqchl-cSYSAtoSYSB-mQMSYSA//如果沒(méi)有錯(cuò)誤信息顯示,表明該channel成功運(yùn)行runmqchl-cSYSBtoSYSA-mQMSYSA//如果沒(méi)有錯(cuò)誤信息顯示,表明該channel成功運(yùn)行********************************修改queuemanager的CCSID:strmqmrunmqscdisplayqmgr//檢查當(dāng)前queuemanager的CCSID值alterqmgrccsid<437>end*************************dbsvr04:crtmqm-lc-dSYSB.XMITQ-uDEADLETTER-lp20-ls10-lf10240QMSYSBstrmqmQMSYSBnohuprunmqlsr-ttcp-p1454-mQMSYSB&runmqscQMSYSBDEFINEQLOCAL<'SYSB.RECVQ'>MAXDEPTH<1000000>DEFPSIST<YES>DEFINEQREMOTE<'SYSA.ADMINQ'>RNAME<'SYSA.ADMINQ'>RQMNAME<'QMSYSA'>XMITQ<'SYSB.XMITQ'>DEFINEQLOCAL<'SYSB.XMITQ'>MAXDEPTH<1000000>USAGE<XMITQ>DEFPSIST<YES>DEFINEQLOCAL<'DEADLETTER'>USAGE<NORMAL>MAXDEPTH<500000>ALTERQMGRDEADQ<'DEADLETTER'>DEFINECHL<'SYSBtoSYSA'>CHLTYPE<SDR>TRPTYPE<TCP>CONNAME<'5<1453>'>XMITQ<'SYSB.XMITQ'>DISCINT<0>BATCHSZ<200>STARTCHANNEL<'SYSBtoSYSA'>DEFINECHL<'SYSAtoSYSB'>CHLTYPE<RCVR>TRPTYPE<TCP>BATCHSZ<200>DEFINEQMODEL<'IBMQREP.SPILL.MODELQ'>DEFSOPT<SHARED>MAXDEPTH<1000000>MSGDLVSQ<FIFO>DEFTYPE<PERMDYN>end****************************nohuprunmqlsr-ttcp-p1454-mQMSYSB&//起監(jiān)聽(tīng)runmqscQMSYSBdischstatus<'SYSBtoSYSA'>//顯示running通道狀態(tài)正常dischstatus<'SYSBtoSYSA'>dischstatus<'SYSAtoSYSB'>1:dischstatus<'SYSAtoSYSB'>AMQ8417:DisplayChannelStatusdetails.CHANNEL<SYSAtoSYSB>CHLTYPE<RCVR>CONNAME<5>CURRENTRQMNAME<QMSYSA>STATUS<RUNNING>SUBSTATE<RECEIVE>dischstatus<'SYSBtoSYSA'>2:dischstatus<'SYSBtoSYSA'>AMQ8417:DisplayChannelStatusdetails.CHANNEL<SYSBtoSYSA>CHLTYPE<SDR>CONNAME<5<1453>>CURRENTRQMNAME<QMSYSA>STATUS<RUNNING>SUBSTATE<MQGET>XMITQ<SYSB.XMITQ>EN>*********************************************修改隊(duì)列管理器中的字符集命令：首先打開(kāi)命令行窗口。在打開(kāi)后的命令窗口中輸入：runmqsc〔隊(duì)列管理器名稱,然后按回車。其后再輸入：ALTERQMGRCCSID<字符集代碼>,回車,修改成功。最后輸入：DISPLAYQMGRCCSID,查看已經(jīng)更改過(guò)的字符編碼集。DISPLAYQMSTATUSSTATUS〔查看qmgr的運(yùn)行狀態(tài)注:1208是UTF-8格式,1381是中文格式。在字符集代碼處選擇輸入,如果這兩都不是你需要的,你可以查看MB幫助或MQ幫助,選擇合適你的字符集代碼。5、創(chuàng)建catalog庫(kù)本地復(fù)制中心pc、dbsvr01、dbsvr02上創(chuàng)建catalog庫(kù)。本地復(fù)制中心pc上:C:\DocumentsandSettings\admin>cd\C:\>db2listdbdirectorySQL1031N在指示的文件系統(tǒng)中找不到數(shù)據(jù)庫(kù)目錄。SQLSTATE=58031C:\>db2catalogtcpipnodepri5server50002//prodnode對(duì)應(yīng)dbsvr01主機(jī)DB20000ICATALOGTCPIPNODE命令成功完成。DB21056W直到刷新目錄高速緩存之后,目錄更改才生效。C:\>db2catalogdbtopicisatnodepridnodeDB20000ICATALOGDATABASE命令成功完成。DB21056W直到刷新目錄高速緩存之后,目錄更改才生效。C:\>db2terminateDB20000ITERMINATE命令成功完成。C:\>db2connecttotopicisuserdb2inst1usingdb2inst1數(shù)據(jù)庫(kù)連接信息SQL授權(quán)標(biāo)識(shí)=DB2INST1本地?cái)?shù)據(jù)庫(kù)別名=TOPICISC:\>db2catalogtcpipnodedssnoderemote4server50002//dssnode對(duì)應(yīng)dbsvr04主機(jī)DB20000ICATALOGTCPIPNODE命令成功完成。DB21056W直到刷新目錄高速緩存之后,目錄更改才生效。C:\>db2catalogdbtopicisasdssdbatnodedssnode//創(chuàng)建topicis別名為dssdbDB20000ICATALOGDATABASE命令成功完成。DB21056W直到刷新目錄高速緩存之后,目錄更改才生效。C:\>db2terminateDB20000ITERMINATE命令成功完成。C:\>db2connecttodssdbuserdb2inst1usingdb2inst1數(shù)據(jù)庫(kù)連接信息SQL授權(quán)標(biāo)識(shí)=DB2INST1本地?cái)?shù)據(jù)庫(kù)別名=DSSDB刪除用：db2uncatalogdbdssdbDb2uncatalognodedssnodedbsvr01上catalog:dbsvr01:$db2catalogtcpipnodedssnoderemote4server50002//dssnode對(duì)應(yīng)為dbsvr04DB20000ITheCATALOGTCPIPNODEcommandcompletedsuccessfully.DB21056WDirectorychangesmaynotbeeffectiveuntilthedirectorycacheisrefreshed.$db2catalogdbtopicisasdssdbatnodedssnode//創(chuàng)建topicis別名為dssdbDB20000ITheCATALOGDATABASEcommandcompletedsuccessfully.DB21056WDirectorychangesmaynotbeeffectiveuntilthedirectorycacheisrefreshed.$db2terminateDB20000ITheTERMINATEcommandcompletedsuccessfully.$dbsvr04上catalog:dbsvr04:$db2catalogdbtopicisasdssdbon/home/db2inst1//創(chuàng)建topicis別名為dssdbDB20000ITheCATALOGDATABASEcommandcompletedsuccessfully.DB21056WDirectorychangesmaynotbeeffectiveuntilthedirectorycacheisrefreshed.$db2terminateDB20000ITheTERMINATEcommandcompletedsuccessfully.$db2listdbdirectorySystemDatabaseDirectoryNumberofentriesinthedirectory=2Database1entry:Databasealias=TOPICISDatabasename=TOPICISLocaldatabasedirectory=/home/db2inst1Databasereleaselevel=d.00Comment=Directoryentrytype=IndirectCatalogdatabasepartitionnumber=0Alternateserverhostname=Alternateserverportnumber=Database2entry:Databasealias=DSSDBDatabasename=TOPICISLocaldatabasedirectory=/home/db2inst1Databasereleaselevel=d.00Comment=Directoryentrytype=IndirectCatalogdatabasepartitionnumber=0Alternateserverhostname=Alternateserverportnumber=$db2connecttodssdbDatabaseConnectionInformationSQLauthorizationID=DB2INST1Localdatabasealias=DSSDB5、用戶口令配置Dbsvr01:asnpwdinitasnpwdaddaliastopicisiddb2inst1passworddb2inst1asnpwdaddaliasdssdbiddb2inst1passworddb2inst1Dbsvr04:asnpwdinitasnpwdaddaliastopicisiddb2inst1passworddb2inst1asnpwdaddaliasdssdbiddb2inst1passworddb2inst16、db2復(fù)制中心：db2rc7.1capture模式創(chuàng)建7.2、Q預(yù)定創(chuàng)建7.3創(chuàng)建復(fù)制隊(duì)列映射7.4、APPLY模式創(chuàng)建7.5、Q預(yù)定單個(gè)啟動(dòng)與停止8、MQ相關(guān)腳本8.1Capture主機(jī)中的相關(guān)腳本。啟動(dòng)腳本：capture.sh:date#exportLD_LIBRARY_PATH=/usr/opt/db2_08_01/libexportLIBPATH=/usr/mqm/lib64:$LIBPATHexportLD_LIBRARY_PATH=$LIBPATHecho$LIBPATHecho$LD_LIBRARY_PATHasnqcapcapture_server=topiciscapture_schema=ASNcapture_path="/home/db2inst1/capture"PWDFILE=asnpwd.aut&#/usr/opt/db2_08_01/bin/asnqcapstartmode=COLD#capture_server=BTPDBScapture_schema=ASN1#capture_path="/home/db2inst1/capture_data"PWDFILE=asnpwd.aut停止腳本stop.sh:asnqccmdCAPTURE_SERVER=topicisCAPTURE_SCHEMA=ASNstop查看狀態(tài)腳本status.sh:asnqccmdCAPTURE_SERVER=topicisCAPTURE_SCHEMA=ASNstatus啟mqm腳本：Mqmstart.sh:strmqmQMSYSArunmqscQMSYSA<./startcomponent.mqscnohuprunmqlsr-ttcp-p1453-mQMSYSA&startcomponent.mqsc:STARTCHANNEL<'SYSAtoSYSB'>STARTCHANNEL<'SYSBtoSYSA'>END停mqm腳本：Mqmstop.sh:runmqscQMSYSA<./stopcomponent.mqscendmqlsr-w-mQMSYSAendmqm-iQMSYSAendmqm-pQMSYSAstopcomponent.mqsc:STOPCHANNEL<'SYSBtoSYSA'>MODE<FORCE>STOPCHANNEL<'SYSBtoSYSA'>MODE<FORCE>END8.2Apply主機(jī)中的相關(guān)腳本。啟動(dòng)腳本：apply.sh:date#exportLD_LIBRARY_PATH=/usr/opt/db2_08_01/lib#exportLIBPATH=/usr/lib:/lib:/usr/opt/db2_08_01/lib:/usr/mqm/libexportLIBPATH=/usr/mqm/lib64:$LIBPATHexportLD_LIBRARY_PATH=$LIBPATHecho$LIBPATHecho$LD_LIBRARY_PATHasnqappapply_server=dssdbapply_schema=ASNapply_path="/home/db2inst1/apply"PWDFILE=asnpwd.aut&停止腳本stop.sh:asnqacmdAPPLY_SERVER=dssdbAPPLY_SCHEMA=ASNstop查看狀態(tài)腳本status.sh:asnqacmdAPPLY_SERVER=dssdbAPPLY_SCHEMA=ASNstatus啟mqm腳本：Mqmstart.sh:strmqmQMSYSBrunmqscQMSYSB<./startcomponent.mqscnohuprunmqlsr-ttcp-p1454-mQMSYSB&startcomponent.mqsc:STARTCHANNEL<'SYSAtoSYSB'>STARTCHANNEL<'SYSBtoSYSA'>END停mqm腳本：Mqmstop.sh:runmqscQMSYSB<./stopcomponent.mqscendmqlsr-w-mQMSYSBendmqm-iQMSYSBendmqm-pQMSYSBstopcomponent.mqsc:STOPCHANNEL<'SYSBtoSYSA'>MODE<FORCE>STOPCHANNEL<'SYSBtoSYSA'>MODE<FORCE>END9、啟動(dòng)順序DB2與MQM啟動(dòng)順序Db2數(shù)據(jù)庫(kù)啟動(dòng)順序?yàn)?先啟動(dòng)hacmp集群中db2,啟動(dòng)MQ主機(jī)上的db2,啟動(dòng)MQ主機(jī)上的mq隊(duì)列與通道、監(jiān)聽(tīng)等。啟動(dòng)hacmp集群中db2主機(jī)上的mq隊(duì)列與通道、監(jiān)聽(tīng)等。啟動(dòng)MQ主機(jī)上的mq的apply.sh啟動(dòng)hacmp集群中db2主機(jī)上的mq的capture.sh10、相關(guān)信息總結(jié)ASN7137WMAX_MESSAGE_SIZE偏小程序名：程序標(biāo)識(shí)：發(fā)布或Q預(yù)訂名稱的指定MAX_MESSAGE_SIZE對(duì)于發(fā)送隊(duì)列隊(duì)列名和發(fā)布隊(duì)列映射或復(fù)制隊(duì)列映射queue_map_name可能太小?？赡苄枰笮∽止?jié)的最

大值。說(shuō)明發(fā)布隊(duì)列映射或復(fù)制隊(duì)列映射的MAX_MESSAGE_SIZE值〔用于指定此發(fā)送隊(duì)列可能太小,因此不能包括WebSphereMQ消息中的一行。如果QCapture程序在運(yùn)行時(shí)發(fā)生此問(wèn)題

,那么它將停止。用戶響應(yīng)增大隊(duì)列映射的MAX_MESSAGE_SIZE值。使用asnqacmdreinitq命令重新初始化隊(duì)列映射。alterqmgrMAXMSGL<104857600>db2"updateASN.IBMQREP_SENDQUEUESsetmax_message_size=8192"asnqacmdreinitqSendMQ:db2"updateASN.IBMQREP_SENDQUEUESsetmax_message_size=8192"alterqmgrMAXMSGL<104857600>alterql<SYSA.XMITQ>MAXMSGL<104857600>disql<SYSA.XMITQ>endReceiveMQ:db2"updateASN.IBMQREP_SENDQUEUESsetmax_message_size=8192"disql<SYSB.RECVQ>alterqmgrMAXMSGL<104857600>alterql<SYSB.RECVQ>MAXMSGL<104857600>endQ復(fù)制源表增加字段是不能傳輸?shù)侥繕?biāo)表的。復(fù)制源表增加字段是不能傳輸?shù)侥繕?biāo)表的,需要在目標(biāo)庫(kù)中也添加相同的字段,然后重新做Q預(yù)定即可。查看Q復(fù)制ASN系統(tǒng)表狀態(tài)信息：$db2listtablesforschemaasnTable/ViewSchemaTypeCreationtime$db2decribetableASN.IBMQREP_ADMINMSG$db2"select*fromASN.IBMQREP_ADMINMSG"查看schemaasn表內(nèi)容：db2listtablesforschemaasn11、關(guān)于Q復(fù)制故障排查步驟總結(jié)：11.1啟動(dòng)11.2查看工作狀態(tài)查看Q復(fù)制當(dāng)前狀態(tài)：asnqccmdAPPLY_SERVER=dssdbAPPLY_SCHEMA=ASNstatusshowdetailsasnqccmdCAPTURE_SERVER=topicisCAPTURE_SCHEMA=ASNstatusshowdetailsMQCAPTURE:$status.sh2010-02-26-10.12.08.181205ASN0600I"AsnQCcmd":"":"Initial":Program"mqpubcmd9.7.1"isstarting.2010-02-26-20162ASN0520I"AsnQCcmd":"ASN":"Initial":TheSTATUScomman