xxx工商局db2-q復(fù)制配置維護(hù)手冊(cè)-在線瀏覽
2024-09-05 15:05本頁(yè)面
【正文】 icis別名為dssdbDB20000I The CATALOG DATABASE mand pleted successfully.DB21056W Directory changes may not be effective until the directory cache is refreshed.$ db2 terminateDB20000I The TERMINATE mand pleted successfully.$ dbsvr04上catalog:dbsvr04:$ db2 catalog db topicis as dssdb on /home/db2inst1 //創(chuàng)建topicis別名為dssdbDB20000I The CATALOG DATABASE mand pleted successfully.DB21056W Directory changes may not be effective until the directory cache is refreshed.$ db2 terminateDB20000I The TERMINATE mand pleted successfully.$ db2 list db directory System Database Directory Number of entries in the directory = 2Database 1 entry: Database alias = TOPICIS Database name = TOPICIS Local database directory = /home/db2inst1 Database release level = Comment = Directory entry type = Indirect Catalog database partition number = 0 Alternate server hostname = Alternate server port number =Database 2 entry: Database alias = DSSDB Database name = TOPICIS Local database directory = /home/db2inst1 Database release level = Comment = Directory entry type = Indirect Catalog database partition number = 0 Alternate server hostname = Alternate server port number =$ db2 connect to dssdb Database Connection Information Database server = DB2/AIX64 SQL authorization ID = DB2INST1 Local database alias = DSSDB用戶口令配置Dbsvr01:asnpwd initasnpwd add alias topicis id db2inst1 password db2inst1asnpwd add alias dssdb id db2inst1 password db2inst1Dbsvr04:asnpwd initasnpwd add alias topicis id db2inst1 password db2inst1asnpwd add alias dssdb id db2inst1 password db2inst1db2復(fù)制中心：db2rc capture模式創(chuàng)建 、Q預(yù)定創(chuàng)建 、APPLY模式創(chuàng)建 、Q預(yù)定單個(gè)啟動(dòng)與停止 MQ相關(guān)腳本 Capture主機(jī)中的相關(guān)腳本。/usr/opt/db2_08_01/bin/asnqcap startmode=COLD capture_server=BTPDBS capture_schema=ASN1 capture_path=/home/db2inst1/capture_data PWDFILE=:asnqccmd CAPTURE_SERVER=topicis CAPTURE_SCHEMA=ASN stop:asnqccmd CAPTURE_SERVER=topicis CAPTURE_SCHEMA=ASN status啟mqm腳本：:strmqm QMSYSArunmqsc QMSYSA ./nohup runmqlsr t tcp p 1453 m QMSYSA amp。SYSAtoSYSB39。SYSBtoSYSA39。SYSBtoSYSA39。SYSBtoSYSA39。啟動(dòng)腳本：:dateexport LD_LIBRARY_PATH=/usr/opt/db2_08_01/libexport LIBPATH=/usr/lib:/lib:/usr/opt/db2_08_01/lib:/usr/mqm/libexport LIBPATH=/usr/mqm/lib64:$LIBPATHexport LD_LIBRARY_PATH=$LIBPATHecho $LIBPATHecho $LD_LIBRARY_PATHasnqapp apply_server=dssdb apply_schema=ASN apply_path=/home/db2inst1/apply PWDFILE= amp。:START CHANNEL(39。)START CHANNEL(39。)END停mqm腳本：:runmqsc QMSYSB ./endmqlsr w m QMSYSBendmqm i QMSYSBendmqm p QMSYSB:STOP CHANNEL(39。) MODE(FORCE)STOP CHANNEL(39。) MODE(FORCE)END啟動(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 相關(guān)信息總結(jié)ASN7137W MAX_MESSAGE_SIZE偏小程序名：程序標(biāo)識(shí)：發(fā)布或 Q 預(yù)訂 名稱 的指定 MAX_MESSAGE_SIZE 對(duì)于發(fā)送隊(duì)列 隊(duì)列名 和發(fā)
環(huán)評(píng)公示相關(guān)推薦
鄂ICP備17016276號(hào)-1