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 statement | Condition |
---|---|
LOCK TABLE | EXCLUSIVE mode |
COMMIT | None |
ROLLBACK | |
DISCONNECT | |
CREATE TABLE | |
CREATE INDEX | |
DROP TABLE | |
DROP INDEX | |
ALTER TABLE | Changing 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.