06-18-07, 12:12 #1Registered User
- Join Date
- Jul 2006
- Pune , India
Unanswered: confusion regarding SQL Replication
suppose today is 10th and my Primary DB crashed
and i am having last offline image of Primary DB , say of 7th. of a month.
now i have restored my SRC DB with the image of 7th. , however my target DB is still running as it is.
now Dont we will be having a mismatch,
there maybe some data which is present in target DB(10th) which is not present in Source(7th)
how will DB2 cope with this situation
does it means that wheneven i m restoring the Source, i have to restore target also ??
what in case of restore from Online backup images ?
hope my question is clearRahul Singh
Certified DB2 9 DBA / Application Developer
06-18-07, 12:15 #2Registered User
- Join Date
- Jun 2006
if the target is a replica of source - to get them in synch is start a coldstart of capture and target will be refreshed
or restore the same db - start capture and start offline sync from replication center to reset the subscriptiption. as done is in sync no export import is neededBest Regards, Guy Przytula
DB2 UDB LUW certified V6/7/8