
98 Unleashing DB2 10 for Linux, UNIX, and Windows
Configuring delayed log replay
To configure a standby system for delayed log replay, the DBAs must set the
hadr_replay_delay database configuration parameter. This configuration
parameter is specified in units of seconds. The DBAs decide a replay delay of
two hours is appropriate. The DBAs set the replay delay to two hours, which is
7200 seconds, as shown in Example 6-1.
Example 6-1 Setting the replay delay
UPDATE DB CFG FOR DB sales USING hadr_replay_delay 7200;
DEACTIVATE DB sales;
ACTIVATE DB sales;
To enable log spooling with unlimited spooling, the DBAs issue the command in
Example 6-2.
Example ...