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)

On Thu, 30 Nov 2006 21:38:49 -0500, Darren_Jacobs@carmax.com wrote: > >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. > Sysutils database is usually in the rootdbs, along with any temp tables that may be created there as well. How much space is free in rootdbs? How busy is rootdbs? Can you purge any data from the bar_?????? tables? JWC

Hi, right. sysutils in rootdbs, probably some temp table (also in rootdbs) during dbspace backup uses additional space, so that you hit the ceiling ... You should not "purge" things from the sysutils database, at least not by manually connecting to the database and issuing "DELETE" statements. This can easily cause you a lot of trouble in case of a restore. What you can (and should) do (more or less regularly) is to use "onsmsync" utility to expire old backups (dbspaces and log files). This will also delete entries from the systutils database. Please see the manual "Backup and Restore Guide" for more info on "onsmsync". That will avoid this situation in the future. "oncheck -pe" shows which table has allocated how many pages, as already noted. In the short run you will probably have to add a chunk to the root dbspace to make it work again. If you don't have temp dbspaces yet, you can create some (and list them in onconfig file). It may help. It is also possible that setting PSORT_DBTEMP environment variable helps. This would cause the use of file system disk space rather than temp dbspaces (or root dbspace) for sort tasks. The backup of a log file does not only contain the log records from the log file itself, but also any BLOBSpace BLOBs that have been manipulated in corresponding transactions (log records). This is necessary because BLOBSpace BLOBs themselves are not in the logical log files. With that the backup of a log file can be much larger than the log file itself. Regards, Martin -- Martin Fuerderer IBM Informix Development Munich, Germany Information Management Informix URLs list: http://home.arcor.de/mfu1/informix/urls.html informix-list-bounces@iiug.org wrote on 01.12.2006 05:07:43: > On Thu, 30 Nov 2006 21:38:49 -0500, Darren_Jacobs@carmax.com wrote: > > > > >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. > > > > Sysutils database is usually in the rootdbs, along with any temp > tables that may be created there as well. > > How much space is free in rootdbs? > > How busy is rootdbs? > > Can you purge any data from the bar_?????? tables? > > JWC > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list