Re: Log Backups - Error 142 problem

Jack: I would like clarify that the return error code "-142" is from Informix/onbar and nothing to do with Informix Error # that can be found under finderr utility. The error code -142 will be returned when $INFORMIXDIR/etc/sm_versions file is missing while onbar takes backup. You can use following command to create the sm_versions file and try starting logical log backup manually and test it. ln -s $INFORMIXDIR/etc/sm_versions.std $INFORMIXDIR/etc/sm_versions or cp -p $INFORMIXDIR/etc/sm_versions.std $INFORMIXDIR/etc/sm_versions chmod 775 $INFORMIXDIR/etc/sm_versions onbar -b -l # To backup logical log from command line. Error code -142 description: BAR_FILE_OPEN 0x8e (142) ON-Bar was unable to open a file. Verify that the named file exists and that the permission's are correct. Check the ON-Bar activity log for an operating-system error message. If you need full list of onbar error codes with description, please let me know. Thank You Ramesh Vasudevan "Jack A" <jacka8@excite.co To: informix-list@iiug.org m> cc: Sent by: Subject: Log Backups - Error 142 problem owner-informix-li st@iiug.org 08/24/03 02:20 PM Please respond to "Jack A" 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. sending to informix-list