Re: 2 gb file limit

"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.