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

Nuala Have not seen anything like this .... Send us onstat -d ?What is the sql did you run to create the index? oncheck -pt database:table ?What is your estimate of the index size? Rows in the table? Length and type of columns in the index? Murray Wood -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org]On Behalf Of Andy Donaldson Sent: Thursday, February 10, 2000 11:46 AM To: informix-list@iiug.org 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