I have created a new subscription for the one table, and i can state of that table as N in one side and other side i can see state as I , I could not find what mistake i made in creating those...
this is BIDIRECTIONAL setup
Here are my steps
1) create mq objects.
ASNCLP SESSION SET TO Q REPLICATION;
CREATE MQ SCRIPT CONFIG TYPE B
MQSERVER 1 NAME TESTA MQHOST hostname MQPORT 2414 QMANAGER ASNTA QNAME_QUAL ASNTA,
MQSERVER 2 NAME TESTB MQHOST hostname MQPORT 2415 QMANAGER ASNTB QNAME_QUAL ASNTB;
ASNCLP SESSION SET TO Q REPLICATION;
CREATE MQ SCRIPT CONFIG TYPE B
MQSERVER 1 NAME TESTA MQHOST hostname MQPORT 2414 QMANAGER ASNTA QNAME_QUAL ASNTA,
MQSERVER 2 NAME TESTB MQHOST hostname MQPORT 2415 QMANAGER ASNTB QNAME_QUAL ASNTB;
2) setup active active relication
ASNCLP SESSION SET TO Q REPLICATION;
SET OUTPUT MULTIDIR;
SET RUN SCRIPT RUN NOW STOP ON SQL ERROR ON;
SET BIDI NODE 1 SERVER DBALIAS TESTA ID "db2inst1" PASSWORD "db2inst1" SCHEMA ASNTA;
SET BIDI NODE 2 SERVER DBALIAS TESTB ID "db2inst1" PASSWORD "db2inst1" SCHEMA ASNTB;
CREATE CONTROL TABLES FOR NODE 1;
CREATE CONTROL TABLES FOR NODE 2;
CREATE REPLQMAP "TESTA.ASNTA_TO_TESTB.ASNTB" (NODE 1, NODE 2);
CREATE REPLQMAP "TESTB.ASNTB_TO_TESTA.ASNTA" (NODE 2, NODE 1);
SET TABLES(NODE 1 "DBA");
CREATE QSUB SUBTYPE B FROM NODE TESTA.ASNTA SOURCE HAS LOAD PHASE I TARGET LOAD TYPE 0;
Below is what i see the state when quered.
db2inst1@sairam:~/scripts$ db2 "select subname,state from asnta.ibmqrep_subs"
SUBNAME STATE
------------------------------------------------------------------------------------------------------------------------------------ -----
DBA0001 N
1 record(s) selected.
db2inst1@sairam:~/scripts$
db2inst1@sairam:~/scripts$ db2 connect to testb
Database Connection Information
Database server = DB2/LINUXX8664 9.7.6
SQL authorization ID = DB2INST1
Local database alias = TESTB
db2inst1@sairam:~/scripts$ db2 "select subname,state from asntb.ibmqrep_subs"
SUBNAME STATE
------------------------------------------------------------------------------------------------------------------------------------ -----
DBA0002 I
1 record(s) selected.
Tags:
© 2021 Created by channeldb2.
Powered by