Re: Question regarding the 2gig file size limit on HPUX 10.20

> I understand the limit and the reasons the c call fails when writing to > the filesystem, but have been informed by the sysadm's at the office that > 10.20 does support >2gig files although it might take some tweaking to the > kernal. > > One, can anyone validate this O/S support and speak about the required > configuration? Yes, HP-UX does support large files if you set up the filesystem that way (I believe there's a "-o largefiles" option). There are side effects to this, however. The "ls" command doesn't always work properly with the larger files. Also, if you do any shell script calculations that involve file sizes, enabling the largefiles option may break things as variables are limited in how much they can handle. > Two, would making dbexport think that it is writting to a streaming device > (specifying a tapedev that is a file) get over this problem if the > filesystem does indeed support > 2gig. I'm not sure...I can do some digging because this is a common question. Since I don't use dbexport, I never really looked at the answer. Ontape supports >2GB disk output if you have the right version...I don't believe that HPL does, though. I do know that piping dbexport into a compression utility (to generate a compressed file <2GB) won't work...at least not with the 7.2x engines. --Chuck

"Chuck Renaud" <crenaud@informix.com> writes: > > I understand the limit and the reasons the c call fails when writing to > > the filesystem, but have been informed by the sysadm's at the office that > > 10.20 does support >2gig files although it might take some tweaking to the > > kernal. > > > > One, can anyone validate this O/S support and speak about the required > > configuration? > > Yes, HP-UX does support large files if you set up the filesystem > that way (I believe there's a "-o largefiles" option). And/or a kernel parameter. > There are side effects to this, however. The "ls" command doesn't > always work properly with the larger files. Also, if you do any shell > script calculations that involve file sizes, enabling the largefiles > option may break things as variables are limited in how much they > can handle. > > > Two, would making dbexport think that it is writting to a streaming device > > (specifying a tapedev that is a file) get over this problem if the > > filesystem does indeed support > 2gig. > > I'm not sure...I can do some digging because this is a common > question. Since I don't use dbexport, I never really looked at the > answer. Ontape supports >2GB disk output if you have the right > version...I don't believe that HPL does, though. > > I do know that piping dbexport into a compression utility (to > generate a compressed file <2GB) won't work...at least not with the > 7.2x engines. I suppose using dbexport with a fifo instead of a tapedev should work, it does work with load/unload. mkfifo myfifo gzip < myfifo > myfile & dbexport -t myfile -blah blah... Thomas