Re: Run out of space when re-locating table index

Sure you're not running out of temp space? From: Andy Donaldson <nuala@editmode.demon.co.uk> > >AIX V4.1.5, Online 7.2.3 UC1, IBM RS6000 R24 >I needed to free up some space on a chunk while waiting for more >physical disks to be delivered. I wanted to drop a large index (approx >70,000 blocks) and re-create it on a dbspace with more available space. >Index was dropped successfully. Started to create the index and after >about 10 mins of the SQL statement running in dbaccess got an error >message stating that there was not enough space on the device. I ran the >statement again - this time monitoring onstat -d -r to check space >utilisation. The SQL again aborted after approx 10 mins with the same >error, although there should have been plenty of space remaining in the >chunk. During the create of the index it would have filled one chunk in >the dbspace and then started to use a new chunk. The onstat -d display >indicated that this was happening until it suddenly froze a short way >into the second chunk. I tried the process again using a different >dbspace which should also have had more than adequate free space, >however the outcome was the same. Had to abandon this approach and let >the original configuration restore. Fortunately this was not the >production server. Has anyone seen this before or got ANY suggestions? >Thank-you >Nuala >-- >Nuala Donaldson ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com