Nonstop Database, HiRDB Version 9 Disaster Recovery System Configuration and Operation Guide
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.
All Rights Reserved. Copyright (C) 2011, Hitachi, Ltd.