Oninit Logo
The Down System Specialists
+1-913-674-0360
+44-2081-337529
Partnerships Contact
Finderr

-126 ISAM error: bad row id.

The ISAM processor was asked to retrieve a row by its physical location but could not find a row at that location.

The error occurred due to one or more of the following reasons:

For queries using the dirty read isolation level, the data being queried was in a temporarily inconsistent state that prevented it from being read. This is normal behavior for the dirty read isolation level, which allows queries to access data that is being updated concurrently by other transactions. Resubmit the query. To prevent this error from occurring, use a higher isolation level.

For C-ISAM programs, if you are using access by record number, review the number stored in isrecnum; it is invalid. Otherwise, the current index might be damaged; run the bcheck or secheck utility.

For SQL products, the index has been damaged. Run the oncheck utility to check and repair the index if you are using IBM Informix Dynamic Server, IBM Informix Universal Server, or IBM Informix OnLine Dynamic Server. Run bcheck or secheck if you are using the IBM Informix SE database server. Run tbcheck if you are using the IBM Informix OnLine database server.