Re: 2 gb file limit

> > My understanding is that none of the 7.x or 8.x releases support > > >2GB chunks. If that's an incorrect assumption, I'd love to hear > > some sample versions/platforms, because I've been whining about > > that for months now. It was explained to me that it's on the wish > > list but is a significant change in the storage structure and would open > > up a can of incompatibility worms. > > The size of a file in the filesystem (created by unload) or of a table in > Informix has nothing to do with the maximum size of a chunk as dbspaces > may consist of more than one chunks. > > What really is needed are two prerequisits: > 1) the operating system must support files > 2GB (==> 8 byte integer > size_t) as e.g. AIX 4.2 or maybe others. > 2) the port of Informix for that system must also have been compiled > with the "large file" option. I'm not sure what that has to do with my post, but the chunk size limit is from the 32-bit integer type. I never implied it had anything to do with the filesystem. Raw partitions aren't subject to the 2GB limit imposed on 32-bit platforms and aren't affected by the largefiles option (unless you're using cooked files, I guess). Having multiple chunks in a dbspace doesn't help the administrative load much when you're dealing with a terabyte-sized warehouse. XPS lightens that somewhat with its dbslices, but it's still a pain in the butt. --Chuck