13.17.6 Notes about using Real Time SAN Replication

If Real Time SAN Replication employs the hybrid processing method and any of the SQL statements listed in Table 13-11 is executed on a shared table, a synchronization wait occurs on the database for the remote site. This may result in an overhead of 2 or more seconds per SQL statement.

Table 13-11 SQL statements associated with synchronization wait at the remote site

Target SQL statementCondition
LOCK TABLEEXCLUSIVE mode
COMMITNone
ROLLBACK
DISCONNECT
CREATE TABLE
CREATE INDEX
DROP TABLE
DROP INDEX
ALTER TABLEChanging the number of reused segments

For details about how to restore the database at the remote site in the event that synchronization wait on the database fails at the remote site, see Error handling in the HiRDB Version 8 Disaster Recovery System Configuration and Operation Guide.