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".

What is that i need to start my capture program, if i say No load option for Q replication

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.