Re: Clustered index problems

Posted in 1997

David Williams — Sat, 8 Nov 1997 19:54:23 +0000 — source: Informix-list mailing list archive (1991-1998)

In article <01bcebcc$40e20020$723aacc7@richntpc>, Rich Newell <richn@northv.com> writes >I ISAM error code is 0 > Then it sounds like a bug. I would except the ISAN error code to be non-zero and give more information. Talk to Informix Technical Support. >David Williams <djw@smooth1.demon.co.uk> wrote in article ><IPMHvGAP3lY0EwZN@smooth1.demon.co.uk>... >> In article <01bceac8$265625b0$723aacc7@richntpc>, Rich Newell >> <richn@northv.com> writes >> >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 >> >> What is the ISAM error code? >> >> -- >> David Williams >> -- David Williams