Re: ontape -s ERROR

No Informix will only prompt for a new tape when TAPESIZE is reached, if the end of the tape is reached before then (i.e. the tape is not as long as the manufacture claims) it will error out. So if you have 4GB tapes set the TAPESIZE to about 90% of 4GB "K.Hong Lee" wrote: > > the tape parameter is set to /dev/rmt/0m and we'd been > > using the same device since day one. > if we don't enough capacity on the tape, informix > should prompt to put in the next tape and continue > backup. > > I'd monitored the tempdbs while the backup was > performed and we'd plenty of free space from the > onstat -d output about 300mb free up to the point when> it exited abnormally It is the way > to monitor the tempdbs ? > > Thanks, > > --- Paul Watson <Paul.Watson@gmaccc.co.uk> wrote: > > You don't mention the OS but 28 is normally out of > > space. So you are > > out of temp space or tape space, what are the tape > > parameters, are you > > using compression on the drive ??? > > > > "K.Hong Lee" wrote: > > > > > > we hadn't perform any database level 0 backup due > > to > > > the following error: > > > > > > It was happened when the backup hits 60% onward. > > > > > > 10 % completed > > > 20 % completed > > > 30 > > > 40 > > > 50 > > > 60..... > > > > > > Achieve Failed - Function write to tape failed > > code -1 > > > errno 28. > > > > > > Tried to execute the same command few times since > > > yesterday but no luck. > > > > > > Will be very much appreciated if someone can help > > > to explain this. > > > > > > Thanks, > > > __________________________________________________ > > > Do You Yahoo!? > > > Thousands of Stores. Millions of Products. All > > in one place. > > > Yahoo! Shopping: http://shopping.yahoo.com > > > > -- > > Paul Watson # > > WF Software # If it was easy > > Tel ++44 1436 674729 # Everybody could do > > it > > Fax ++44 1436 678693 # > > www.wfsoftware.com/informix # > > > > > > __________________________________________________ > Do You Yahoo!? > Thousands of Stores. Millions of Products. All in one place. > Yahoo! Shopping: http://shopping.yahoo.com -- Paul Watson # WF Software # If it was easy Tel ++44 1436 674729 # Everybody could do it Fax ++44 1436 678693 # www.wfsoftware.com/informix #