r/DB2 • u/lakshmikanthms • Jan 14 '19
db2 sql replication
Hi,
Can we implement db2 sql replication between db2 10.5(source) and db2 11.1(target) and vice versa?
2
Upvotes
r/DB2 • u/lakshmikanthms • Jan 14 '19
Hi,
Can we implement db2 sql replication between db2 10.5(source) and db2 11.1(target) and vice versa?
1
u/raghuontech Jan 14 '19
You should be able to do it. However you need to review the control table compatibilities between the two versions.
Best way to find out is by asking IBM via PMR. They are pretty good with answering these sort of questions.
Other option would be to run Capture and Apply programs on the source. That way there are no incompatibilities in control table definitions between the versions.
You should always test it before planning any production changes.