xxx工商局db2-q復(fù)制配置維護(hù)手冊-資料下載頁
2025-07-26 15:05本頁面
【正文】 用戶響應(yīng)增大隊(duì)列映射的 MAX_MESSAGE_SIZE 值。使用 asnqacmd reinitq 命令重新初始化隊(duì)列映射。alter qmgr MAXMSGL(104857600)db2 update set max_message_size = 8192asnqacmd reinitqSendMQ:db2 update set max_message_size = 8192alter qmgr MAXMSGL(104857600)alter ql() MAXMSGL(104857600)dis ql() endReceiveMQ:db2 update set max_message_size = 8192dis ql()alter qmgr MAXMSGL(104857600) alter ql() MAXMSGL(104857600)endQ復(fù)制源表增加字段是不能傳輸?shù)侥繕?biāo)表的。復(fù)制源表增加字段是不能傳輸?shù)侥繕?biāo)表的，需要在目標(biāo)庫中也添加相同的字段，然后重新做Q預(yù)定即可。查看 Q復(fù)制ASN系統(tǒng)表狀態(tài)信息：$ db2 list tables for schema asnTable/View Schema Type Creation time IBMQREP_ADMINMSG ASN T IBMQREP_CAPENQ ASN T IBMQREP_CAPENVINFO ASN T IBMQREP_CAPMON ASN T IBMQREP_CAPPARMS ASN T IBMQREP_CAPQMON ASN T IBMQREP_CAPTRACE ASN T IBMQREP_IGNTRAN ASN T IBMQREP_IGNTRANTRC ASN T IBMQREP_SENDQUEUES ASN T IBMQREP_SIGNAL ASN T IBMQREP_SRCH_COND ASN T IBMQREP_SRC_COLS ASN T IBMQREP_SUBS ASN T $ db2 decribe table $ db2 “select * from ASN. IBMQREP_ADMINMSG”查看schema asn表內(nèi)容：db2 list tables for schema asn1關(guān)于Q復(fù)制故障排查步驟總結(jié)：查看Q復(fù)制當(dāng)前狀態(tài)：asnqccmd APPLY_SERVER=dssdb APPLY_SCHEMA=ASN status show detailsasnqccmd CAPTURE_SERVER=topicis CAPTURE_SCHEMA=ASN status show detailsMQ CAPTURE:$ ASN0600I AsnQCcmd : : Initial : Program mqpubcmd is starting. ASN0520I AsnQCcmd : ASN : Initial : The STATUS mand response: HoldLThread thread is in the is waiting state. ASN0520I AsnQCcmd : ASN : Initial : The STATUS mand response: AdminThread thread is in the is resting state. ASN0520I AsnQCcmd : ASN : Initial : The STATUS mand response: PruneThread thread is in the is resting state. ASN0520I AsnQCcmd : ASN : Initial : The STATUS mand response: WorkerThread thread is in the is doing work state.MQ APPLY:$ ASN0600I AsnQAcmd : : Initial : Program asnqacmd is starting. ASN0520I AsnQAcmd : ASN : Initial : The STATUS mand response: HoldLThread thread is in the is waiting state. ASN0520I AsnQAcmd : ASN : Initial : The STATUS mand response: AdminThread thread is in the is resting state. ASN0520I AsnQAcmd : ASN : Initial : The STATUS mand response: MonitorThread thread is in the is resting state. ASN0520I AsnQAcmd : ASN : Initial : The STATUS mand response: BR00000 thread is in the is doing work state.；ps ef|grep runmqlsr 查看監(jiān)聽狀態(tài)ps ef|grep 1453查看當(dāng)前監(jiān)聽端口狀態(tài)查看Q復(fù)制相關(guān)端口狀態(tài)信息：$ netstat an|grep 1453tcp 0 0 *.1453 *.* LISTENtcp4 0 0 ESTABLISHED$ netstat an|grep 1454tcp4 0 0 ESTABLISHED$Runmqsc QMSYSAdis chstatus(‘SYSBtoSYSA’)dis chstatus(‘SYSAtoSYSB’)dis chstatus(*)
環(huán)評公示相關(guān)推薦
鄂ICP備17016276號(hào)-1