ChannelDB2

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.

Views: 160

Reply to This

Featured Downloads

Try BLU Acceleration on Cloud

© 2018   Created by channeldb2.   Powered by

Badges  |  Report an Issue  |  Terms of Service