Re: Informix ontape level 0 backup finishes all day in 90 percent don e.

The $INFORMIXDIR/etc/$ONCONFIG TAPESIZE parameter is most likely set to high. Remember, as the data becomes more compressed within dbspaces (thru attrition, reorgs, etc) the tape drive compression is lowered. Example, our DLT7000 tape drive using 35/70 gb tapes were able to compress up to 70 gb without having ontape abort, but the TAPESIZE parameter had to be changed to 65gb recently. Sounds like you are reaching the peak capacity of the tape, so lowering the TAPESIZE value should do the trick. Tarcisio Gouveia <Tarcisio.Gouveia@refrescosguararap To: informix-list@iiug.org es.com.br> cc: Sent by: Subject: Informix ontape level 0 backup finishes all day in owner-informix-list@iiug.org 90 percent don e. 03/12/2004 08:31 AM 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 sending to informix-list

timothy.a.brown@marconi.com writes: > The $INFORMIXDIR/etc/$ONCONFIG TAPESIZE parameter is most likely set to > high. Remember, as the data becomes more compressed within dbspaces (thru > attrition, reorgs, etc) the tape drive compression is lowered. Example, > our DLT7000 tape drive using 35/70 gb tapes were able to compress up to 70 > gb without having ontape abort, but the TAPESIZE parameter had to be > changed to 65gb recently. > > Sounds like you are reaching the peak capacity of the tape, so lowering the > TAPESIZE value should do the trick. This is still too much BOFH voodoo for my tastes... Can't IBM write and include a utility that you can point at a tape in a drive and exercise it to find the optimal parameters for TAPEBLK and TAPESIZE? I'm pretty sure Amanda has something like that. -- Forte International, P.O. Box 1412, Ridgecrest, CA 93556-1412 Ronald Cole <ronald@forte-intl.com> Phone: (760) 499-9142 President, CEO Fax: (760) 499-9152 My GPG fingerprint: C3AF 4BE9 BEA6 F1C2 B084 4A88 8851 E6C8 69E3 B00B

I wish 'The Management' would stop believing the sales guys that state you can 70GB on 35GB tape Ronald Cole wrote: > > timothy.a.brown@marconi.com writes: > > The $INFORMIXDIR/etc/$ONCONFIG TAPESIZE parameter is most likely set to > > high. Remember, as the data becomes more compressed within dbspaces (thru > > attrition, reorgs, etc) the tape drive compression is lowered. Example, > > our DLT7000 tape drive using 35/70 gb tapes were able to compress up to 70 > > gb without having ontape abort, but the TAPESIZE parameter had to be > > changed to 65gb recently. > > > > Sounds like you are reaching the peak capacity of the tape, so lowering the > > TAPESIZE value should do the trick. > > This is still too much BOFH voodoo for my tastes... Can't IBM write > and include a utility that you can point at a tape in a drive and > exercise it to find the optimal parameters for TAPEBLK and TAPESIZE? > I'm pretty sure Amanda has something like that. > > -- > Forte International, P.O. Box 1412, Ridgecrest, CA 93556-1412 > Ronald Cole <ronald@forte-intl.com> Phone: (760) 499-9142 > President, CEO Fax: (760) 499-9152 > My GPG fingerprint: C3AF 4BE9 BEA6 F1C2 B084 4A88 8851 E6C8 69E3 B00B -- 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 #

"Paul Watson" <paul@oninit.com> wrote in message news:4052549F.C8D42F85@oninit.com... > I wish 'The Management' would stop believing the sales guys that > state you can 70GB on 35GB tape > Get 9.40.UC3. You can set TAPESIZE=0 which means write until the tape is full! > Ronald Cole wrote: > > > > timothy.a.brown@marconi.com writes: > > > The $INFORMIXDIR/etc/$ONCONFIG TAPESIZE parameter is most likely set to > > > high. Remember, as the data becomes more compressed within dbspaces (thru > > > attrition, reorgs, etc) the tape drive compression is lowered. Example, > > > our DLT7000 tape drive using 35/70 gb tapes were able to compress up to 70 > > > gb without having ontape abort, but the TAPESIZE parameter had to be > > > changed to 65gb recently. > > > > > > Sounds like you are reaching the peak capacity of the tape, so lowering the > > > TAPESIZE value should do the trick. > > > > This is still too much BOFH voodoo for my tastes... Can't IBM write > > and include a utility that you can point at a tape in a drive and > > exercise it to find the optimal parameters for TAPEBLK and TAPESIZE? > > I'm pretty sure Amanda has something like that. > > > > -- > > Forte International, P.O. Box 1412, Ridgecrest, CA 93556-1412 > > Ronald Cole <ronald@forte-intl.com> Phone: (760) 499-9142 > > President, CEO Fax: (760) 499-9152 > > My GPG fingerprint: C3AF 4BE9 BEA6 F1C2 B084 4A88 8851 E6C8 69E3 B00B > > -- > 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 #