Rollforward and database synchronization
Boubakar Saim Haddache
files, for example i backup the first database DBSRV1 and i restore it at
the second db server DBSRV2, and when i update the first database can i just
call the rollforward command at the second servers where the date is between
the date of the last synchronization and now ?
Boubakar
Thank you at advance
Kelly Rodger
this on the backup server. Then use a user exit from primary machine (or any
other method you wish) to copy the logs files from the primary machine to the
backup machine as they are archived.
On the secondary machine the database should be in ROLLFORWARD_PENDING state
after the initial restore so just periodically ROLLFORWARD TO END OF LOGS as the
log files are shipped over. The key to making this work is to realize that the
STOP (or COMPLETE) option on the rollforward command will clear the
ROLLFORWARD_PENDING state. Since you want to continually roll forward, do not
use this option until you want to stop the synchronization.
Hope that helps.
kdr
Boubakar Saim Haddache wrote:
--
//---------------------------------------------------------------------------
// Kelly D. Rodger -- DB2 Universal Database Development -- Backup & Recovery
//---------------------------------------------------------------------------
Michael Bhola
you can transfer them to the second db server and rollforward to end of
logs. As long as you never come out of rollforward you can continue to just
keep issuing rollforward to end of logs. But bear in mind that the database
at the second database server is inaccessible until you rollforward stop at
which point you then lose the ability to synchronize. A similar technique
using split mirror ) is described in the 7.2 releaes notes.
"Boubakar Saim Haddache" <bs...@otoobe.com> wrote in message
news:9i21cu$1682$1...@news4.isdnet.net...
Boubakar Saim Haddache
Logs of the first database, i get a message that the database DBSRV2 is not
in Rollforward pending. How can i do ? because if i let the database DBSRV2
in a rollforward pending state, i can't connect to it ?
Thank you
"Kelly Rodger" <kro...@ca.ibm.com> a écrit dans le message news:
3B449D82...@ca.ibm.com...
file://---------------------------------------------------------------------
------
> // Kelly D. Rodger -- DB2 Universal Database Development -- Backup &
Recovery
>
file://---------------------------------------------------------------------
------
>
>
Michael Bhola
split ) and will be inaccessible until you bring it out of rollforward
pending. At this point you can no longer synchronize.
The idea behind this procedure is not to have 2 systems which are
simultaneously accessible, it is to have a stand-by system that is ready and
waiting and will only be made accessible ( ie. brought out of rollforward
pending ) when the primary system fails.
If you want the 2 systems to be simultaneously available then you should
look at data replication ( DPropR).
"Boubakar Saim Haddache" <bs...@otoobe.com> wrote in message
news:9ic1bb$2bu$1...@news2.isdnet.net...
Boubakar Saim Haddache
rollforwading to synchrnize two databases, and to using the two databases at
the same times. So the lonly way to synchronize 2 databases and use the 2
dbs is to use DPropR.
Boubakar
Thank you
"Michael Bhola" <bho...@uk.ibm.com> a écrit dans le message news:
9ici9t$2ga2$1...@sp15at20.hursley.ibm.com...
Michael Bhola
> Thank you Michael, so if i understand, their is no way to use
> rollforwading to synchrnize two databases, and to using the two databases
at
> the same times. So the lonly way to synchronize 2 databases and use the 2
> dbs is to use DPropR.
>
>
> Boubakar
>
> Thank you
Yes. This is the only way I know using the products supplied with DB2. There
may be other 3rd party products...