Oninit cdi / Archive
Talk to an expert →

Re: onbar log backups aborting w/TSM

Posted in 2006

Floyd Wellershaus — — source: Usenet: comp.databases.informix

Darren, If your sysutils is getting too big and filling up rootdbs, you should run onsmsync regularly. I run it once a month in cron. It gets rid of all info about backups that Tivoli doesn't know about anymore, from your sysutils and from your $INFORMIXDIR/etc/ixbar files. ======================== -<<Floyd Wellershaus>>- Database Administrator Unix Administrator email: fwellers@yahoo.com Home: 703-430-0805 Cell: 703-477-6045 ======================== http://www.one.org/ ----- Original Message ---- From: "Darren_Jacobs@carmax.com" <Darren_Jacobs@carmax.com> To: informix-list@iiug.org Sent: Thursday, November 30, 2006 9:38:49 PM Subject: onbar log backups aborting w/TSM IDS 9.40 FC2XA HPUX 11.11 Greetings, I have a very interesting situation that started about a week ago. My onbar logical log backups are being "Aborted by client" (online.log). The bar_act.log file indicates "SQL 4294967025 Could not insert new row into table." followed by "ISAM 4294967165 ISAM error: no free disk space". The interesting thing is that after a onbar whole system backup completes all logical log files backup without issue. Another interesting thing is that TSM is indicating a 102 meg log file is being backed up. Any help or insight would be greatly appreciated. TIA The logical log files backup via ALARMPROGRAM /usr/informix/etc/log_full.sh. log_full.sh BACKUP_CMD="onbar -b -l" onbar archive cmd: onbar -b -w -L 0 sm_versions linked to sm_versions.tdp 1|5.2.1|adsm|5| 114 logfiles @ 100 meg online.log 21:04:04 Maximum server connections 92 21:04:10 Logical Log 75915 Complete, timestamp:900189386. 21:04:11 Logical Log 75861 - Backup Started 21:08:27 Logical Log 75861 - Backup Aborted Aborted by client. 21:08:32 Logical Log 75861 - Backup Started 21:08:45 Logical Log 75861 - Backup Aborted Aborted by client. 21:08:51 Process exited with return code 139: /bin/sh /bin/sh -c /usr/informix/etc/log_full.sh 2 23 "Logical Log 75915 Complete, timestamp:900189386." "Logical Log 759 bar_act.log 2006-11-30 21:08:32 13638 13636 Begin backup logical log 75861. 2006-11-30 21:08:32 13638 13636 Successfully connected to Storage Manager. 2006-11-30 21:08:45 13638 13636 SQL 4294967025 Could not insert new row into the table. 2006-11-30 21:08:45 13638 13636 ISAM 4294967165 ISAM error: no free disk space 2006-11-30 21:08:50 13638 13636 SQL 4294967025 Could not insert new row into the table. 2006-11-30 21:08:50 13638 13636 ISAM 4294967165 ISAM error: no free disk space 2006-11-30 21:08:50 13638 13636 /usr/informix/bin/onbar_d complete, returning 48 (0x94) _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list