I have been experiencing the following error message pop up in the online.log after I defrag my informix database. This results database going offline and I have searched through books, google and other sources regarding this however have failed so far to find the cause and solution:
14:15:56 Logical Log 4520842 Complete
14:16:32 Checkpoint Completed
14:20:56 ERROR: logundo(29) iserrno 101 us 0x9340243c pid 3439
From Informix books, the Error:logundo() means that OnLine detected an error while attempting to roll back a logical log record. I don't understand why this would happen.
SCO Openserver Unix 5.0.07
Informix Online Version 5
This above error occurs with some of my backups which are not even defragged as well. One consistent thing is that the database error happens every 2 hours or so.
Any clues as to where I should be looking? Would increasing the number of logical logs help? the ISAM Error code iserror 101 from what I have found means 'File not Open' < I find this totally ambiguous and have not idea what "file" this is referring to? Is it the actual logical log file?
If any of you guys have run into this before and know where I should start looking, please let me know. Your help will be much appreciated.