RE: Dbspaces spanning multiple disks.

Whoops, Amendment in order. You will not reclaim the INDEX space without index rebuilds. Scott H. > ---------- > From: Henderson, Scott[SMTP:SHenderson@purolator.com] > Sent: Thursday, January 06, 2000 5:00 PM > To: 'informix-list@iiug.org'; 'Howard, Paul' > Subject: RE: Dbspaces spanning multiple disks. > > Paul, > > Is the data quite volatile? Is the data indexed? Do you rebuild your > indexes? If you are deleting you will not reclaim the space unless you > drop > and rebuild your indexes. > > You may reclaim the 300 MB allowing you to drop the chunk. > > Hope this helps, > > Scott H. > > > ---------- > > From: Howard, Paul[SMTP:PaulHow@medcmp.com] > > Sent: Thursday, January 06, 2000 10:55 AM > > To: 'informix-list@iiug.org' > > Subject: Dbspaces spanning multiple disks. > > > > Platform AIX 4.2 IDS 7.24 > > > > We have a few high use tables fragmented round robin across four > dbspaces. > > Until about a month ago each dbspace was made up of two 1GB chunks on > the > > same disk. The result was that each dbspace took an entire 2GB disk. > > Performance was great. A month ago we ran out of space and added 300MB > > chunks from separate disks to a couple of these dbspaces. After this we > > noticed significant a performance hit (We are not seeing multiple > threads > > per session anymore). Could the reason for our performance hit be that > our > > dbspaces are now spanning multiple disks or should we be looking > > elsewhere? > > > > >