签到成功

知道了

CNDBA社区CNDBA社区

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

2021-10-06 09:31 1254 0 原创 QREP
作者： hbhe0316
本文链接：http://www.cndba.cn/hbhe0316/article/4864

1.源端启动capturehttp://www.cndba.cn/hbhe0316/article/4864

http://www.cndba.cn/hbhe0316/article/4864 

[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.源端查看capturehttp://www.cndba.cn/hbhe0316/article/4864

http://www.cndba.cn/hbhe0316/article/4864
http://www.cndba.cn/hbhe0316/article/4864 

[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.目标端查看applyhttp://www.cndba.cn/hbhe0316/article/4864

http://www.cndba.cn/hbhe0316/article/4864
http://www.cndba.cn/hbhe0316/article/4864
http://www.cndba.cn/hbhe0316/article/4864 

[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.源端停止capturehttp://www.cndba.cn/hbhe0316/article/4864

[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.目标端停止apply

[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

用户评论
* 以下用户言论只代表其个人观点，不代表CNDBA社区的观点或立场
hbhe0316

hbhe0316

关注

1.只有承认无知，才能装下新的东西； 2.进步来自一点点滴滴的积累； 3.广博让你更优秀，而专业让你无法替代； 4.挫折和失败能够转换为一种财富。

  • 889
    原创
  • 1
    翻译
  • 13
    转载
  • 24
    评论
  • 访问：1142239次
  • 积分：1523
  • 等级：核心会员
  • 排名：第6名
精华文章

    达梦数据库运维实战

    Oracle 18c 必须掌握的新特性：管理与实战

    Oracle数据库问题解决方案和故障排除手册
    最新问题
    查看更多+
    热门文章
      热门用户
      推荐用户
        友情链接： CNDBA社区 | openGauss | openEuler | openAnolis | 广告联系: database@ustc.edu
        Copyright © 2016 All Rights Reserved. Powered by CNDBA · 皖ICP备2022006297号-1·

        QQ交流群

        注册联系QQ