I strongly discourage anyone from putting 'user' objects
(i.e. databases, tables, indexes etc.) in the rootdbs.
The rootdbs is a 'critical' dbspace wrt to recovery. Also
the logical and/or physical logs are often located there
(if you haven't moved them).
So, best avoid it for user stuff.
Denham.M@amstr.com wrote:
> Thought i'd start a discussion of this subject. Anyone out there
> got any strong views either way?
>
> My own view is that creating the dbs in the rootdbs is a bad idea
> since this then becomes the default location for all tables created
> for the database, and can lead to the rootdbs becoming clogged....
>
> For the same reason I would generally frown on creating tables in
> this space deliberately.
>
> Does anyone know if there are any performance benefits from doing
> it one way or the other?
--
------------------------------------------------------------
Chris Jenkins, Advanced Technology Group, Informix Software
Standard disclaimers apply