Re: Clustered index problems

What dbspace are these tables in. If they are all in the rootdbs then you may have temp tables ebing created there that are not dropped. If you see the message "recovering temp table space" in your online log when it comes up then this could be the problem. Basically you must be close to the space limits and these extra temp tables that have not been cleaned are taking you over the limit. Regards, Jason On 6 Nov 1997 15:22:24 GMT, "Rich Newell" <richn@northv.com> wrote: >I have a large table where data is inserted all day and at night I have a >cron that executes "ALTER INDEX xxx TO CLUSTER;" . This process runs very >well until the sixth time it is run. On the sixth night I receive the >following error " 502: Cannot cluster index". I will receive this error >every night until I bring Informix down and up, then it will run fine for >six more days. Any ideas as to what is going on??? > >Thanks > > Rich Jason Harris Informix DBA Westpac Banking Corporation NOTE: I add all these address at the bottom of people who spam me Now when their extractors extract my e-mail address they will also end up spamming each other. wtcjr@ix.netcom.com Shevsky@hotmail.com speech@speechrecognition.com SmartBiz@NevWest.com slender@juice4u.net sbliss@earthfriends.com ron@moneyaction.com removeme@gwh.net rocco@lostvegas.com market@DRAWBRIDGE.NET Foxyrusski@mail-response.com emaster@email-man.com waynesmail@earthlink.net root@localhost postmaster@localhost