Re: (Another) ontape to recover from a FIFO pipe

Jacob Salomon wrote: > Andy France wrote: > >> >>I had a similar problem. We backup to a named pipe and gzip the dump >>on the other side. For a restore I tried gzcat back to the pipe but > > | when I ran ontape I just got a broken pipe. > >>In the end I uncompressed the dump, and specified the dump file name >>in the TAPEDEV parameter in my onconfig file. ontape then did the >>restore without any problems. >> >>HTH, >>Andy. > > Thanks, Andy. > > I had been thinking of this earlier; it was nice to see it wasn't a > lunatic idea. (Or if it is, it wasn't a lonely lunacy. ;-) > > My one big doubt is that the flat file is about 79GB in length and > we all know how Informix (especially my 7.23 clunker) handles files > longer than 2GB. Was your flat archive file similarly humongous? > > Thanks. > +------------------------------------------------- Jacob Salomon -+ > |When you exit this vehicle, please be sure to lower your head and| > |watch your step. If you fail to do so, please lower your voice | > |and watch your language. | > +-----------------------------------------------------------------+ > I see plenty of others have pitched in while I have been off for the weekend :-) Sadly, my uncompressed database dump is only 1.5GB! Andy I'm only the Informix DBA around here by default, so can't count on years of experience. Sorry I can't really provide any more help. We are using a similar mechanism for another 7.31.UC7 database which will produce an uncompressed dump file greater than 2GB - in fact, I've just discovered gunzip even barfs on it. I'll be looking into Tim Brown's solution for that one... Andy.