Re: Questions about managment of dbspaces

"Alexander J. Oss" <alex.oss@films.com> wrote: >In article <41g1do$40i@dub-news-svc-1.compuserve.com>, ><102110.3554@compuserve.com> writes: >> 1) What is the purpose of the dbspace in OnLine DSA 7.1 ? There are a number of uses to which DBspaces are put. A major feature is the ability in the version you are using to do warm restores of a specific dbspace without downing the entire system. If you have a set of Administation manuals for 7.10 they can give you a good deal more detail on the use of a DBspace. >> >> 2) When would it make sense to put multiple databases in the same dbspace, >> and what are the potential disadvatages? >I know one disadvantage we discovered the hard way: you can't have tables in >different databases with referential constraints between them. This yields >error -295 (do a finderr on it...). We had planned on doing a lot of logical >grouping into databases, reaching out referentially when needed, but... ><grimace>. This is true with 5.01... hey, maybe they changed it, you never >know. Anwering the above. First of all your comment has nothing to do with dbspaces, it has to do with databases. secondly, As far as I am aware what you were trying to do is not part of the ansi standard and even if it was would be a dumb idea. If you want to logically model your database then use a modelling tool. This kind of thinking is on a par with so-called intelligent coding of keys, which is a misnomer - They should be called stupid keys. Peter Tashkoff Auckland, New Zealand e-mail ptash@iconz.co.nz