RE:

We dbexport to a file system and go into the exported directory and compress of use gzip to zip up the unload files, the use tar. BMC also make some tools to export and import Informix databases. The 2 gig tape limit is in the dbexport command and can't be changed. Hope this helps, Wayne E. Martin Informix Database Administrator Kmart Corp. PS and yes the 2 gig limit is a pain in the .. (well you know where)!!! -----Original Message----- From: David Kulkarni [mailto:dnk61@yahoo.com] Sent: Thursday, October 12, 2000 11:03 AM To: benj@firstlinux.net; Obnoxio The Clown; informix-list@iiug.org Subject: Re: Thanks for the sarcasm, it did not help. Let me rephrase my question. How does one export a 32gig database on to a DLT drive that has a capacity of 20 gigs. All my previous efforts ended up in asking for a tape when 2 gigs of data was written to the tape. I tried adding a zero to the command as some of you asked me to do, when I did that it complained that "Block size must be less than or equal to tape size". I want to know is there an OS limitation (HP-UX 10.20) or an Informix limitation that it will not write over 2 gig of data. TIA --- Carlos Benjamin <benj@firstlinux.net> wrote: > > > --- "Obnoxio The Clown" <obnoxio@hotmail.com> > > wrote: > >From: Carlos Benjamin <benj@firstlinux.net> > >> > >>--- David Kulkarni <dnk61@yahoo.com> > >> > wrote: > >> >I have been trying to export our database to a DLT tape drive, the data > >>base is 32 GIGs but after > >> >about an hour its asking me for next tape. The tape has a capacity of > >>19.5 gigs....can anybody > >> >tell me where I am going wrong. > >> > >>You're not putting in the next tape? > >> > >>There's a couple of problems I see here..... > >> > >>Your database is 32(BIG)GIGs > >>Your tape is only 19.5(little)gigs > >> > >>Trying to put all thos BIG GIGS into little gig holes will probably stretch > >>your tape all out of shape. Plus, there's more BIG GIGs in your database > >>than there are little gig spaces on the tape. Now, if you had it the > >>reverse, using little gigs on your database and BIG GIGs on your tape, you > >>might be able to cram two or three little gigs into each BIG GIG space on > >>the tape. But I don't have an answer for your particular situation. > > > >They say that for sarcasm to be at its most effective, it should lightly > >etch a phrase, not drip from every syllable. But I think you've just proven > >them wrong. > > Was I dripping? Sorry about the mess everyone..... > > > == > Maintainer of the procrastinator's FAQ. Well, maybe > tomorrow I will be. > > _____________________________________________________________ > Want a new web-based email account ? ---> http://www.firstlinux.net ===== David Kulkarni New York, NY 10021 email: dkulkarni@cgsh.com __________________________________________________ Do You Yahoo!? Get Yahoo! Mail - Free email you can access from anywhere! http://mail.yahoo.com/