Re: Help with Dbspaces & Chunks?

>Date: Thu, 14 Oct 1993 15:40:51 -0500 >From: puleo@Cayman.COM (Michael Puleo) >Subject: Help with Dbspaces & Chunks? >X-Informix-List-Id: <list.2945> > >I have a few questions about dbspaces and chunks. We are running informix >Online 4.00 on a Sun Sparc2. > >dbspaces: > >o Do you need more than one dbspace? No, but it can give you better control over which tables and databases use which disks. If you have only a single disk, then a single dbspace often makes more sense. >o Can you create just the rootdbs space and put all your tables and logs in it? Yes -- that's the default configuration. >o What are the advantages or disadvantages to having only one dbspace? If TableA is located in DbspaceB, it can't grow bigger than DbspaceB. Other tables located in DbspaceA will not be affected by TableA filling its dbspace up. In 6.0, the dbspace is the unit of archive and recovery -- multiple dbspaces will often be beneficial. >chunks: > >o We have a 200MB unix partition. In that partition is a 150MB chunk. Can we > add a new chunk in the remaining 50MB ? Yes: specify a size of 50M and the offset of 150M. >o Will the database automatically start using the new chunk when the old >one is full. Yes. >o Is it possible to reduce the partition using the unix format cmd, without > disturbing the database? No. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h>