HPL and > 2Gb files

Posted in 2000

Jon Myatt — Thu, 12 Oct 2000 12:00:16 +0100 — source: Informix-list mailing list archive (1991-1998)

Hi all Does HPL have a limit on the size of files it can load? I have a 5Gb file and it's falling over about half-way through with an "aio error code 4" - this'll be at about the 2Gb point. Any ideas for a workaround? Cheers, Jon.

↪ replying to Jon Myatt

Chuck Renaud — Thu, 12 Oct 2000 10:18:44 -0500 — source: Informix-list mailing list archive (1991-1998)

>Does HPL have a limit on the size of files it can load? On a 32-bit system, 2GB. >I have a 5Gb file and it's falling over about half-way through with >an "aio error code 4" - this'll be at about the 2Gb point. Any >ideas for a workaround? What version of the engine are you using and what OS? I don't believe the 64-bit version has a 2GB limitation (but I'm just speculating there). If you're running 32-bit, then split the file up into <2GB chunks.

↪ replying to Chuck Renaud

Jon Myatt — Thu, 12 Oct 2000 17:01:21 +0100 — source: Informix-list mailing list archive (1991-1998)

> On a 32-bit system, 2GB. Damn. > What version of the engine are you using and what OS? I don't believe > the 64-bit version has a 2GB limitation (but I'm just speculating > there). It's 7.31UC7 on AIX 4.3.3. The OS is 64-bit, and has no limitation, so it must be a problem with HPL. > If you're running 32-bit, then split the file up into <2GB chunks. Yeah, guess I'll have to. It's a little strange, because the file was produced by dbaccess on the same box, so the limitation obviously doesn't exist in that program. Cheers, Jon.