Log Backups - Error 142 problem

The automated log backup script log_full.sh is not working for me. The output from the message log is: 14:06:21 Logical Log 2257 Complete. 14:06:22 Process exited with return code 142: /bin/sh /bin/sh -c /opt/ids2k/v9r21uc5/etc/log_full.sh 2 23 "Logical Log 2257 Complete." "Logical Log 2257 Comple te." The onbar log has the following messages 2003-08-24 14:16:33 6268 6266 Could not open XBSA library /usr/lib/ibsad001.so. 2003-08-24 14:16:33 6268 6266 Unable to open file /opt/ids2k/v9r21uc5/etc/sm_versions No such file or directory 2003-08-24 14:16:33 6268 6266 /opt/ids2k/v9r21uc5/bin/onbar_d complete, returning 142 (0x8e) Error 142 says the following : -142 ISAM error: overflow of tblspace page. > An internal error (probably obsolete) occurred. If the error recurs, please > note all circumstances and contact Informix Technical Support. > Please advise if this is alarming or if the exit code indeed pertains to this > error message. My logical backups are not happening ? Any ideas.

Jack A wrote: > The automated log backup script log_full.sh is not working for me. The > output from the message log is: > > 14:06:21 Logical Log 2257 Complete. > 14:06:22 Process exited with return code 142: /bin/sh /bin/sh -c > /opt/ids2k/v9r> 21uc5/etc/log_full.sh 2 23 "Logical Log 2257 Complete." "Logical Log 2257 > Comple > te." > > The onbar log has the following messages > > 2003-08-24 14:16:33 6268 6266 Could not open XBSA library > /usr/lib/ibsad001.so. > 2003-08-24 14:16:33 6268 6266 Unable to open file > /opt/ids2k/v9r21uc5/etc/sm_versions > No such file or directory > 2003-08-24 14:16:33 6268 6266 /opt/ids2k/v9r21uc5/bin/onbar_d complete, > returning 142 (0x8e) > > Error 142 says the following : > > -142 ISAM error: overflow of tblspace page. > > An internal error (probably obsolete) occurred. If the error recurs, > please > > note all circumstances and contact Informix Technical Support. > > Please advise if this is alarming or if the exit code indeed pertains to > this > > error message. > > My logical backups are not happening ? Any ideas. > > The 142 error is sent by onbar. You cannot search it with finderr. It's not the same error. The 142 onbar error means: #define BAR_FILE_OPEN 0x8e /* (142) open() failed, usually fatal */ (you should be able to find a web page with all onbar errors by googling a bit... I've posted it here sometime ago, but I don't have the bookmark with me) The onbar error matches perfectly with the information on onbar.log: > 2003-08-24 14:16:33 6268 6266 Unable to open file > /opt/ids2k/v9r21uc5/etc/sm_versions So... You have a bad onbar configuration. Please re-check it. This file should contain some info specific to your storage manager. Regards.

> The 142 onbar error means: > > #define BAR_FILE_OPEN 0x8e /* (142) open() failed, usually fatal */ > > (you should be able to find a web page with all onbar errors by googling a bit... I've posted it here sometime ago, but I don't have the bookmark with me) Or you can look in chapter 11 of the Backup and Restore Manual and learn that it is: "142 ON-Bar was unable to open a file. Verify that the named file exists and that the permissions are correct. Check the ON-Bar activity log for an operating-system error message."