At my large sites, I use "log shipping" to replicate production
databases to a DR standby machine then use copydb/unloaddb from that
location when I need. One of the benefits of this arrangement is to be
able to rollforward the DR database to a point in time for analysis and
to assist reproducing transient problems.
clonedb and relocatedb cannot be used when users are connected.
clonedb/relocatedb can be used on a replicated database after the final
incremental journal is applied with:
rollforwarddb -c +j -incremental -rollback dbname
rollforwarddb -c +j -incremental_finish -rollback dbname
For more info see:
I can confirm log shipping replication works very well for non x100
databases on both Windows and Unix/Linux. Sorry I don't have any
experience replicating x100.
> Info-ingres mailing list