Re: 2 gb file limit

You can also make a small script in which you can unload to pipe and start compression routine likegzip in asynchronous mode. I use gzip it works great. Hope it will help. Sanjeev ---Helmut Leininger <helmut.leininger@bull.de> wrote: > > "Susan Elliott (ISG)" wrote: > > > Howdy folks, > > > > I am unloading a 4.8gb table from informix. As soon as the file size gets > > to 2gb the unload crashes with "write error, ulimit or file system size > > error" > > > > I have changed the ulimit to be unlimited and changed the HFS file system to > > allow large files. The file system is 6gb in size. Tried the unload again, > > and it has failed with the same error. > > > > Can enyone suggest to me how I can get the system to allow files larger than > > 2gb on HPUX 10.20. ???? > > > > TIA > > > > Suze. > > Suze, > > I do not know HPUX, but this is a general UNIX restriction. All "Standard" UNIX > systems have a maximum file size of 2 GB due to the fact that "size_t" used in > file operations is a 4 byte integer (only positive values used). I'm afraid that > unless you have a system that allows something like "Large File Enabled File > System" (as AIX starting with 4.2, using 8 byte integers for size_t) you will > have only two possibilities: either split into files each less than two GB or > unload to tape.> > Regards > Helmut Leininger > > > -- > Helmut Leininger > > Bull AG / Vienna > Unix Support > Email: helmut.leininger@bull.de > > This opinion is mine and not necessarily that of my employer. > No guarantees whatsoever. > > > _________________________________________________________ DO YOU YAHOO!? Get your free @yahoo.com address at http://mail.yahoo.com