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 (AT) yahoo (DOT) com> wrote: