RE: onbar log backups aborting w/TSM

Posted in 2006

Ogiwara Tsutomu — Fri, 01 Dec 2006 12:26:06 +0900 — source: Usenet: comp.databases.informix

Hi Darren. Sounds like you do not have enouch space in ROOTDBS. Probably, onbar attempted insert to bar_xxx of sysutils database. [tsutoo@urraco ~]tsutoo100fc5% oncheck -pe | grep bar sysutils:'informix'.bar_server 10498 8 sysutils:'informix'.bar_object 10506 8 sysutils:'informix'.bar_obj_idx 10514 7 sysutils:'informix'.bar_action 10521 8 sysutils:'informix'.bar_act_idx 10533 4 sysutils:'informix'.bar_instance 10545 8 Just my $0.02. -- Tsutomu Ogiwara from Tokyo Japan. >From: Darren_Jacobs@carmax.com >To: informix-list@iiug.org >Subject: onbar log backups aborting w/TSM >Date: Thu, 30 Nov 2006 21:38:49 -0500 > > >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 _________________________________________________________________ 「セキュリティ＋PCメンテナンス」を提供するWindows Live OneCare ベータ版（無料）を今すぐトライ！ http://ideas.live.com/