Results 1 to 3 of 3

Thread: Q replication

  1. #1
    Join Date
    Mar 2005
    Posts
    40

    Unanswered: Need Help using No load option for Q replication

    Hi Team, Need your help i am working to set up peer to peer Q 3 way bi directional replication, i created the 3 databases from the same Back up copy, so i choose No load option for Q replication, now all my all of my capture Subscriptions are in Inactive state, While i started my capture program i choose for WARMSI because it fails if i start it with WARMNS, so i looked at the capturelog it says it is going in coldstart...

    All of my setup is done now how to i tell the capture and apply to start without any load, what am i doing wrong thanks for your help ....

    I see this in my Capture Log
    2008-02-28-17.41.10.859000 <Asnenv:setEnvIpcQRcvHdl> ASN0553W "Q Capture" : "ASN" : "Initial" : An internal error "4" occurred for message number "594" containing "1" substitution fields: "(Global\OSSEIPC48tempDB2.W402TJ04.ASN.QCAP.IP C, Global\OSSEIPC49tempDB2.W402TJ04.ASN.QCAP.IPC, Global\OSSEIPC50tempDB2.W402TJ04.".
    2008-02-28-17.41.10.906000 <ASNMQLOD:MQCONN> ASN0553W "Q Capture" : "ASN" : "Initial" : An internal error "4" occurred for message number "585" containing "2" substitution fields: "mqm.dll", "".
    2008-02-28-17.41.11.171000 <asnqcap::main> ASN7131I "Q Capture" : "ASN" : "Initial" : The Q Capture program will switch to cold start because the warm start information is not found.
    2008-02-28-17.41.11.312000 <asnqwk> ASN7108I "Q Capture" : "ASN" : "WorkerThread" : At program initialization, the highest log sequence number of a successfully processed transaction is "47C6:73A7:0000:0000:0000" and the lowest log sequence number of a transaction still to be committed is "0000:0000:0035:0FD1:000C".
    2008-02-28-17.41.11.468000 <subMgr:rocessSubscriptions> ASN7000I "Q Capture" : "ASN" : "WorkerThread" : "0" subscriptions are active. "162" subscriptions are inactive. "0" subscriptions that were new and were successfully activated. "0" subscriptions that were new could not be activated and are now inactive.
    2008-02-28-17.41.11.531000 <asnqwk> ASN0572I "Q Capture" : "ASN" : "WorkerThread" : The program initialized successfully.
    2008-02-28-17.51.28.312000 <cmdsEngine> ASN0553W "Q Capture" : "ASN" : "Initial" : An internal error "4" occurred for message number "592" containing "1" substitution fields: "(Global\OSSEIPC48tempDB2.W402TJ04.ASN.QCAP.IPC.CM D2592, Global\OSSEIPC49tempDB2.W402TJ04.ASN.QCAP.IPC.CMD2 592, Global\OSSEIPC50t".
    2008-02-28-17.51.28.312000 <cmdsEngine> ASN0553W "Q Capture" : "ASN" : "Initial" : An internal error "4" occurred for message number "593" containing "1" substitution fields: "(Global\OSSEIPC48tempDB2.W402TJ04.ASN.QCAP.IPC.CM D2592, Global\OSSEIPC49tempDB2.W402TJ04.ASN.QCAP.IPC.CMD2 592, Global\OSSEIPC50t".
    Last edited by ugrasena; 02-28-08 at 21:58.

  2. #2
    Join Date
    Mar 2005
    Posts
    40
    What is that i need to start my capture program, if i say No load option for Q replication

  3. #3
    Join Date
    Apr 2007
    Posts
    21
    You need to update the following columns in IBMSNAP_RESTART table:

    MIN_INFLIGHTSEQ - this column indicates the LRSN or RBA value from which the Capture will restart

    CURR_COMMIT_TIME - update to current timestamp


    Stop Full-refresh:

    In the Capture Control server IBMSNAP_REGISTER table SET DISABLE_REFRESH = 1; this prevents full-load to the target tables.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •