Re: Internal Limits - Are there any?

> Suddenly we are running into a problem updating a table. I have generally found that the file/record manager that underlies Informix is pretty stable. However, if indexes or other structures in a file/table *do* get corrupted, *major* weirdness can result. Have you run bcheck ("check table")? > we have no idea how many records were in the table or how many > were being updated. We do know there were less than are there now but > we have no idea how many less. If bcheck doesn't find anything and those rows really are there, you might try selecting or unloading all of the rows in the table along with their ROWID. If the table was generally steady-state, and you recently added a number rows, you might be lucky enough to detect where the new rows start by looking for repeti- tions in the data. Good luck, Walt. -- Walt Hultgren Internet: walt@rmy.emory.edu Emory University, Atlanta, GA, USA BITNET: walt@EMORY Voice: +1 404 727 0648 UUCP: {...,rutgers,gatech}!emory!rmy!walt