Re:

From: David Kulkarni <dnk61@yahoo.com> > >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 Well, now. When you put it like that, it's a completely different issue. Informix version? ontape/dbexport/onunload? >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/ _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com.

Obnoxio The Clown wrote in message <8s4ma6$j2t$1@news.xmission.com>... > >From: David Kulkarni <dnk61@yahoo.com> >> >>Thanks for the sarcasm, it did not help. Let me rephrase my question. >> Go on let me slap the clown, go on... >>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 > dbexport -d mydb -t /dev/mytape -b 256 -s 20971520 20*1024*1024 K = 20971520K 20971520/256 = exactly 81920 Hence the tape size is a multiple of the block size. The limit on TAPE size for dbexport is 2Tb (2 Terabytes) =2048 Gb The limit on DISK FILE size for dbexport is 2Gb. Although newer Informix and OS versions may change this. Thanks to June Tong for this (I think when she was still at Informix!) I still remember the smack I got from her when I got this wrong. One more for the FAQ! June when I got this wrong!! This should work on all recent versions as the limit on >Well, now. When you put it like that, it's a completely different issue. > >Informix version? >ontape/dbexport/onunload? > >>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