Re: Back up takes too long

Thanks, Jonathan. You are right on target. Our setting was 16 KB. Regards, Dorn B. ----- Original Message ----- From: "Jonathan Leffler" <jleffler@earthlink.net> To: <informix-list@iiug.org> Sent: Tuesday, February 17, 2004 07:49 PM Subject: Re: Back up takes too long > Dorn Bhechsonggram wrote: > > I wonder whether there are any ways to improve the speed of back up. I = > > am currently using ontape to back up the database to dell autoloader = > > daily. > > The back up time is about 4 hours for the database size of about 75 GB. = > > Any suggestion. > > Don't post MIME. > > Do increase the tape buffer size - especially if it is under 256 KB > (well, it should probably be above 64 KB, and certainly not the > default of 16 KB -- it shouldn't have been that small even back in > 1988, let alone 16 years later). > > -- > Jonathan Leffler #include <disclaimer.h> > Email: jleffler@earthlink.net, jleffler@us.ibm.com > Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/ > > sending to informix-list

A very unscientific way to set the size is to keep increasing it until the 'write' light is permanently lit. Dorn Bhechsonggram wrote: > > Thanks, Jonathan. > > You are right on target. Our setting was 16 KB. > > Regards, > Dorn B. > > ----- Original Message ----- > From: "Jonathan Leffler" <jleffler@earthlink.net> > To: <informix-list@iiug.org> > Sent: Tuesday, February 17, 2004 07:49 PM > Subject: Re: Back up takes too long > > > Dorn Bhechsonggram wrote: > > > I wonder whether there are any ways to improve the speed of back up. I > = > > > am currently using ontape to back up the database to dell autoloader = > > > daily. > > > The back up time is about 4 hours for the database size of about 75 GB. > = > > > Any suggestion. > > > > Don't post MIME. > > > > Do increase the tape buffer size - especially if it is under 256 KB > > (well, it should probably be above 64 KB, and certainly not the > > default of 16 KB -- it shouldn't have been that small even back in > > 1988, let alone 16 years later). > > > > -- > > Jonathan Leffler #include <disclaimer.h> > > Email: jleffler@earthlink.net, jleffler@us.ibm.com > > Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/ > > > > > > 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 #