Re: standby db on windows I mess up typing the db2 version. I got Workgroup unlimited Edition
(WUE)and that one doesn't have HADR.
I also read about HADR, and sound pretty good solution, but
unfortunatelly the project doesn't have any budget.
I know are many ways of upgrading logs to the standby, last thing I
tryed was this:
db2 => RESTORE DATABASE BD FROM C:\BACKUPS
DB20000I The RESTORE DATABASE command completed successfully.
--archive log for datbase BD on machine A
db2 => ROLLFORWARD DB BD TO END OF LOGS
Rollforward Status
Input database alias = BD
Number of nodes have returned status = 1
Node number = 0
Rollforward status = DB working
Next log file to be read = S0018146.LOG
Log files processed = -
Last committed transaction = 2005-04-15-08.32.05.000000
DB20000I The ROLLFORWARD command completed successfully.
--Made some change on db B and also call archive log command
db2 => ROLLFORWARD DB BD TO END OF LOGS
SQL1265N The archive log file "S0018147.LOG" is not associated with
the
current log sequence for database "BD" on node "0".
Any sugestions or manuals to do a stuff like this?
Thanks |