RE: 2 gb file limit [SUMMARY]
Quite right. Informix support advised me that it was a limitation of
Informix.
You also can't use a dlt / tape as there is also a 2 gb limitation from the
unix side.
Thanks everyone.
-----Original Message-----
From: Neil Truby [SMTP:ntruby@netcomuk.co.uk]
Sent: Friday, 16 October 1998 05:02
To: Susan Elliott (ISG)
Subject: Fw: 2 gb file limit
I've changed my mind. It IS an Informix limitation!
Use DLT or tape.
Neil
-----Original Message-----
From: Neil Truby <ntruby@netcomuk.co.uk>
To: Susan Elliott (ISG) <SusanE@fclcis.co.nz>
Date: 15 October 1998 16:59
Subject: Re: 2 gb file limit
>
>-----Original Message-----
>From: Susan Elliott (ISG) <SusanE@fclcis.co.nz>
>Newsgroups: comp.databases.informix
>Date: 14 October 1998 23:19
>Subject: 2 gb file limit
>
>
>>
>>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"
>
>
>Everybody else seems to think that this is an Informix problem, but
I'm not
>so sure. After all, if it were an Informix problem, the
implication would
>be that you couldn't use onunload to unload a database larger than
2GByte
to
>tape either.
>
>In order to create a file larger than 2GBytes on an HP-UX 10.20
file
system,
>you must have created the hfs or vxfs file system with the -o
largefiles
>option. You will then be able to write files larger than 2Gbytes
to the
>file system.
>
>Neil Truby
>aracnet Limited
>Weybridge, UK
>