ulimit for informix user.

[someone_4]

Hi everyone,

I am having problems finding something some information about the ulimit for the user informix. One of the dbas is trying to do an unload like so:

set pdqpriority 30;
unload to '/archive2/cdr_d_dest_feb.txt'
select * from cdr_d_dest where call_date
between '02/01/2002' and '02/28/2002';
order by call_date;

but she gets the error:

Write failed. 3852553 rows unloaded (check ulimit or disk space).

The size is 2147483647
on the file there is plenty of disk space in /archive2

for the user infomrix:
ulimit
4194303

Thanks
~ Richard

[James R. Ferguson · Accepted solution]

Hi Richard:

You need to enable 'largefiles' for the filesystem you are writing in. (2^31) -1 = 2147483647 ~ 2GB.

Regards!

...JRF...

[A. Clay Stephenson]

WEll that value of ulimit is 2GB - 4194393 x 512 bytes/block. I suspect that this user is using ksh and that is the maximum ulimit. You might try using the POSIX shell but I suspect that you are hitting a restriction in the informix code itself especially if this is 32-bit code. Not all code is able to use largefiles. Have you made sure that largefiles are enabled in this filesystem? That could easily be yoiur problem. Finally, you need to check to see if quotas are in play for this user.