Initializing a standby database
One strategy for making a database
solution highly available is maintaining a primary database to respond
to user application requests, and a secondary or standby database
that can take over database operations for the primary database if
the primary database fails.
Initializing the standby
database entails copying the primary database to the standby database.
Procedure
There are several ways to initialize the standby database. For example:
- Use disk mirroring to copy the primary database, and use Db2® database suspended I/O support to split the mirror to create the second database.
- Create a backup image of the primary database and recovery that image to the standby database.
- Use SQL replication to capture data from the primary database and apply that data to the standby database.