Oninit cdi / Archive
Talk to an expert →

Re: IDS 9.40 UC5/linux update statistics crashes engine on large table

Posted in 2004

Topics: Error Codes & Troubleshooting, Versions, Editions & End-of-Life

loden — — source: Usenet: comp.databases.informix

I do have a case open. I figured I would post to the group as well and see if anyone else has had the problem. The af file did not produce the normal stack trace it only has about 7 lines, basically a repeat of the error in the online.log. ~tisha

↪ replying to loden
scottishpoet — — source: Usenet: comp.databases.informix

case number?

↪ replying to scottishpoet
loden — — source: Usenet: comp.databases.informix

421279 I have not heard anything back from them yet...

↪ replying to loden
scottishpoet — — source: Usenet: comp.databases.informix

what happens when you oncheck this table and its indexes? If that is clean, you copy the table to "new database" that contains only this table and run the update stats command does it still fail? If so that is probably quite a nice test case to send to Informix support to reproduce the problem. loden wrote: > 421279 > > I have not heard anything back from them yet...

↪ replying to scottishpoet
loden — — source: Usenet: comp.databases.informix

Ok, thank you I will give that a try today. I did run oncheck -cID on the table as per the request of the informix tech support person. It came back clean. ~Tisha

Glossary