IBM Q复制启动停止查看状态

IBM Q复制启动停止查看状态

1.源端启动capture

[db2inst1@node02 scripts]$ cd /home/db2inst1/scripts[db2inst1@node01 ~]$ nohup asnqcap capture_server="DB110" capture_schema="ASN" capture_path="/home/db2inst1/scripts" startmode=cold &

2.目标端启动APPly

[db2inst1@node02 scripts]$ cd /home/db2inst1/scripts[db2inst1@node02 scripts]$ nohup asnqapp apply_server="DB111" apply_schema="ASN" apply_path="/home/db2inst1/scripts" &

3.源端查看capture

[db2inst1@node02 scripts]$ cd /home/db2inst1/scripts[db2inst1@node01 ~]$ asnqccmd capture_server="DB110" capture_schema="ASN" status show details2021-10-06-09.03.05.275143 ASN0600I "AsnQCcmd" : "" : "Initial" : Program "mqpubcmd 11.4.0 (Build 11.1.4.6 Level s2102191900, PTF DYN2102191900AMD64)" is starting.Q Capture program status Server name (SERVER) = DB110 Schema name (SCHEMA) = ASN Program status (STATUS) = Up Time since program started (UP_TIME) = 0d 0h 0m 8s Log file location (LOGFILE) = /home/db2inst1/scripts/db2inst1.DB110.ASN.QCAP.log Number of active Q subscriptions (ACTIVE_QSUBS) = 0 Log reader currency (CURRENT_LOG_TIME) = 1970-01-01-08.00.00.000000 Last committed transaction published (LSN) (ALL_PUBLISHED_AS_OF_LSN) = 0000:0000:0000:198F:0000:0000:0004:3D48 Current application memory (CURRENT_MEMORY ) = 0 bytes Path to database log files (DB2LOG_PATH) = /db2log/NODE0000/LOGSTREAM0000/ Oldest database log file needed for Q Capture restart (OLDEST_DB2LOG) = Run this command: "/home/db2inst1/sqllib/bin/db2flsn -q -db DB110 0000000000043d48" as a user with read permission to the log files. Current database log file captured (CURRENT_DB2LOG) = Run this command: "/home/db2inst1/sqllib/bin/db2flsn -q -db DB110 0000000000043d4c" as a user with read permission to the log files.

4.目标端查看apply

[db2inst1@node02 scripts]$ cd /home/db2inst1/scripts[db2inst1@node02 scripts]$ asnqacmd apply_server="DB111" apply_schema="ASN" status show details2021-10-06-09.02.00.439858 ASN0600I "AsnQAcmd" : "" : "Initial" : Program "asnqacmd 11.4.0 (Build 11.1.4.6 Level s2102191900, PTF DYN2102191900AMD64)" is starting.Q Apply program status Server name (SERVER) = DB111 Schema name (SCHEMA) = ASN Program status (STATUS) = Up Time since program started (UP_TIME) = 0d 0h 0m 34s Log file location (LOGFILE) = /home/db2inst1/scripts/db2inst1.DB111.ASN.QAPP.log Number of active Q subscriptions (ACTIVE_QSUBS) = 0 Time period used to calculate average (INTERVAL_LENGTH) = 0h 0m 2.11s Receive queue : ASN.DB110_TO_ASN.DB111.DATA Number of active Q subscriptions (ACTIVE_QSUBS) = 0 All transactions applied as of (time) (OLDEST_TRANS) = 1900-01-01-00.00.00.000000 Restart point for Q Capture (MAXCMTSEQ) (MAXCMTSEQ) = 0000:0000:0000:0000:0000:0000:0000:0000 All transactions applied as of (LSN) (ALL_APPLIED_AS_OF_LSN) = 0000:0000:0000:0000:0000:0000:0000:0000 Oldest in-progress transaction (OLDEST_INFLT_TRANS) = 1900-01-01-00.00.00.000000 Average end-to-end latency (END2END LATENCY) = 0h 0m 0.0s Average Q Capture latency (CAPTURE_LATENCY) = 0h 0m 0.0s Average WSMQ latency (QLATENCY) = 0h 0m 0.0s Average Q Apply latency (APPLY_LATENCY) = 0h 0m 0.0s Current memory (CURRENT_MEMORY ) = 0 Bytes Current queue depth (QDEPTH) = 0 Current queue percentage full (Q_PERCENT_FULL) = 0% Agents processing transaction (PROCESSING_TRANSACTION) = NONE Agents waiting for transaction (WAITING_FOR_TRANSACTION) = BR00000AG001, BR00000AG002, BR00000AG003, BR00000AG004, BR00000AG005, BR00000AG006, BR00000AG007, BR00000AG008, BR00000AG009, BR00000AG010, BR00000AG011, BR00000AG012, BR00000AG013, BR00000AG014, BR00000AG015, BR00000AG016 Agents processing internal messages (PROCESSING_INTERNAL_MESSAGES) = NONE Agents in initializing state (INITIALIZING) = BR00000SP001

5.源端停止capture

[db2inst1@node02 scripts]$ cd /home/db2inst1/scripts[db2inst1@node02 scripts]$ asnqccmd capture_server="DB110" capture_schema="ASN" stop2021-10-06-09.29.13.660373 ASN0600I "AsnQCcmd" : "" : "Initial" : Program "mqpubcmd 11.4.0 (Build 11.1.4.6 Level s2102191900, PTF DYN2102191900AMD64)" is starting.2021-10-06-09.29.15.684275 ASN0522I "AsnQCcmd" : "ASN" : "Initial" : The program received the "STOP" command.[db2inst1@node01 ~]$ asnqccmd capture_server="DB110" capture_schema="ASN" status show details2021-10-06-09.29.22.998417 ASN0600I "AsnQCcmd" : "" : "Initial" : Program "mqpubcmd 11.4.0 (Build 11.1.4.6 Level s2102191900, PTF DYN2102191900AMD64)" is starting.2021-10-06-09.29.31.066669 ASN0506E "AsnQCcmd" : "ASN" : "Initial" : The command was not processed because the target replication program "Q Capture" was not running or because you entered an incorrect parameter value (for example, a server name, schema, or qualifier might be misspelled).Q Capture program status Server name (SERVER) = DB110 Schema name (SCHEMA) = ASN Program status (STATUS) = Down[1]+ Done nohup asnqcap capture_server="DB110" capture_schema="ASN" capture_path="/home/db2inst1/scripts" startmode=cold

6.目标端停止

[db2inst1@node02 scripts]$ cd /home/db2inst1/scripts[db2inst1@node02 scripts]$ asnqacmd apply_server="DB111" apply_schema="ASN" stop2021-10-06-09.29.54.641910 ASN0600I "AsnQAcmd" : "" : "Initial" : Program "asnqacmd 11.4.0 (Build 11.1.4.6 Level s2102191900, PTF DYN2102191900AMD64)" is starting.2021-10-06-09.29.56.672457 ASN0522I "AsnQAcmd" : "ASN" : "Initial" : The program received the "STOP" command.[db2inst1@node02 ~]$ asnqacmd apply_server="DB111" apply_schema="ASN" status show details2021-10-06-09.30.02.441762 ASN0600I "AsnQAcmd" : "" : "Initial" : Program "asnqacmd 11.4.0 (Build 11.1.4.6 Level s2102191900, PTF DYN2102191900AMD64)" is starting.2021-10-06-09.30.10.480006 ASN0506E "AsnQAcmd" : "ASN" : "Initial" : The command was not processed because the target replication program "Q Apply" was not running or because you entered an incorrect parameter value (for example, a server name, schema, or qualifier might be misspelled).Q Apply program status Server name (SERVER) = DB111 Schema name (SCHEMA) = ASN Program status (STATUS) = Down

QREP

版权声明：本文内容由网络用户投稿，版权归原作者所有，本站不拥有其著作权，亦不承担相应法律责任。如果您发现本站中有涉嫌抄袭或描述失实的内容，请联系我们jiasou666@gmail.com 处理，核实后本网站将在24小时内删除侵权内容。