DB2's HADR feature utilizes ________ to synchronize data between primary and standby servers.
- Asynchronous replication
- Log shipping
- Mirroring
- Synchronous replication
DB2's HADR (High Availability Disaster Recovery) feature utilizes synchronous replication to synchronize data between the primary and standby servers. Synchronous replication ensures that changes made to the primary database are immediately replicated to the standby server, ensuring data consistency and minimizing the risk of data loss in the event of a disaster.
Loading...
Related Quiz
- Scenario: A developer is tasked with optimizing the performance of a complex query involving multiple joins on large tables. Suggest how creating appropriate indexes can improve query performance in this situation.
- The TIMESTAMP data type in DB2 stores ________ values.
- What is the purpose of using joins in DB2?
- When using the LOAD utility in DB2, the ________ option allows for loading data into multiple tables concurrently.
- A DBA notices a decline in query performance in a DB2 database. What steps can they take using the Runstats and Reorg utilities to improve performance?