on 09-26-2016 6:11 PM
to i just setup MSA replication ..
1) Database Replication definition
create database replication definition repdef_repcheck
with primary at DS_CTO.repcheck
2) subscription .
create subscription sub_repcheck
for database replication definition repdef_repcheck
with primary at DS_CTO.repcheck
with replicate at DS_STANDBY.repcheck
without materialization
subscribe to truncate table
>>>> Replication working fine but it was not replication DDL ...
3) Alter replication definition
alter database replication definition repdef_repcheck
with primary at DS_CTO.repcheck
replicate DDL
Now getting error :
Message from server: Message: 2762, State 3, Severity 16 -- 'The 'CREATE TABLE' command is not allowed within a multi-statement transaction in the 'repcheck' database.
'.
Do i need to do something on connection level ..
Thanks for your help ...
Thanks
Ajay Pandey
Looks it is working now ...
I did two thing not sure which one resolved ..
1) start and stop rep agent
2) truncated rs_lastcommit from target ...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
send warm standby xacts = true i did as part of MSA setup .
look like truncate of rs_lastcommit and stop /start rep agent helped .. not sure which helped..
But now working ..
Mark : Do you have manual step to setup MSA (start to end) . I had those steps long back but lost .
Current steup : i used rs_init for connections/repagent . and manual sp_reptostandby/send warm standby xacts /repdef/subscription ..
One more Help as in Rep 15.6 onward to Sync Replication database in warm standby :
A) Warm standby -- No need to drop and create connection etc for Sync
New option work very well ( 1 . stop repagent 2) suspend dsi connection 3)resume dsi with dsync marker 4)stop repegent with resync 5) dump/load 6) resume connection .
B) MSA -- database level -- Do we have anything like warmstandy as above or we need to drop subscription and create with dump marker ..
i was thing might be there is some thing new to avoid drop subscription etc like in warmstandby no need to drop connection in 15.6 onward . ...
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc32518.1571/doc/html/jer12... Seems same work for warstandby and MSA both ...
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.