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

How much tempdbspace do you have? If this is not adequate you will need more as the engine will have to create sort tables to crate the index. Joe ----- Original Message ----- From: Andy Donaldson <nuala@editmode.demon.co.uk> To: <informix-list@iiug.org> Sent: Wednesday, February 09, 2000 4:45 PM Subject: Run out of space when re-locating table index > 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