P
pkoufalis
Guest
The easiest solution is to combine the DBs into one. With modern versions of Progress and Type II storage areas, the need for multiple DBs is more difficult to justify. And you don't need much code change: just add DB aliases in your startup program. The only hiccup I can see is if you have the same table name in multiple DBs. Your point #2 sounds like a programming/architecture weakness. No one can help you with that. To answer your questions: You cannot ensure LOGICAL data integrity across databases with online backup nor with AI if you don't have 2PC enabled. In practice, you can restore and roll forward to the same point in time and cross your fingers that a multi-DB transaction didn't commit in one DB but not in the other at that very exact second. Paul Koufalis Progresswiz informatique
Continue reading...
Continue reading...