Informix Database error SQL Error (-668) ISAM error: bad row id

Hey

I am trying to execute a insert sql command and I get the error from informix database as follows:

SQL Error (-668): System command cannot be executed.
ISAM error: bad row id"

Can some one help me in understanding the error and solution for the error.

Thanks in advance
sudarshan1985Asked:
Who is Participating?
 
flutophilusCommented:
I've seen this when an index has been damaged. You can run the oncheck utility to check and repair the indexes or just rebuild the indexes on the table if you can.

More info on oncheck on the IBM docs page http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp

or just google oncheck
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.