Hello everyone!

Need help.... please!!!!!!!!!!

We try tu unload a table which is more than 2GB into a file. and it doesn't work.

We use IDS 9.4 on HP-UX serverk B.11.00 A 9000/802 (te)

$ ulimit
unlimited
$ ulimit -a
time(seconds) unlimited
file(blocks) unlimited
data(kbytes) 65536
stack(kbytes) 8192
memory(kbytes) unlimited
coredump(blocks) 4194303
nofiles(descriptors) 60

what should we do?
I head that 9.4 doesn't have any limitations...is that true?

I thank you in advance for any help I can get.

sshumilov@gmail.com wrote:
> Hello everyone!

Make sure that the filesystem you are trying to unload to is enabled/capable
of creating files larger than 2GB. Some UNIX filesystem types cannot
support them and others have to be configured for it.

Art S. Kagel

> Need help.... please!!!!!!!!!!
>
> We try tu unload a table which is more than 2GB into a file. and it doesn't work.
>
> We use IDS 9.4 on HP-UX serverk B.11.00 A 9000/802 (te)
>
> $ ulimit
> unlimited
> $ ulimit -a
> time(seconds) unlimited
> file(blocks) unlimited
> data(kbytes) 65536
> stack(kbytes) 8192
> memory(kbytes) unlimited
> coredump(blocks) 4194303
> nofiles(descriptors) 60
>
> what should we do?
> I head that 9.4 doesn't have any limitations...is that true?
>
> I thank you in advance for any help I can get.

I just ran into this problem.
Get with your UNIX admin - it is not an Informix limitation.
We had large file support enabled on the UNIX box but also had it on a
Service Guard cluster and had to make changes there for it to work.

Good Luck.

Tom


sshumilov@gmail.com wrote:
> Hello everyone!
>
> Need help.... please!!!!!!!!!!
>
> We try tu unload a table which is more than 2GB into a file. and it
doesn't work.
>
> We use IDS 9.4 on HP-UX serverk B.11.00 A 9000/802 (te)
>
> $ ulimit
> unlimited
> $ ulimit -a
> time(seconds) unlimited
> file(blocks) unlimited
> data(kbytes) 65536
> stack(kbytes) 8192
> memory(kbytes) unlimited
> coredump(blocks) 4194303
> nofiles(descriptors) 60
>
> what should we do?
> I head that 9.4 doesn't have any limitations...is that true?
>
> I thank you in advance for any help I can get.