Informix ontape level 0 backup finishes all day in 90 percent don

Posted in 2004

Tarcisio Gouveia — Fri, 12 Mar 2004 10:01:27 -0300 — source: Usenet: comp.databases.informix

Help me My level 0 backup is aborting all day in 90 percent(in the last tape). Information: Database size: 400 gb Number of tapes: 6(70 gb each tape) SAP version 46C SP39 Informix version: 7.31FC6X2 Unix version: Digital UNIX V4.0F (Rev. 1229) History: My level 0 backup was normal. For 5 days it aborted in 90 percent, then I changed the tape drive. I changed the tape drive, then the backup finished. But in the next day it aborted again in 90 percent. I changed the last tape. The backup aborted again in 90 percent. sending to informix-list

↪ replying to Tarcisio Gouveia

Paul Watson — Fri, 12 Mar 2004 13:30:07 +0000 — source: Usenet: comp.databases.informix

What is your tape size set to and are you using compression, sounds like the tape is full but 'cos of the tape setting it's not getting detected Tarcisio Gouveia wrote: > > Help me > > > My level 0 backup is aborting all day in 90 percent(in the last > tape). > > Information: > Database size: 400 gb > Number of tapes: 6(70 gb each tape) > SAP version 46C SP39 > Informix version: 7.31FC6X2 > Unix version: Digital UNIX V4.0F (Rev. 1229) > > History: > My level 0 backup was normal. > For 5 days it aborted in 90 percent, then I changed the tape drive. > I changed the tape drive, then the backup finished. > But in the next day it aborted again in 90 percent. > I changed the last tape. > The backup aborted again in 90 percent. > > > > sending to informix-list -- Paul Watson # Oninit Ltd # Growing old is mandatory Tel: +44 1436 672201 # Growing up is optional Fax: +44 1436 678693 # Mob: +44 7818 003457 # www.oninit.com #

↪ replying to Tarcisio Gouveia

TBP — Fri, 12 Mar 2004 13:50:11 +0000 — source: Usenet: comp.databases.informix

Tarcisio Gouveia wrote: > Help me > > > My level 0 backup is aborting all day in 90 percent(in the last > tape). > > Information: > Database size: 400 gb > Number of tapes: 6(70 gb each tape) > SAP version 46C SP39 > Informix version: 7.31FC6X2 > Unix version: Digital UNIX V4.0F (Rev. 1229) > > History: > My level 0 backup was normal. > For 5 days it aborted in 90 percent, then I changed the tape drive. > I changed the tape drive, then the backup finished. > But in the next day it aborted again in 90 percent. > I changed the last tape. > The backup aborted again in 90 percent. > > > > sending to informix-list What have you got TAPESIZE and TAPEBLK set to? Try reducing TAPESIZE by a "bit" (and get ready with another tape), or set TAPEBLK to a "decent" value like 512 or 1024. Where do you get the value of ... > Number of tapes: 6(70 gb each tape) 6 * 70 seems really close to 400 to me. TBP

Glossary

ontape