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

原创

wx62e28ac222a20 2022-08-04 11:07:33 ©著作权

文章标签 java linux zookeeper centos meta 文章分类 运维

©著作权归作者所有：来自51CTO博客作者wx62e28ac222a20的原创作品，请联系作者获取转载授权，否则将追究法律责任

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 details
2021-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 details
2021-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" stop
2021-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 details
2021-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" stop
2021-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 details
2021-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