I'm trying to figure out if there's way to replicate a subset of tables (columns) from HADR Standby, with ROS enabled. Latency of O(10) sec can be tolerated. We are using luw (linux) V10.5FP8 right now and will upgrade to V11 at some point.
I understand the read-only limitation on HADR Standby, and that eliminates some options, eg. QRepl / infosphere CDC, which write monitoring/metadata back to source.
Furthermore, assuming we still limit ourselves to db2 heterogeneous env and the repl user have read access to all the tables/columns, is there a replication tool that doesn't depends on constant source db connection? Meaning such tool only scans transaction log files, and writes to its own external metadata/file, without bothering with source db at all? It would be even better if it can capture once, and replay in multiple targets.
Really appreciate your inputs.
Rui Chen[Organization Members] @ Oct 17, 2017 - 12:12 PM (America/Eastern)
Rui Chen[Organization Members] @ Oct 17, 2017 - 12:14 PM (America/Eastern)
Rui Chen[Organization Members] @ Oct 17, 2017 - 01:44 PM (America/Eastern)