Database per dbspace scheme

I want to place one database per dbspace so that I can easily restore an individual database by using onbar to restore a single dbspace. Why will this not work?

It will sort-of work. Here are the caviats as I see them: - You will also have to restore the root dbspace if the server is down or you are doing this to port a database to another machine. - You will have to rollforward all logical logs to bring the dbspace up-to-date with the rest of the server. You can't successfully restore a single dbspace to an earlier point than the rest of the server. So, depending on what you want dbspace level restores to do for you determines whether restricting a dbspace to hold a single database it will work for you. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Tue, Jun 28, 2011 at 4:16 PM, red_valsen <red_valsen@yahoo.com> wrote: > I want to place one database per dbspace so that I can easily restore > an individual database by using onbar to restore a single dbspace. > Why will this not work? > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >