Re: TAPE BLOCK SIZE

Please give me the value you are using to even get the 8GB per tape. We are only getting 2GB per tape. So you are somewhat better off. I'll be trying a lot of testing of this in the next few weeks. I will post my results on the Informix List if I find out anything good. Thanks for your response! ------------------------------------------------------------------------- Cheryl Kendricks Internet: cherylk@spamis.jcdc.doleta.gov OR cherylk@prod1.jcdc.doleta.gov OR kendric@gwysmtp.jcdc.doleta.gov DTSI, Inc. Voice: 1-800-598-5008 Database Administrator - DOL Job Corps San Marcos, Texas ------------------------------------------------------------------------ On Tue, 19 Mar 1996, Darin Melin wrote: } } } On Mon, 18 Mar 1996, Cheryl Kendricks wrote: } } > I am running tbtape from UNIX 3.2 and Informix 5.X engine on IBM RS6000. I } > have a 10GB database and am using 5.0 GB IBM 8MM Tape Drive. It takes 4 hours } > to do a back up. We are using a blocking of 20 in the Informix Configuration } > and the tape block size is set to 20480. I have changed this to 240 for the } > Informix Configuration and 245760 for the tape drive. I then got a to 3 hours. } > So smart me changed it to 960 hoping it would at least get to 2 hours, if not } > one. BUT NO It went back to 4 and used more tapes. } > } > Anyway my question is does anyone know a MAGICAL set of tape drive and } > configuration numbers that I could try to get this archive to process in } > at least 2 hours? } > } > If you do please let me know. I and the operators would love it if we could } > cut our archive down to 1/2 the time. } > } > THANKS IN ADVANCE!!!!!!!!!!!!!!!!!!!!!!! } > ------------------------------------------------------------------------- } > Cheryl Kendricks } > Internet: cherylk@spamis.jcdc.doleta.gov } > OR } > cherylk@prod1.jcdc.doleta.gov } > OR } > kendric@gwysmtp.jcdc.doleta.gov } > DTSI, Inc. Voice: 1-800-598-5008 } > Database Administrator - DOL Job Corps San Marcos, Texas } > ------------------------------------------------------------------------ } } Cheryl, } } I am also having the same problem. My configuration is a Sparcenter 2000 } with Exabyte 8505 8mm tape drives. These drives allow 14 GB to be written } to them. I have tried different device numbers and can't write more than } 8GB to them. } } In addition, my database is 40GB allocated and it takes me 24 hours to } back it up (ie 3 tapes at 8 GB each) (no my math is not wrong, we are } not full on the dbspaces). When I do a restore, it takes approx 2 hours } per tape. Anybody know the discrepancy??? I am the only one on the system } during archive and restore. } } Also, Anybody know the proper settings for block factor, etc? } } Thanks, } } Darin } } +----------------------------------------------------------------------------+ } | | | } | . . | | } | ... ... | Darin Melin | } | ..... ..... | Software Engineer, DBA | } | .. ... .. | Business Systems Integration Group | } | . . . | Semiconductor Products Sector - LATG | } | | 2100 E. Elliot Road, MD EL557 | } | | Tempe, AZ 85284 | } | Motorola, Inc. | rp29560@email.sps.mot.com Phone:(602) 413-5756 | } | | melin@bsi.sps.mot.com FAX: (602) 413-5566 | } | | Director - Arizona Informix Users Group | } +----------------------------------------------------------------------------+ } | 'connectionLESS IS MORE' -- Data Broker | } +----------------------------------------------------------------------------+ } }