Nonstop Database, HiRDB Version 9 Disaster Recovery System Configuration and Operation Guide

[Contents][Index][Back][Next]

8.7 Notes on using a shared table (applicable only to the hybrid method)

If any of the SQL statements shown in the table below are executed on a shared table when the hybrid method of Real Time SAN Replication is used, the system waits for the database to be synchronized at the remote site. Therefore, an overhead of at least 2 seconds may occur for each SQL statement.

Table 8-6 SQL that causes the system to wait for synchronization to the remote site

Target SQL Condition
LOCK TABLE EXCLUSIVE mode
COMMIT No condition
ROLLBACK
DISCONNECT
CREATE TABLE
CREATE INDEX
DROP TABLE
DROP INDEX
ALTER TABLE Change in the number of segments reused

For details about how to recover the database at the remote site when a pended synchronization of the database at the remote site fails, see 6. Error Handling.