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.
About this task
There are several ways to initialize the standby database.
For example:
Procedure
- 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.
What to do next
After initializing the standby database, you must configure
your database solution to synchronize the primary database and standby
database so the standby database can take over for the primary database
if the primary database fails.
DB2 Version 9.7 for Linux, UNIX, and Windows