Re: Clustered index problems

The table is not in the rootdbs but thanks for the info, I will check out the log for errors anyway. Thanks Jason Harris <jharris@westpac.com.au> wrote in article <34629eeb.12797085@10.209.30.200>... > 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 >